This training provides you everything you need to know about Microsoft Excel.
From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.
You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course covers the most recent version of Microsoft Excel. As tenured college faculty in computer information technology, and with over fifteen years of experience teaching individuals of all ability levels “how to use” Microsoft Excel, Todd McLeod has designed, refined, and perfected a method for understanding Excel which will allow you to learn what you need to know about Microsoft Excel as quickly and efficiently as possible.
In only five hours of videos, provided to you in 75 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:
As bonus material, you will also learn two very incredible, and super valuable, skills:
As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “handson” approach to learning the material. You will also be shown how to find and download free “Excel templates” which are spreadsheet templates that you can use like “budget templates” or a “calendar template” or a “schedule template.”
Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.
This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.
Section 1: Course Information  

Lecture 1 
Screen Settings

01:35  
Quiz 1 
Screen Settings Quiz

1 question  
Lecture 2 
The Quizzes Are Optional

01:18  
Quiz 2 
The Quizzes Are Optional

4 questions  
Lecture 3 
Getting Your Certificate of Completion

05:55  
Quiz 3 
Getting Your Certificate of Completion

1 question  
Lecture 4 
Course Files

Article  
Section 2: Quick Start  
Lecture 5 
Excel Quick Start

06:08  
Lecture 6 
Relative References

04:04  
Lecture 7 
Absolute References

05:14  
Lecture 8 
Functions

05:47  
Lecture 9 
Creating Charts

05:53  
Lecture 10 
Calculating A Grade Example

15:39  
Lecture 11 
Gathering Data With Google Forms

06:58  
Section 3: Getting Started  
Lecture 12 
Introduction To Excel

07:46  
Quiz 4 
Introduction To Excel

7 questions  
Lecture 13 
Writing Formulas

06:47  
Quiz 5 
Writing Formulas

4 questions  
Lecture 14 
Formula Essentials

03:04  
Quiz 6 
Formula Essentials

4 questions  
Lecture 15 
Relative, Absolute, & Mixed References

06:20  
Quiz 7 
Relative, Absolute, and Mixed References

5 questions  
Section 4: Working With Functions  
Lecture 16 
Introduction to Functions

07:08  
Quiz 8 
Introduction to Functions

5 questions  
Lecture 17 
Payment Function & Loans

05:55  
Quiz 9 
Payment Function & Loans

4 questions  
Lecture 18 
Future Value Function & Pensions

05:02  
Quiz 10 
Future Value Function & Pensions

2 questions  
Lecture 19 
VLOOKUP Function & Gradebooks

02:36  
Quiz 11 
VLOOKUP Function & Gradebooks

2 questions  
Lecture 20 
IF, Concatenate, & Evaluation

02:56  
Quiz 12 
IF, Concatenate, & Evaluation

2 questions  
Lecture 21 
Conditional Formatting

01:39  
Quiz 13 
Conditional Formatting

2 questions  
Lecture 22 
IFERROR Function & Dynamic Amortization Tables

03:04  
Quiz 14 
IFERROR Function & Dynamic Amortization Tables

1 question  
Section 5: Creating Charts & Graphs  
Lecture 23 
Visually Representing Data

04:11  
Quiz 15 
Visually Representing Data

3 questions  
Lecture 24 
Creating Charts

05:57  
Quiz 16 
Creating Charts

4 questions  
Lecture 25 
Formatting Charts

05:47  
Quiz 17 
Formatting Charts

4 questions  
Lecture 26 
Scatter Charts

06:54  
Quiz 18 
Scatter Charts

3 questions  
Lecture 27 
Combo Charts

06:27  
Quiz 19 
Combo Charts

3 questions  
Lecture 28 
Pivot Charts

03:54  
Quiz 20 
Pivot Charts

3 questions  
Section 6: Harvesting Data From The Web  
Lecture 29 
Finding Data

03:01  
Quiz 21 
Finding Data

2 questions  
Lecture 30 
Copying Data From The Web

08:36  
Quiz 22 
Copying Data From The Web

2 questions  
Lecture 31 
Transposing Data

00:58  
Quiz 23 
Transposing Data

1 question  
Lecture 32 
Copying Data From The Web II

03:53  
Quiz 24 
Copying Data From The Web II

3 questions  
Lecture 33 
Parsing Data

09:23  
Quiz 25 
Parsing Data

3 questions  
Lecture 34 
Web Scraping Software

02:10  
Quiz 26 
Web Scraping Software

1 question  
Section 7: Manipulating Data  
Lecture 35 
Freeze Panes

01:44  
Quiz 27 
Freeze Panes

1 question  
Lecture 36 
Filtering Data

01:42  
Quiz 28 
Filtering Data

2 questions  
Lecture 37 
Removing Duplicates

03:21  
Quiz 29 
Removing Duplicates

2 questions  
Lecture 38 
Sorting Data

01:47  
Quiz 30 
Sorting Data

1 question  
Lecture 39 
Subtotaling Data

06:07  
Quiz 31 
Subtotaling Data

2 questions  
Lecture 40 
Data Tables

08:55  
Quiz 32 
Data Tables

2 questions  
Section 8: Advanced Filtering  
Lecture 41 
Exploring The Find Function

