top of page
9am to 9pm 7 days

COMDEX TRAINING CENTRE



Excel Data Cleaning Techniques
Tools and techniques to cleanse your Excel data
Oct 9, 20235 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.
Apr 20, 20237 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.
Jan 6, 20231 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.
Dec 2, 20221 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 24, 20222 min read


Easily Trap & Handle Excel Formula & Function Errors
Easily Trap & Handle the inevitable and annoying Excel Formula & Function Errors.
Sep 24, 20224 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 9, 20222 min read
MYOB Xero Power-BI Excel
BLOG & NEWS

Updates straight to your inbox
bottom of page