Microsoft Excel Advanced

About the course

For those who already work confidently in Excel, this course unlocks its most powerful capabilities. Excel Advanced is designed to help you move from everyday user to true spreadsheet power user.

You'll master nested and advanced logic functions, explore multi-condition lookups, create sophisticated charts and dive deep into PivotTables, relationships and Power Query. The course also introduces dynamic arrays — including FILTER and SORT — and covers real-time collaboration and advanced workbook protection.

If your work involves complex reporting, data transformation or large datasets, this course gives you the tools to work faster, smarter and with far greater accuracy.

Address for In Person sessions:

ICTS Training room 102.1
Level 1, Kramer Law building
UCT Middle Campus
Rondebosch

Course content

• Use advanced functions: nested IF, IFS, SUMIFS, COUNTIFS, TEXTJOIN and SWITCH
• Perform advanced lookups including two-way and multiple-match using XLOOKUP
• Create and format advanced charts, sparklines and funnel charts
• Conduct an in-depth exploration of PivotTables, PivotCharts and data relationships
• Transform and model data using Power Query and Power Pivot
• Work with dynamic arrays using FILTER and SORT functions
• Manage 3D models and complex workbook structures
• Apply advanced workbook protection and real-time collaboration features

Certification

On successful completion of this course, participants receive a UCT ICTS Certificate of Completion. Attendance at all four sessions is required. Participants who miss more than one session will not qualify for certification.

Cost and registration

• External delegates: R1,500 - enrol directly through The Learning Store (below)
• UCT staff (permanent and T1–T2 contractors): No cost - register via SuccessFactors
• UCT staff with third party accounts: No cost - request a discount voucher code from icts-training@uct.ac.za BEFORE enrolling for the course

NB: Alternative (free) learning resource for staff and students: LinkedIn Learning

More Information

Read more: Microsoft Excel Advanced
Email: icts-training@uct.ac.za
Phone: +27 (0)21 650 5392