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.

Jan 11, 20244 min read

Excel Data Cleaning Techniques

Tools and techniques to cleanse your Excel data

Oct 9, 20235 min read

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

Apr 20, 20237 min read

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.

Dec 1, 20221 min read

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

Oct 23, 20222 min read

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 9, 20222 min read