Curriculum
6 Sections
29 Lessons
10 Weeks
Expand all sections
Collapse all sections
Introduction to Spreadsheet
7
1.1
Introduction
1.2
Data Entry and Editing
1.3
Formatting a spreadsheet
1.4
Managing Worksheets
1.5
Sorting and Filtering Data
1.6
Data Types and Formatting Data in Excel
1.7
Introduction to Data Visualization
Data Manipulation
5
2.1
Working with Various Data Types
2.2
Cleaning Spreadsheet Data
2.3
Analyzing Excel Data
2.4
Understanding Data Anomalies
2.5
Finding Data Anomalies
Introduction to Statistics
3
3.1
Summarizing Data Using Descriptive Statistics
3.2
Measures of Central Tendency and Spread
3.3
Samples and Distributions
Data Modelling
8
4.1
Basic Spreadsheet Functions and Conditionals in Excel
4.2
Conditional Formatting in Excel
4.3
Nesting Conditionals in Excel
4.4
Identifying Patterns in Data
4.5
Creating a Line of Best Fit
4.6
Predicting Future Values with the Line of Best Fit
4.7
Testing Assumptions in Excel
4.8
Testing Model Accuracy in Excel
Power Query
2
5.1
Introduction to Power Query
5.2
Loading Data into Excel and Automating Data Refresh
Power Pivot
4
6.1
Introduction
6.2
Key Features of Power Pivot
6.3
Using Power Pivot for Data Analysis
6.4
Best Practices for Using Power Pivot
Data Preparation with Ms. Excel
Search
This content is protected, please
login
and enroll in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content