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.

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
Excel Essential Skills

How to Create a List of Dates in Excel – Autofill Days, Weeks, Months, Years

Managing dates efficiently in Excel can significantly boost your productivity. In this blog post, I’ll show you how to create a list…

Read More How to Create a List of Dates in Excel – Autofill Days, Weeks, Months, Years
Excel Essential Skills

Excel – Why does the 0 (zero) disappear?

PROBLEM: why does the 0 (zero) disappear in Excel? How do I stop the 0 from disappearing? SOLUTION: learn how to stop zeros…

Read More Excel – Why does the 0 (zero) disappear?
Excel Organise, Analyse Data

Quickly Fill Blank Cells With Value Above In Excel

In this blog, we will explore a simple and efficient method to fill blank cells with the value above in Excel. This…

Read More Quickly Fill Blank Cells With Value Above In Excel
Word

How To Insert And Format Table Of Contents In Microsoft Word

Learning how to insert and format Table of Contents in Microsoft Word is a fantastic way to keep things organised and easy…

Read More How To Insert And Format Table Of Contents In Microsoft Word