Feb 13, 20232 min read

Excel's Sparklines - Simply Sparkle

Sparklines are a powerful tool for visualising data trends and patterns, and they can be a useful addition to any Excel workbook.

Jan 29, 20232 min read

Let's Make a Date!

Excel has over 30 data and time functions. We step you though each one with examples.

Jan 27, 20232 min read

Vital Excel Skills on Your Résumé in 2023

Employers often look for a variety of skills when hiring for a job working with data. Here are 15 essential Excel skills to win that job.

Jan 24, 20233 min read

Excel: Good & Bad Habits

Excel is a powerful tool, but when used incorrectly or carelessly it can lead to serious consequences.

Jan 6, 20231 min read

Excel's Fantastic Flash Fill. Magic!

Excel's Flash Fill feature is a powerful tool that allows you to quickly fill in a range of cells with data that follows a pattern.

Dec 28, 20221 min read

Mastering Excel: Impress Your Boss

By adding one or more of these tricks to your skillset, you'll improve productivity, become a wizard at distilling and analysing data and be

Sep 29, 20224 min read

Understanding & Dealing with Excel Errors.

Understand, avoid and fix these frustrating Excel errors and warnings.

Sep 24, 20224 min read

Easily Trap & Handle Excel Formula & Function Errors

Easily Trap & Handle the inevitable and annoying Excel Formula & Function Errors.

Jul 8, 20221 min read

XLOOKUP vs. VLOOKUP

XLOOKUP is considered to be an improvement over VLOOKUP because it has several additional capabilities that VLOOKUP does not have.

Jun 9, 20222 min read

Excel's New XLOOKUP Function

Excel's XLOOKUP function allows you to look up a value in a range of cells and return a corresponding value from a different range of cells.

May 13, 20213 min read

An Excel Covid-19 Debacle

The incompetent use of an outdated version of Excel resulted in nearly 16,000 unreported Covid-19 positive cases in England

MYOB Xero Power-BI Excel

BLOG & NEWS