Excel Intermediate

Buy $14.99 Free Preview

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
3. Slicers for data filtering
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
4. Separate Date and Time: 2 Dynamic Methods
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
6. Finding Unique Values: 3 Methods
7. NEW Feature: Focus Cell

About this course

$14.99
42 lessons
3.5 hours of video content

Discover your potential, starting today

Enroll today

Chris Menard Training

Excel Intermediate

Course curriculum

Introduction

3D Reference and Linking

Sorting

Filter Data

Using Tables

Sparklines

Fixing missing and incorrect Data

Subtotals and Outlining Data

Importing and Organising data

Conditional Formatting

Charts

NEW Lessons

About this course

Discover your potential, starting today