This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part 1 (Desktop/Office 365) or Microsoft Office Excel 2019: Part 1 courses and will help start participants down the road to creating advanced workbooks and worksheets that participants can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion of this course, students will be able to:
Create range names and advanced formulas.
Automate workbook functionality.
Apply conditional logic.
Visualize data by creating basic charts.
Create trendline and sparkline charts.
Use PivotTables, PivotCharts, and slicers to create a dashboard.

  • Using Names in Formulas and Functions

  • Examine Dashboards
    Use Range Names in Formulas
    Use Specialized Functions

  • Automating Workbook Functionality

  • Apply Data Validation
    Work with Forms and Controls

  • Applying Conditional Logic

  • Use Lookup Functions
    Combine Functions

  • Visualizing Data with Basic Charts

  • Create Charts
    Modify and Format Charts

  • Using Advanced Charting Techniques

  • Create Dual-Axis Charts and Trendlines
    Create Sparklines

  • Analyzing Data with PivotTables, PivotCharts, and Slicers

  • Create a PivotTable
    Analyze PivotTable Data
    Present Data with PivotCharts
    Filter Data by Using Slicers


This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to summarize table data by using functions, charts, and PivotTables, and display those elements in a dashboard format.




While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.


Length: 1.0 day (8 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.