1 - Working with Functions and Complex Calculations
Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)Work with Logical FunctionsWork with Lookup FunctionsWork with Date and Time FunctionsWork with Text Functions
2 - Working with Lists and Tables
Sort and Filter DataRemove Duplicate ValuesGroup and Outline Data Subtotal Data
3 - Visualizing Data with Charts
Create and Modify ChartsUse Advanced Chart FeaturesSave a Custom Chart Template
4 - Using Tables, Pivot Table Reports and Pivot Charts
Create and Modify TablesUse Functions to Calculate in TablesCreate a Pivot Table ReportManipulate Pivot TablesPresent Data with Pivot ChartsFilter Data by Using Slicers and Timelines
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.