Jan 29, 20232 minLet's Make a Date!Excel has over 30 data and time functions. We step you though each one with examples.
Jan 27, 20232 minVital Excel Skills on Your Résumé in 2023Employers 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 minExcel: Good & Bad HabitsExcel is a powerful tool, but when used incorrectly or carelessly it can lead to serious consequences.
Jan 6, 20231 minExcel'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 minMastering Excel: Impress Your BossBy 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 23, 20222 minData Analytics are Catching-OnAustralian businesses leveraging customer & staff data can raise their revenue by about 10 per cent, according to Deloitte's 2022 research.
Sep 29, 20224 minUnderstanding & Dealing with Excel Errors.Understand, avoid and fix these frustrating Excel errors and warnings.
Sep 24, 20224 minEasily Trap & Handle Excel Formula & Function ErrorsEasily Trap & Handle the inevitable and annoying Excel Formula & Function Errors.
Jul 8, 20221 minXLOOKUP vs. VLOOKUPXLOOKUP is considered to be an improvement over VLOOKUP because it has several additional capabilities that VLOOKUP does not have.
Jun 9, 20222 minExcel's New XLOOKUP FunctionExcel'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 minAn Excel Covid-19 DebacleThe incompetent use of an outdated version of Excel resulted in nearly 16,000 unreported Covid-19 positive cases in England