Digital SkillsProductivityMEAL1 100% HRDF claimable

Microsoft Excel Advanced – Level I

Strengthen your ability to work with complex formulas, manage data across multiple worksheets and workbooks, and apply Excel features to improve accuracy and control in daily reporting. Use advanced functions, automate input, protect data, and audit formulas.

1 DayPEOPLElogy

What you'll learn

Apply advanced text, logical, date, and lookup functions
Construct dynamic formulas across worksheets and workbooks
Implement data validation rules to control input
Protect Excel files, workbooks, worksheets, and ranges
Audit formulas using Excel's formula auditing tools

Course modules (5)

01Advanced text, logical, date/time functions

02Advanced lookup (INDEX/MATCH)

03Multiple worksheets and 3D references

04Data validation and input control

05Workbook protection and auditing