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
Excel Navigator
5 days ago3 min read
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
0 comments
Excel Navigator
5 days ago3 min read
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.
0 comments
Excel Navigator
Jan 193 min read
Concatenate cell values in Excel with TEXTJOIN
Learn how to combine text from multiple Excel cells with TEXTJOIN, including across no continuous arrays or arrays with blank values.
0 comments
Excel Navigator
Dec 8, 20244 min read
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.
0 comments
Excel Navigator
Nov 24, 20242 min read
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.
0 comments
Excel Navigator
Nov 17, 20244 min read
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.
0 comments
Excel Navigator
Nov 10, 20242 min read
Dynamically format text in Excel with the UPPER, LOWER and PROPER functions
Lear how to easily and quickly change text case in Excel cells using the UPPER, LOWER and PROPER functions.
0 comments
Excel Navigator
Nov 5, 20243 min read
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.
0 comments
Excel Navigator
Oct 31, 20243 min read
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
0 comments
Excel Navigator
Oct 20, 20244 min read
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.
0 comments
Excel Navigator
Oct 13, 20243 min read
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.
0 comments
Excel Navigator
Oct 6, 20243 min read
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.
0 comments
Excel Navigator
Oct 2, 20242 min read
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.
0 comments
Excel Navigator
Sep 22, 20244 min read
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.
0 comments
Excel Navigator
Sep 15, 20244 min read
Calculate Workdays Between Dates in Excel with NETWORKDAYS and NETWORKDAYS.INTL
Calculate only working days between two dates excluding weekends and holidays, and optionally change the dates treated as weekends.
0 comments
Excel Navigator
Sep 8, 20243 min read
Date Formats in Excel
Learn how Excel handles dates as serial numbers, tips for formatting dates, how to create custom date displays and understand common errors
0 comments
Excel Navigator
Sep 2, 20242 min read
Calculate Filtered or Hidden Ranges in Excel with SUBTOTAL
Calculate only visable values in a range by excluding filtered or hidden rows using the SUBTOTAL function.
0 comments
Excel Navigator
Aug 25, 20243 min read
Create Custom Error Outputs in Excel With IFERROR
Create custom error outputs and messages in Excel to help improve error handling for calculations using the IFERROR function.
0 comments
Excel Navigator
Aug 18, 20244 min read
Group Rows and Columns in Excel
Group and ungroup data in Excel to dynamically hide or display segments in a data set.
0 comments
Excel Navigator
Aug 11, 20244 min read
Use New Window to View Multiple Windows in Excel
Use the New Window feature to compare data and manage large workbooks in Excel by being able to see multiple versions of the same workbook.
0 comments
bottom of page