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