• To understand how to write and use advanced formulas with functions including text,
date, logical, conditional, and lookup functions
• To organize worksheet and table data using various techniques
• To create and modify charts
• To analyze data using PivotTables, Slicers, and PivotCharts
• Insert and modify graphic objects in a worksheet
• Customize and enhance workbooks and the Microsoft Office Excel environment
Physical with Laptop
The Intermediate Microsoft Excel course provides insight into some of the more advanced
functions of Excel for anyone looking to develop their Excel skills further. From pivot tables and
charts, to functions and formulas, you will be equipped with the knowledge and skills you need to
work with Excel on a more advanced level both at home and at work.
• Analysts
• Administrative staff
• Executives
• Managers
