About this course
Learn to navigate the Excel interface and manage workbooks for a strong foundation.
Before We Begin
1 Parts
- 0:20 Hr
Before we Begin
20 Min
Chapter 1: Getting Started with Excel
2 Parts
- 1:00 Hr
Excel Interface Overview
30 Min
Working with Workbooks
30 Min
Chapter 2: Data Entry and Formatting
3 Parts
- 1:30 Hr
Entering and Editing Data
30 Min
Formatting Data
30 Min
Understanding Data Types
30 Min
Chapter 3: Data Cleaning and Structuring
2 Parts
- 1:00 Hr
Cleaning Data
30 Min
Using Excel Tables
30 Min
Chapter 4: Sorting and Filtering Data
2 Parts
- 1:00 Hr
Sorting Data
30 Min
Filtering Data
30 Min
Chapter 5: Formulas and Statistical Functions
2 Parts
- 1:00 Hr
Formula Basics
30 Min
Mathematical and Statistical Functions
30 Min
Chapter 6: Logical and Lookup Functions
2 Parts
- 1:00 Hr
Logical Functions
30 Min
Lookup Functions
30 Min
Chapter 7: Text Functions and Conditional Formatting
2 Parts
- 1:00 Hr
Text Functions
30 Min
Conditional Formatting
30 Min
Chapter 8: Data Validation and Charts
2 Parts
- 1:00 Hr
Data Validation
30 Min
Creating Charts
30 Min
Chapter 9: PivotTables and PivotCharts
2 Parts
- 1:00 Hr
Creating PivotTables
30 Min
Creating PivotCharts
30 Min
Chapter 10: Power Query Basics and Best Practices
2 Parts
- 1:00 Hr
Introduction to Power Query
30 Min
Excel Best Practices
30 Min
Capstone Projects
1 Parts
- 1:40 Hr
Personal Budget Tracker
100 Min
No Reviews Yet