Course Length: 2-days
Course Overview
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using Pivot Tables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel. This is an Excel Boot camp that would incorporate most topics covered in the Specialized Excel Courses.
Learn a game-changing way to look at how you communicate with visuals. Move away from putting data on a slide for others to figure out, towards a place where you can communicate specific messages in a compelling fashion.
Prerequisites
Excel - Data Analysis and Forecasting Advanced
Course Outline
Analyzing and Visualizing Data for Business
- Data Analysis Scenarios
- Visualize Data with Charts
- Modify and Format Charts
Analyzing Data with Formulas and Functions
- Analyze Data with Formulas
- Analyze Data with Functions
- Analyze Data with Data Validation, Forms, and Controls
Creating Conditional Visualizations
- Use Lookup Functions
- Combine Functions
Creating PivotTables, PivotCharts, and Slicers
- Create a PivotTable
- Analyze PivotTable Data
- Visualize Data with PivotCharts
- Filter Data Using Slicers
Presenting Data in an Excel Dashboard
- Dashboard Planning
- Create a Dashboard in Excel
Performing Statistical Analysis
- Visualize Trendlines and Sparklines with Excel
- Install and Activate the Data Analysis ToolPak
Getting and Transforming Data
- Connect to Data with Queries
- Clean and Combine
- Shape and Transform Data
Modeling and Analyzing Data with Power Pivot
- Install Power Pivot in Excel
- Create Data Models with Power Pivot
- Create Power Pivots
- Perform Advanced Data Analysis and Visualization
Creating Geospatial Visualizations with Excel
- Create Map Charts in Excel
- Format and Customize Map Charts in Excel