Course Details
Course Outline
1 - Data Analysis Fundamentals
Introduction to Data ScienceCreate and Modify TablesSort and Filter Data
2 - Visualizing Data with Excel
Visualize Data with ChartsModify and Format ChartsApply Best Practices in Chart Design
3 - Analyzing Data with Formulas and Functions
Analyze Data with Formulas and Named RangesAnalyze Data with FunctionsImplement Data Validation, Forms, and ControlsCreate Conditional Visualizations with Lookup Functions
4 - Analyzing Data with PivotTables
Create a PivotTableAnalyze PivotTable Data
5 - Presenting Visual Insights with Dashboards in Excel
Visualize Data with PivotChartsFilter Data Using Slicers and TimelinesCreate a Dashboard in Excel
6 - Creating Geospatial Visualizations with Excel
Create Map Charts in ExcelCustomize Map Charts in Excel
7 - Performing Statistical Analysis
Visualize Trendlines and Sparklines with ExcelAnalyze Data with the Data Analysis ToolPa
8 - Getting and Transforming Data
Connect to Data with QueriesClean and Combine DataShape and Transform Data
9 - Modeling and Analyzing Data with Power Pivot
Install Power Pivot in ExcelCreate Data Models with Power PivotCreate Power PivotsPerform Advanced Data Analysis and Visualization
10 - Presenting Insights with Reports (Optional)
Plan a ReportCreate a Report
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
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 PivotTables, 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.
Other Prerequisites
To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function