Jan 114 min read

Excel's Hidden Power: The Camera Tool!

Create live, updateable images of data ranges or charts within Excel, turning static data into dynamic visual elements.

Oct 9, 20235 min read

Excel Data Cleaning Techniques

Tools and techniques to cleanse your Excel data

Apr 20, 20237 min read

Power Query, Power Pivot, Power BI. Confused?

We clarify the distinct, but sometimes inter-related features of these powerful Microsoft analytic 'Power' tools.

Mar 3, 20233 min read

It's 2023, time you started using Excel's A.I. (no coding or formulas required!)

A powerful new tool that uses artificial intelligence to assist in data analysis.

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.

Dec 2, 20221 min read

Power BI Sample Job Interview Q&A

Know your DAX from your DBA, or your metadata from your multi-dimensional? Prepare for your job interview with our sample Power BI Q&A.

Oct 24, 20222 min read

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.

Oct 14, 20222 min read

10 Steps to Protect You From Ransomware

Protect your computer from the increasingly malicious and frequent ransomware attacks. Don't be an unwitting victim.

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.

Jun 14, 20211 min read

Cultivating Digital Skills

According to accredited research, 87 per cent of Australia's jobs now require essential digital skills.

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