Home | Courses | Microsoft Training Courses | Microsoft Excel Training Courses | Microsoft Excel Dashboards Training
excel

Microsoft Excel Dashboards Training

Course Duration: 1 Day

This Course Covers Version(s): Excel 2019, 2021 and 365

  • Live Class with Instructor
  • Digital Course Manual
  • Hands-on Labs
  • Up to 1 Year Access to Recorded Course

In this one-day Microsoft Excel Dashboards training class, students will learn how to create dashboards in Microsoft Excel to enable actionable insights from data. Students will see how to use tables with sorting and filtering to select data, how to create charts and implement best practices for chart design in Excel, how to use formulas, functions and perform data validation on their data and use PivotTables and PivotCharts in Excel to visually display data trends. The course wraps up by showing students how to pull all of these components together in a dashboard that can help support quick, timely business decisions based on data.

Upon successful completion of this class, students will be able to:

  • Perform data analysis fundamentals
  • Visualize data with Excel
  • Analyze data with formulas and functions
  • Analyze data with PivotTables
  • Present visual insights with dashboards in Excel

Some previous experience using Excel to create worksheets is helpful in this class.

This course is for any student who wants to learn more about creating dashboards using Microsoft Excel.

  1. Data Analysis Fundamentals

    • Introduction to Data Science
    • Create and Modify Tables
    • Sort and Filter Data

  2. Visualizing Data with Excel

    • Visualize Data with Charts
    • Modify and Format Charts
    • Apply Best Practices in Chart Design

  3. Analyzing Data with Formulas and Functions

    • Analyze Data with Formulas and Named Ranges
    • Analyze Data with Functions
    • Implement Data Validation, Forms, and Controls
    • Create Conditional Visualizations with Lookup Functions

  4. Analyzing Data with PivotTables

    • Create a PivotTable
    • Analyze PivotTable Data

  5. Presenting Visual Insights with Dashboards in Excel

    • Visualize Data with PivotCharts
    • Filter Data Using Slicers and Timelines
    • Create a Dashboard in Excel

  6. Appendix A: Using Lookup Functions

This course does not align to a specific exam or certification.

Live Instructor-Led Virtual Class
$295.00
Click here to load this Caspio Online Database.
Questions? View Our Live, Instructor-Led Virtual Class FAQs
Virtual or In-Person Group Training

  • For Private Groups as small as 2 people.
  • Live, Instructor-led Online or Onsite Class for your group.
  • Customizable to your needs.
Click here to load this Caspio Online Database.

Questions? Contact Us
Click here to load this Caspio Online Database.