11:22  
Quiz 33 
Exploring The Find Function

2 questions  
Lecture 42 
Exploring Filters Further

02:41  
Quiz 34 
Exploring Filters Further

2 questions  
Lecture 43 
The Advanced Filter

11:44  
Quiz 35 
The Advanced Filter

2 questions  
Lecture 44 
The Find Function II

06:31  
Quiz 36 
The Find Function II

2 questions  
Section 9: Going Pro With Pivot Tables  
Lecture 45 
Introduction to Pivot Tables

02:44  
Quiz 37 
Introduction to Pivot Tables

2 questions  
Lecture 46 
Creating a Pivot Table

05:01  
Quiz 38 
Creating a Pivot Table

1 question  
Lecture 47 
Exploring Pivot Tables

03:04  
Quiz 39 
Exploring Pivot Tables

2 questions  
Lecture 48 
Recommended Pivot Tables

02:47  
Quiz 40 
Recommended Pivot Tables

1 question  
Lecture 49 
Grouping in Pivot Tables

03:14  
Quiz 41 
Grouping in Pivot Tables

3 questions  
Lecture 50 
Using “Slicers” in Pivot Tables

02:00  
Quiz 42 
Using “Slicers” in Pivot Tables

3 questions  
Lecture 51 
Creating Pivot Charts

02:47  
Quiz 43 
Creating Pivot Charts

2 questions  
Section 10: Formatting For Impact  
Lecture 52 
Formatting Your Worksheet

02:37  
Quiz 44 
Formatting Your Worksheet

2 questions  
Lecture 53 
Formatting Essentials

03:51  
Quiz 45 
Formatting Essentials

3 questions  
Lecture 54 
Formatting Fundamentals

04:11  
Quiz 46 
Formatting Fundamentals

3 questions  
Lecture 55 
Design Considerations

03:46  
Quiz 47 
Design Considerations

4 questions  
Lecture 56 
Inserting & Deleting Cells, Columns, & Rows

01:22  
Quiz 48 
Inserting & Deleting Cells, Columns, & Rows

1 question  
Lecture 57 
Formatting Options

05:00  
Quiz 49 
Formatting Options

3 questions  
Lecture 58 
Formatting Examples

05:00  
Quiz 50 
Formatting Examples

3 questions  
Lecture 59 
Formatting Secrets

06:35  
Quiz 51 
Formatting Secrets

3 questions  
Section 11: Saving Time With Macros  
Lecture 60 
Understanding Macros

06:24  
Quiz 52 
Understanding Macros

4 questions  
Lecture 61 
Macro Automation

06:04  
Quiz 53 
Macro Automation

4 questions  
Section 12: Integrating Word & Excel  
Lecture 62 
Object Linking & Embedding

06:40  
Quiz 54 
Object Linking & Embedding

3 questions  
Section 13: Securing Your Work  
Lecture 63 
Securing Your Worksheets

07:24  
Quiz 55 
Securing Your Worksheets

1 question  
Lecture 64 
Securing Your Workbooks

05:24  
Quiz 56 
Securing Your Workbooks

5 questions  
Section 14: Printing & Sharing Your Work  
Lecture 65 
Preparing To Print

06:27  
Quiz 57 
Preparing To Print

6 questions  
Lecture 66 
Printing & Sharing

04:09  
Quiz 58 
Printing & Sharing

3 questions  
Section 15: Enhancing Your Value with Bonus Skills  
Lecture 67 
Awesome Stuff With Google

06:48  
Quiz 59 
Awesome Stuff With Google

5 questions  
Lecture 68 
Google Form Examples

03:35  
Quiz 60 
Google Form Examples

5 questions  
Section 16: HandsOn: Creating A Gradebook  
Lecture 69 
Creating A Gradebook

01:58  
Lecture 70 
Initial Considerations

03:11  
Lecture 71 
Tracking Attendance

08:00  
Lecture 72 
Gradebook Adjustments

02:38  
Lecture 73 
Entering and Adjusting Data

02:51  
Lecture 74 
Entering Formulas and Functions

03:40  
Lecture 75 
Automated Error Checking

02:47  
Lecture 76 
Calculating All Grades

05:10  
Lecture 77 
Looking Up The Letter Grade

03:22  
Lecture 78 
Freeze Panes and Sorting

02:21  
Section 17: HandsOn: Bringing Grades From Blackboard Into Excel  
Lecture 79 
Importing Data From Blackboard

09:41  
Section 18: HandsOn: Creating A Loan Amortization  
Lecture 80 
Creating A Loan Amortization Schedule

08:54  
Section 19: Templates  
Lecture 81 
Templates Shown Throughout Course

Article  
Section 20: Final Exam  
Quiz 61 
Final Exam

54 questions  
Section 21: Just For Fun!  
Lecture 82 
Bloopers

02:49  
Section 22: Farewell  
Lecture 83 
Until We Meet Again!

00:52 
Todd McLeod, Faculty in Computer Science and Computer Information Tech
I am faculty in Computer Science at California State University, Fresno. I am also faculty in Computer Information Technology at Fresno City College. I began programming in 1983 in the BASIC language. I began teaching programming in 2002.