Excel Intermediate

Course curriculum

1. What is covered in this course
  FREE PREVIEW
1. 3D Reference: Getting Started
2. Creating a 3D Reference using Multiple Worksheets
3. Linking Files
1. Sorting Issues (Part 1)
2. Sorting Issues (Part 2)
3. Creating a Custom Sort list
4. Sorting by Color
1. Filter by Color and using Advanced Filters
2. Using Filters with the SUBTOTAL Function
1. Tables: Getting Started
2. Add Running Totals Column
1. Introduction to Sparklines
2. Sparklines - Mini Charts
3. Sparklines on Separate Worksheet
4. Five Tips for Sparklines
1. Fixing missing data
2. Correcting Data
1. Subtotals
2. Creating an Outline of a Worksheet
1. How to pull data from the web
2. How to add a Blank row after every Row
3. How to separate Positive and Negative values in the same column
1. Conditional Formatting with Mixed and Absolute Reference
2. Using Conditional Formatting to highlight every Nth row
3. Conditional Formatting with Dates using TODAY function
4. Conditional Formatting example Excercise
5. Multiple Conditional Formatting with Copilot
6. Copilot Conditional Formatting: 90,000 Records
1. Dynamic Charts
2. Excel Charts: 5 Tips
3. Colour Coded Percentage Chart (S&P500 Data)
4. Chart from a Large Data set with Copilot
1. Breakeven age for Full vs Early retirement benefits
2. Homeowners' Loan Amortization schedule
  FREE PREVIEW
3. Finding and Removing Duplicates - Part 1
4. Find and Remove Duplicates - Part 2 - Keep most recent
5. 6 NEW Features in Excel on the Web

Enroll today