top of page

Typing

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

Extract text in Excel with the TEXTBEFORE and TEXTAFTER functions

Extract text in Excel with the TEXTBEFORE and TEXTAFTER functions

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

Dynamically format text in Excel with the UPPER, LOWER and PROPER functions

Dynamically format text in Excel with the UPPER, LOWER and PROPER functions

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

Using the TIME function in Excel

Using the TIME function in Excel

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

Time formats in Excel

Time formats in Excel

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

Use the TEXT function to format dates in concatenations in Excel

Use the TEXT function to format dates in concatenations in Excel

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

Use EDATE to Calculate Future and Past Dates in Excel

Use EDATE to Calculate Future and Past Dates in Excel

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

Calculate Month End and Start Dates with EOMONTH in Excel

Calculate Month End and Start Dates with EOMONTH in Excel

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

Add Comment To Excel Formulas With The N Function

Add Comment To Excel Formulas With The N Function

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

Find the Workday Before or After a Date in Excel with WORKDAY and WORKDAY.INTL

Find the Workday Before or After a Date in Excel with WORKDAY and WORKDAY.INTL

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

Calculate Workdays Between Dates in Excel with NETWORKDAYS and NETWORKDAYS.INTL

Calculate Workdays Between Dates in Excel with NETWORKDAYS and NETWORKDAYS.INTL

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.

Excel Navigator

Sep 15, 20244 min read

Date Formats in Excel

Date Formats in Excel

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

Excel Navigator

Sep 8, 20243 min read

Calculate Filtered or Hidden Ranges in Excel with SUBTOTAL

Calculate Filtered or Hidden Ranges in Excel with SUBTOTAL

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.

Excel Navigator

Sep 2, 20242 min read

Create Custom Error Outputs in Excel With IFERROR

Create Custom Error Outputs in Excel With IFERROR

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.

Excel Navigator

Aug 25, 20243 min read

Group Rows and Columns in Excel

Group Rows and Columns in Excel

Group Rows and Columns in Excel

Group and ungroup data in Excel to dynamically hide or display segments in a data set.

Excel Navigator

Aug 18, 20244 min read

Use New Window to View Multiple Windows in Excel

Use New Window to View Multiple Windows in Excel

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.

Excel Navigator

Aug 11, 20244 min read

Remove Gridlines From Excel Worksheets

Remove Gridlines From Excel Worksheets

Remove Gridlines From Excel Worksheets

Learn how to remove gridlines in one or multiple Excel worksheets.

Excel Navigator

Aug 4, 20242 min read

Freeze Columns and Rows in Excel Using Freeze Panes

Freeze Columns and Rows in Excel Using Freeze Panes

Freeze Columns and Rows in Excel Using Freeze Panes

Keep rows and columns visible when scrolling through large datasets in Excel worksheets with the Freeze Panes option.

Excel Navigator

Jul 28, 20245 min read

Hardcoding v Cell Referencing in Excel Formulas

Hardcoding v Cell Referencing in Excel Formulas

Hardcoding v Cell Referencing in Excel Formulas

Understand the difference between hardcoding and cell referencing in Excel formulas, and best practices for flexible, accurate calculations.

Excel Navigator

Jul 21, 20244 min read

Relative, Absolute and Mixed References in Excel

Relative, Absolute and Mixed References in Excel

Relative, Absolute and Mixed References in Excel

Discover how to manage formulas and avoid errors in your calculations by understanding relative, absolute and mixed references.

Excel Navigator

Jul 14, 20245 min read

Translate Foreign Languages in Excel

Translate Foreign Languages in Excel

Translate Foreign Languages in Excel

Learn how to translate text in Excel using the built-in translator feature. Quick, easy steps to handle multiple languages efficiently.

Excel Navigator

Jul 2, 20244 min read

bottom of page