Author: Sharyn Baines

Sharyn Baines is a Certified Microsoft® Office Specialist with over 20 years of experience helping professionals become confident and efficient Excel users. She runs Excel at Work, delivering live and self-paced Excel training to thousands of learners across New Zealand and beyond.

Word

How to Add Page Numbers in Word – Starting on a Specific Page

Page numbers in Word can be quite tricky at times, and I often hear from my students about the frustration this can…

Read More How to Add Page Numbers in Word – Starting on a Specific Page
Excel Combine, Analyse, Report

How to Compare Two Lists in Excel Using XLOOKUP

If you’ve ever tried to compare two lists in Excel and ended up scrolling up and down, highlighting rows, and still feeling…

Read More How to Compare Two Lists in Excel Using XLOOKUP
Excel Essential Skills

How to use Copilot Formula Completion in Excel (Beginner’s guide)

If you’ve ever looked at a blank cell and wondered which function to use, what range to select, or where the commas…

Read More How to use Copilot Formula Completion in Excel (Beginner’s guide)
Excel Organise, Analyse Data

Excel Count cells with Text (3 easy functions + 9 valuable formula examples)

Are you trying to count cells with text in Excel? Are you wondering why the COUNT function in Excel returns 0? You’re…

Read More Excel Count cells with Text (3 easy functions + 9 valuable formula examples)
Excel Organise, Analyse Data

Excel NOT Function: Quickly Flag Exceptions with Reverse Logic

As a busy professional, it’s frustrating when your spreadsheet only tells you what is true, rather than what isn’t. That’s where the…

Read More Excel NOT Function: Quickly Flag Exceptions with Reverse Logic
Excel Organise, Analyse Data

Excel IFS Function: Replace Nested IFs

If you’ve ever felt overwhelmed trying to wrangle a long, nested IF formula, the Excel IFS Function is going to be your…

Read More Excel IFS Function: Replace Nested IFs
Excel Organise, Analyse Data

Excel OR Function: How to Test Either Condition in Excel

If you’ve ever needed to check if at least one of several conditions is true in your Excel data, you’re not alone!…

Read More Excel OR Function: How to Test Either Condition in Excel
Excel Organise, Analyse Data

Excel AND Function: How to Test Multiple Conditions

If you’ve ever found yourself second-guessing your Excel formulas, you’re not alone! Many business professionals I work with want to ensure their…

Read More Excel AND Function: How to Test Multiple Conditions
Excel Organise, Analyse Data

How to Use the IF Function in Excel (Beginner’s Guide)

Ever wondered how to make Excel do the thinking for you? The IF function is your go-to tool for making decisions in…

Read More How to Use the IF Function in Excel (Beginner’s Guide)
Excel Essential Skills

Formula for Total in Excel: How to Choose the Right Option

Struggling to figure out the right formula for total in Excel? You’re not alone. Excel has several different ways to total numbers,…

Read More Formula for Total in Excel: How to Choose the Right Option
Excel Combine, Analyse, Report

Trim Function Not Working in Excel? Fix It Without Formulas

Have you ever used the TRIM formula, pressed Enter, and nothing happened? If the Trim function isn’t working in Excel, you’re not…

Read More Trim Function Not Working in Excel? Fix It Without Formulas
Excel Combine, Analyse, Report

Use TRIM with SUBSTITUTE Function in Excel to Remove Spaces the TRIM Function Misses

Have you ever used the TRIM function in Excel, only to find that it didn’t remove all the spaces and isn’t working as…

Read More Use TRIM with SUBSTITUTE Function in Excel to Remove Spaces the TRIM Function Misses