Jan 29, 20232 min

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

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

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

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

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

Oct 24, 20222 min

Data Analytics are Catching-On

Australian businesses leveraging customer & staff data can raise their revenue by about 10 per cent, according to Deloitte's 2022 research.

Sep 29, 20224 min

Understanding & Dealing with Excel Errors.

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

Sep 24, 20224 min

Easily Trap & Handle Excel Formula & Function Errors

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

Jul 8, 20221 min

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

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

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