Skip to main content
Data Analysis with Excel
My Courses
College Courses
Professional Channels
My Courses
Chemistry
General Chemistry
Organic Chemistry
Analytical Chemistry
GOB Chemistry
Biochemistry
Intro to Chemistry
Biology
General Biology
Microbiology
Anatomy & Physiology
Genetics
Cell Biology
Math
College Algebra
Trigonometry
Precalculus
Physics
Physics
Business
Microeconomics
Macroeconomics
Financial Accounting
Social Sciences
Psychology
Programming
Introduction to Python
Microsoft Power BI
Data Analysis - Excel
Introduction to Blockchain
HTML, CSS & Layout
Introduction to JavaScript
R Programming
Product & Marketing
Agile & Product Management
Digital Marketing
Project Management
AI in Marketing
Channels Home
Learn
Bookmarks
Table of contents
Skip to main content
Introduction
4m
Worksheet
Introduction
4m
1: Getting Started with Data Analysis with Excel
8m
Worksheet
Learning objectives
0m
1.1 Discuss course style
1m
1.2 Introduce the Data Lifecycle
4m
1.3 Understand Excel versions
1m
2: Using Get and Transform Data
2h 6m
Worksheet
Learning objectives
2m
2.1 Introduce Get and Transform data
11m
2.2 Load an Excel spreadsheet
6m
2.3 Load a folder of data
10m
2.4 Load data from a website
5m
2.5 Understand data source settings
6m
2.6 Introduce the Power Query Editor
7m
2.7 Remove columns
7m
2.8 Filter rows
8m
2.9 Rename columns and set data types
5m
2.10 Add new columns
5m
2.11 Append queries
5m
2.12 Merge queries
7m
2.13 Transform and cleanse data
11m
2.14 Unpivot data
13m
2.15 Better manage Get and Transform
10m
3: Structuring and Referencing Data for Analysis within Excel
55m
Worksheet
Learning objectives
1m
3.1 Review cell reference styles and types
4m
3.2 Use names in Excel
5m
3.3 Structure data within Excel tables
12m
3.4 Review formulas, functions, and compatibility
4m
3.5 Spill data with dynamic arrays
7m
3.6 Troubleshoot spill errors
3m
3.7 Understand implicit intersection
4m
3.8 Apply concepts for a data analysis solution
11m
4: Utilizing Best Practices for Preparing and Analyzing Data
2h 15m
Worksheet
Learning objectives
2m
4.1 Design complex Excel models
1m
4.2 Author formulas for complex models
9m
4.3 Implement and maintain data integrity
17m
4.4 Create a reusable data quality dashboard
37m
4.5 Design a Budget and Forecast model
16m
4.6 Identify required data structures and functions
10m
4.7 Populate data within the model
25m
4.8 Highlight results and data insights
15m
5: Authoring Interactive Reports
1h 35m
Worksheet
Learning objectives
1m
5.1 Create and understand basic PivotTables
11m
5.2 Interact with a PivotTable
5m
5.3 Understand layout options
6m
5.4 Format PivotTables
11m
5.5 Use PivotTable commands
8m
5.6 Filter and sort data in a PivotTable
15m
5.7 Review chart types
2m
5.8 Create PivotCharts
16m
5.9 Format PivotCharts
9m
5.10 Create an interactive dashboard
7m
6: Setting up for Collaboration and Distribution
51m
Worksheet
Learning objectives
1m
6.1 Inspect a document for issues
5m
6.2 Check for accessibility and compatibility
8m
6.3 Use collaboration and distribution features
13m
6.4 Protect sheet contents and workbook structure
13m
6.5 Setup a printable package
8m
Summary
1m
Worksheet
Data Analysis Fundamentals with Excel: Summary
1m
2: Using Get and Transform Data
2.12 Merge queries
2: Using Get and Transform Data
2.12 Merge queries - Video Tutorials & Practice Problems
Video duration:
7m
Play a video:
Previous Topic: 2.11 Append queries
Next Topic: 2.13 Transform and cleanse data
0