top of page
Blog
Our blog covers all things Excel, aiming to make complex Excel concepts accessible and engaging to all Excel users, so whether you are a beginner or more experienced there will be something for you.​
​
Many of our blogs have Excel files that you can download to follow along and get hands on experience applying Excel concepts.
​
​If there's a particular Excel feature or function you're curious about, or if you have suggestions for topics you'd like us to cover please get in touch.
Search
Using LEN in Excel to get the total number of characters in a cell
Find out the number of letters, numbers, spaces and characters in a cell with the LEN function in Excel.
Excel Navigator
5 days ago3 min read
0 comments
Use the DAY, MONTH, YEAR and TEXT functions to extract date components in Excel
Extract day, month, or year from dates in Excel using DAY, MONTH, YEAR or get text formats like "Monday" or "Jan" with the TEXT function.
Excel Navigator
Apr 72 min read
0 comments
Extract text in Excel with the LEFT, RIGHT and MID functions
Extract specific parts of text strings in Excel with the LEFT, RIGHT and MID functions.
Excel Navigator
Mar 233 min read
0 comments
Remove trailing, leading and extra spaces in Excel with the TRIM function
Use the TRIM function in Excel to remove trailing, leading and extra spaces from text, clean up messy datasets and nest TRIM in functions.
Excel Navigator
Mar 92 min read
0 comments
Use the STOCKHISTORY function in Excel
Get historic stock prices in Excel using the STOCKHISTORY function. See closing, opening high and low values either daily, weekly or monthly
Excel Navigator
Feb 233 min read
0 comments
Calculate loan repayments in Excel with the PMT function
Learn how to use the PMT function in Excel to calculate loan repayments, including annual, monthly, and quarterly options.
Excel Navigator
Feb 163 min read
0 comments
Calculate the internal rate of return in Excel with IRR and XIRR
Discover the difference between the IRR and XIRR functions in Excel and learn when to use each to calculate accurate internal rate of return
Excel Navigator
Feb 93 min read
0 comments
Calculate net present value in Excel with NPV and XNPV
Discover the difference between the NPV and XNPV functions in Excel and learn when to use each to calculate accurate net present value.
Excel Navigator
Feb 93 min read
0 comments
Concatenate cell values in Excel with TEXTJOIN
Learn how to combine text from multiple Excel cells with TEXTJOIN, including across non continuous arrays or arrays with blank values.
Excel Navigator
Jan 193 min read
0 comments
Split text across columns and rows in Excel using TEXTSPLIT
Use TEXTSPLIT to split text in a cell by delimiters across multiple columns and rows dynamically.
Excel Navigator
Dec 8, 20244 min read
0 comments
Combine TEXTBEFORE and TEXTAFTER to get text between delimiters in Excel
Nest a TEXTBEFORE function in a TEXTAFTER function to be able to extract text between two delimiters in text in a cell in Excel.
Excel Navigator
Nov 24, 20242 min read
0 comments
Extract text in Excel with the TEXTBEFORE and TEXTAFTER functions
Extract text before and after delimiters in cells in Excel, and change the instance of the delimiter or output if a delimiter is not found.
Excel Navigator
Nov 17, 20244 min read
0 comments
Dynamically format text in Excel with the UPPER, LOWER and PROPER functions
Learn how to easily and quickly change text case in Excel cells using the UPPER, LOWER and PROPER functions.
Excel Navigator
Nov 10, 20242 min read
0 comments
Using the TIME function in Excel
Use the TIME function in Excel to create custom time calculations, calculate time increments and link time values to cells.
Excel Navigator
Nov 5, 20243 min read
0 comments
Time formats in Excel
Learn Excel's time format basics: how decimal values represent time, tips for formatting, and ways to customize hours, minutes, and seconds
Excel Navigator
Oct 31, 20243 min read
0 comments
Use the TEXT function to format dates in concatenations in Excel
Format dates in concatenations in Excel so that the date output shows in the format you choose rather than the underlying serial number.
Excel Navigator
Oct 20, 20244 min read
0 comments
Use EDATE to Calculate Future and Past Dates in Excel
Automatically get the same date a fixed number of months ahead or behind a start date using the EDATE function in Excel.
Excel Navigator
Oct 13, 20243 min read
0 comments
Calculate Month End and Start Dates with EOMONTH in Excel
Dynamically calculate the month end and start date a fixed number of months ahead or behind a given date, or for the current month.
Excel Navigator
Oct 6, 20243 min read
0 comments
Add Comment To Excel Formulas With The N Function
Add comments to Excel formulas and functions that return a numeric value using the N function.
Excel Navigator
Oct 2, 20242 min read
0 comments
Find the Workday Before or After a Date in Excel with WORKDAY and WORKDAY.INTL
Find the next working day a specified number of days before or after a date by excluding weekends and optionally excluding holidays.
Excel Navigator
Sep 22, 20244 min read
0 comments
bottom of page