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
Creating Geospatial Visualizations with Excel
- Create Map Charts in Excel
- Customize Map Charts in Excel
Performing Statistical Analysis
- Visualize Trendlines and Sparklines with Excel
- Analyze Data with the Data Analysis ToolPak
- Getting and Transforming Data
- Connect to Data with Queries
- Clean and Combine Data
- 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
Presenting Insights with Reports (Optional)
- Plan a Report
- Create a Report