What you will learn in the course
The Microsoft Excel Intermediate course is targeted for Excel users who would like to upgrade their understanding of performing calculations and data analyses using Microsoft Excel.
The course will introduce you to advanced functions such as conditional mathematics, date and time functions, logical functions, text functions, and lookup functions.
You will also get started with data analysis using pivot tables and pivot charts.
Example Curriculum
Week 1
Available in
days
days
after you enroll
Week 2: Tables and conditional formatting
Available in
days
days
after you enroll
- Creating tables (2:30)
- Modifying tables (3:40)
- Sorting data in tables (1:35)
- Filtering data in tables (5:58)
- Structured referencing (4:39)
- Introduction to conditional formatting (1:34)
- Using built-in conditional formatting (5:41)
- Custom conditional formatting (6:17)
- Conditional formatting using formulas (6:15)
Week 3: Conditional calculations
Available in
days
days
after you enroll
Week 4: Logical, date and time functions
Available in
days
days
after you enroll
Week 5: Text and lookup functions
Available in
days
days
after you enroll
Week 6: Charts, pivot tables and pivot charts
Available in
days
days
after you enroll
- Criteria for choosing a type of chart (9:07)
- Creating bar and column charts (11:28)
- Introduction to chart customization (6:57)
- Customizing bar and column charts (5:20)
- Creating and customizing line charts (6:45)
- Creating and customizing pie charts (5:36)
- Creating and customizing combo charts (4:04)
- Creating and customizing sparklines (5:21)
- Introduction to pivot tables (2:13)
- Using automatic pivot tables (5:19)
- Creating a pivot table from scratch (6:33)
- Creating calculated fields in the pivot table (1:54)
- Sorting and filtering pivot tables (6:14)
- Customizing pivot tables (5:19)
Join the full course
Get this course, plus 7 other self-paced courses including all our weekly live sessions for a low monthly or yearly subscription