Excel for Data Analysis v1.0

This course teaches students how to use Excel for data analysis, helping them understand fundamental terminology, principles, and approaches used in working with data.

Course curriculum

1. Welcome to your course!
1. 1.1 Introduction
2. 1.2 What is Excel?
3. 1.3 Excel Versions
4. 1.4 Application Interface
5. 1.5 The Basics
6. 1.6 Useful Shortcuts
7. 1.7 Data Sets
8. 1.8 The Ecosystem
9. Test Your Knowledge Quiz
1. 2.1 Referencing Single Cells & Cell Ranges - Part 1
2. 2.2 Referencing Named Ranges
3. 2.3 Referencing Tables
4. 2.4 Referencing Split Ranges - Part 1
5. 2.5 Referencing Split Ranges - Part 2
6. 2.6 Autofill & References
7. 2.7 Tools that Rely on References
8. 2.8 Making Named Ranges Dynamic
9. 2.9 Referencing Columns
10. Test Your Knowledge Quiz
1. 3.1 Function Basics - Part 1
2. 3.2 Function Basics - Part 2
3. 3.3 Function Categories
4. Test Your Knowledge Quiz
1. 4.1 Text Functions - Part 1
2. 4.2 Text Functions - Part 2
3. 4.3 Wildcards
4. Test Your Knowledge Quiz
1. 5.1 Logical Functions - Part 1
2. 5.2 Logical Functions - Part 2
3. Test Your Knowledge Quiz
1. 6.1 Mathematical Functions – Part 1
2. 6.2 Mathematical Functions – Part 2
3. 6.3 Mathematical Functions – Part 3
4. 6.4 Mathematical Functions – Part 4
5. Test Your Knowledge Quiz
1. 7.1 Statistical Functions - Part 1
2. 7.2 Statistical Functions - Part 2
3. Test Your Knowledge Quiz
1. 8.1 Lookup & Reference Functions - Part 1
2. 8.2 Lookup & Reference Functions - Part 2
3. 8.3 Lookup & Reference Functions - Part 3
4. Test Your Knowledge Quiz
1. 9.1 Date & Time Functions
2. 9.2 COUNTD Alternatives
3. Test Your Knowledge Quiz
1. 10.1 Dynamic Array Function Basics
2. 10.2 Dynamic Array Function - Part 1
3. 10.3 Dynamic Array Function - Part 2
4. 10.4 Dynamic Array Function - Part 3
5. 10.5 Dynamic Array Function - Part 4
6. 10.6 Dynamic Array Function - Part 5
7. 10.7 Dynamic Array Function - Part 6
8. 10.8 Dynamic Array Function - Part 7
9. 10.9 Dynamic Array Function - Part 8
10. 10.10 Dynamic Array Function - Part 9
11. Test Your Knowledge Quiz
1. 11.1 Error Handling
2. Test Your Knowledge Quiz
1. 12.1 Introduction
2. 12.2 Home Tab
3. 12.3 Transform Tab
4. 12.4 Transform Tab
5. 12.5 Add Column
6. 12.6 View Tab
7. 12.7 Filtering Values
8. 12.8 Appending Data
9. 12.9 Merging Data
10. 12.10 Load To
11. Test Your Knowledge Quiz
1. 13.1 Introduction
2. 13.2 Relationships - Part 1
3. 13.3 Relationships - Part 2
4. 13.4 Relationships - Part 3
5. 13.5 Relationships - Part 4
6. 13.6 Relationships - Part 5
7. Test Your Knowledge Quiz
1. 14.1 Basics
2. 14.2 Slicers
3. 14.3 Layout Options
4. 14.4 Field Header Filters
5. 14.5 Tips & Tricks
6. 14.6 Calculated Fields
7. 14.7 Calculated Items - Part 1
8. 14.8 Calculated Items - Part 2
9. Test Your Knowledge Quiz
1. 15.1 Basics
2. 15.2 Calculated Columns
3. 15.3 Iterator Functions
4. 15.4 CALCULATE
5. 15.5 ALL
6. 15.6 RELATE
7. 15.7 SWITCH and SWITCH TRUE
8. 15.8 Time Intelligence
9. Test Your Knowledge Quiz
1. 16.1 Basics
2. 16.2 Optimisation Tricks
3. 16.3 Additional Chart Types
4. 16.4 Scatter Chart Types
5. 16.5 Positioning Charts
6. 16.6 Saving Custom Chart Styles
7. Test Your Knowledge Quiz
1. 17.1 Conditional Formatting
2. Test Your Knowledge Quiz
1. 18.1 Creating Dashboards
2. Test Your Knowledge Quiz
1. 19.1 What to Use When
1. 20.1 Closing Words
1. Data Analysis Tutorbot: Scarlette
2. Excel Layout Keyboard Shortcuts
3. Datasets
4. Power Query & Power Pivot Datasets
5. Breakdown of Excel Ecosystem
6. Common DAX Functions
7. Excel Layout Keyboard Shortcuts
8. Excel Product Suite
9. Join Types & Join Relationships
10. What is Excel?
1. Course Feedback Form

About this course

119 lessons

ITonlinelearning Academy

Excel for Data Analysis v1.0

Course curriculum

Introduction

Module 1 : Overview

Module 2 : Referencing

Module 3 : Function

Module 4 : Text Functions

Module 5 : Logical Functions

Module 6 : Mathematical Functions

Module 7 : Statistical Functions

Module 8 : Lookup & Reference Functions

Module 9 : Additional Functions

Module 10 : Dynamic Array Functions

Module 11 : Error Handling

Module 12 : Power Query

Module 13 : Power Pivot

Module 14 : Pivot Table

Module 15 : DAX Funtions

Module 16 : Charts

Module 17 : Formatting

Module 18 : Dashboards

Module 19 : When to Use Excel Features

Module 20 : Conclusion

Study Resources

Course Feedback

About this course

Discover your potential, starting today