1 - Working with Functions
Topic A: Work with RangesTopic B: Use Specialized FunctionsTopic C: Work with Logical FunctionsTopic D: Work with Date and Time FunctionsTopic E: Work with Text Functions
2 - Working with Lists
Topic A: Sort DataTopic B: Filter DataTopic C: Query Data with Database FunctionsTopic D: Outline and Subtotal Data
3 - Analyzing Data
Topic A: Create and Modify TablesTopic B: Apply Intermediate Conditional FormattingTopic C: Apply Advanced Conditional Formatting
4 - Visualizing Data with Charts
Topic A: Create ChartsTopic B: Modify and Format ChartsTopic C: Use Advanced Chart Features
5 - Using PivotTables and PivotCharts
Topic A: Create a PivotTableTopic B: Analyze PivotTable DataTopic C: Present Data with PivotChartsTopic D: Filter Data by Using Timelines and Slicers
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
To ensure success, students should have completed Microsoft® Office Excel® 2019: Part 1 or have the equivalent knowledge and experience.