Table of contents
- Introduction4m
- 1: Getting Started with Data Analysis with Excel8m
- 2: Using Get and Transform Data2h 6m
- Learning objectives2m
- 2.1 Introduce Get and Transform data11m
- 2.2 Load an Excel spreadsheet6m
- 2.3 Load a folder of data10m
- 2.4 Load data from a website5m
- 2.5 Understand data source settings6m
- 2.6 Introduce the Power Query Editor7m
- 2.7 Remove columns7m
- 2.8 Filter rows8m
- 2.9 Rename columns and set data types5m
- 2.10 Add new columns5m
- 2.11 Append queries5m
- 2.12 Merge queries7m
- 2.13 Transform and cleanse data11m
- 2.14 Unpivot data13m
- 2.15 Better manage Get and Transform10m
- 3: Structuring and Referencing Data for Analysis within Excel55m
- Learning objectives1m
- 3.1 Review cell reference styles and types4m
- 3.2 Use names in Excel5m
- 3.3 Structure data within Excel tables12m
- 3.4 Review formulas, functions, and compatibility4m
- 3.5 Spill data with dynamic arrays7m
- 3.6 Troubleshoot spill errors3m
- 3.7 Understand implicit intersection4m
- 3.8 Apply concepts for a data analysis solution11m
- 4: Utilizing Best Practices for Preparing and Analyzing Data2h 15m
- Learning objectives2m
- 4.1 Design complex Excel models1m
- 4.2 Author formulas for complex models9m
- 4.3 Implement and maintain data integrity17m
- 4.4 Create a reusable data quality dashboard37m
- 4.5 Design a Budget and Forecast model16m
- 4.6 Identify required data structures and functions10m
- 4.7 Populate data within the model25m
- 4.8 Highlight results and data insights15m
- 5: Authoring Interactive Reports1h 35m
- Learning objectives1m
- 5.1 Create and understand basic PivotTables11m
- 5.2 Interact with a PivotTable5m
- 5.3 Understand layout options6m
- 5.4 Format PivotTables11m
- 5.5 Use PivotTable commands8m
- 5.6 Filter and sort data in a PivotTable15m
- 5.7 Review chart types2m
- 5.8 Create PivotCharts16m
- 5.9 Format PivotCharts9m
- 5.10 Create an interactive dashboard7m
- 6: Setting up for Collaboration and Distribution51m
- Summary1m
3: Structuring and Referencing Data for Analysis within Excel
3.5 Spill data with dynamic arrays
3: Structuring and Referencing Data for Analysis within Excel
3.5 Spill data with dynamic arrays: Videos & Practice Problems
Video duration:
7mPlay a video: