1. Essential Excel Functions
- SUM
- ROUND
- ROUNDUP
- ROUNDDOWN
- ABS
- MOD
- INT
Advanced Microsoft Excel course, designed for professionals who work with large datasets, complex calculations, and business reporting. This hands-on course focuses on powerful Excel features that help automate tasks, analyse data efficiently, and create professional, interactive reports.
Throughout the course, you will master advanced formulas and functions, dynamic arrays, XLOOKUP, PivotTables, PivotCharts, Power Query, data validation, conditional formatting, financial and statistical functions, dashboards, and introductory VBA automation. You will also learn how to clean and transform data, perform what-if analysis, build interactive dashboards, and automate repetitive tasks using macros.
By the end of the course, you will be able to design sophisticated Excel workbooks, create insightful business reports, automate manual processes, and make data-driven decisions with confidence. This course is ideal for business professionals, data analysts, finance teams, project managers, HR professionals, and anyone looking to maximise productivity and unlock the full potential of Microsoft Excel.
Course Prerequisites:
Knowledge of Basic Microsoft Excel
If, Nested If, Ifs, Switch, And, Or, Not, Xor, Iferror, Ifna
VLOOKUP , HLOOKUP, XLOOKUP, XMATCH, INDEX, MATCH, INDEX + MATCH, CHOOSE, OFFSET, INDIRECT
TODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, DATEDIF, EDATE, EOMONTH, WORKDAY, NETWORKDAYS
FILTER , SORT , SORTBY, UNIQUE, SEQUENCE, RANDARRAY, TEXTSPLIT, TEXTAFTER, TEXTBEFORE