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.

Power Query, Power Pivot, Power BI. Confused?

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

Let's Make a Date!

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

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.

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.

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.

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.

MYOB Xero Power-BI Excel

BLOG & NEWS