Course Overview
Advance your Excel proficiency by exploring tools and techniques used in data analysis, automation, and workbook management. This hands-on course equips professionals with the ability to audit, protect, and customize complex workbooks using advanced functions and macros. You will work with PivotTables, conditional formulas, and data extraction tools to produce actionable insights and manage dynamic spreadsheets.
With the skills gained in this course, you will be able to create and modify spreadsheets using advanced Excel tools to improve data integrity, workflow automation, and reporting accuracy.
It is recommended that you complete CCTO240, Microsoft Excel Level ll, or have equivalent skills before enrolling in this course.