Microsoft Excel: Dashboards

Hours: 6.00 | Estimated Cost: $179.00

This seminar is designed for participants who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality. Microsoft Excel: Dashboards will expand your knowledge by utilizing functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.

Additional Information

• Learn About

  * Performing data analysis fundamentals
  * Visualizing data with Excel
  * Analyzing data with formulas and functions
  * Analyzing data with PivotTables
  * Presenting visual insights with dashboards in Excel

• Benefits & Outcomes

  * Learn how to analyze data with formulas, functions and PivotTables
  * Learn how to create effective visuals to help others gain insights into your data

• Training Outline

  **Data Analysis Fundamentals**
  * Introduction to Data Science
  * Create and Modify Tables
  * Sort and Filter Data
  
  **Visualizing Data with Excel**
  * Visualize Data with Charts
  * Modify and Format Charts
  * Apply Best Practices in Chart Design
  
  **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
  
  **Analyzing Data with PivotTables**
  * Create a PivotTable
  * Analyze PivotTable Data
  
   **Presenting Visual Insights with Dashboards in Excel**
  * Visualize Data with PivotCharts
  * Filter Data Using Slicers and Timelines
  * Create a Dashboard in Excel