Microsoft Excel - From Beginner to Expert in 6 Hours

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.
4.5 (2,992 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
61,815 students enrolled Bestselling in Excel
$19
$25
24% off
Take This Course
  • Lectures 83
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2013 English Closed captions available

Course Description

This course is for the benefit of everyone. If financial constraints prevent you from enrolling, simply send me a message explaining your situation and I will give you access to all of my courses for free.
A Verifiable Certificate of Completion is presented to all students who complete this Microsoft Excel class!

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:

  • Learn how to navigate around Excel
  • Learn how to enter and edit data in Excel
  • Learn how to adjust the way data and information are displayed in Excel
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to create powerful calculations with Excel functions
  • Learn how to visually represent your data with charts and graphs in Excel
  • Learn how to use Excel data tools like sorting, subtotaling, and filtering
  • Learn how to "freeze columns and rows" with freeze panes in Excel
  • Learn how to remove duplicates from data in Excel
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn how to automate Excel tasks with time-saving macros
  • Learn how to integrate Microsoft Excel with Microsoft Word
  • Learn how to use passwords in Excel to protect your work in multiple scenarios
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Learn how to use printing and sharing in Excel

As bonus material, you will also learn two very incredible, and super valuable, skills:

  • how to harvest data from the web
  • how to create online forms which allow you to gather data from individuals

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 “hands-on” 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.

What are the requirements?

  • In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel.

What am I going to get from this course?

  • Learn the most current version of Microsoft Excel
  • Learn from a Microsoft Certified Master Instructor with over 15 years of experience teaching individuals of all ability levels
  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
  • Presented with high-quality video lectures, this Excel course will visually show you how to easily do everything in Excel
  • Lifetime access to this Excel class allows you to easily review material and continue learning new material
  • Excel Project Files and Excel Templates are included allowing for enhanced learning through hands-on activities
  • After taking this training, you will be an expert at Microsoft Excel
  • Money Back Guarantee - Satisfaction Guaranteed or Your Money Back

What is the target audience?

  • From beginners, to advanced users, this course is perfect for all ability levels
  • Lifetime access to this Excel training allows you to come back to review material or learn more about MS Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Information
Screen Settings
Preview
01:35
1 question
The Quizzes Are Optional
01:18
4 questions
Getting Your Certificate of Completion
05:55
Getting Your Certificate of Completion
1 question
Course Files
Article
Section 2: Quick Start
Excel Quick Start
06:08
Relative References
Preview
04:04
Absolute References
Preview
05:14
Functions
05:47
Creating Charts
05:53
Calculating A Grade Example
15:39
Gathering Data With Google Forms
Preview
06:58
Section 3: Getting Started
07:46

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video, Course Overview, directly below!

Introduction To Excel
7 questions
06:47

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!

Writing Formulas
4 questions
03:04

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "WRITING FORMULAS" lecture above and then downloading the file from there!

Formula Essentials
4 questions
06:20
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "WRITING FORMULAS" lecture above and then downloading the file from there!
Relative, Absolute, and Mixed References
5 questions
Section 4: Working With Functions
07:08

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!

5 questions
05:55

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!

Payment Function & Loans
4 questions
05:02
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!
Future Value Function & Pensions
2 questions
02:36
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!
VLOOKUP Function & Gradebooks
2 questions
02:56
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!
IF, Concatenate, & Evaluation
2 questions
01:39
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!
Conditional Formatting
2 questions
03:04
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO FUNCTIONS" lecture above and then downloading the file from there!
IFERROR Function & Dynamic Amortization Tables
1 question
Section 5: Creating Charts & Graphs
04:11

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!

Visually Representing Data
3 questions
05:57

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "VISUALLY REPRESENTING DATA" lecture above and then downloading the file from there!

Creating Charts
4 questions
05:47

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "VISUALLY REPRESENTING DATA" lecture above and then downloading the file from there!

Formatting Charts
4 questions
06:54

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "VISUALLY REPRESENTING DATA" lecture above and then downloading the file from there!

Scatter Charts
3 questions
06:27

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "VISUALLY REPRESENTING DATA" lecture above and then downloading the file from there!

Combo Charts
3 questions
03:54

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "VISUALLY REPRESENTING DATA" lecture above and then downloading the file from there!

Pivot Charts
3 questions
Section 6: Harvesting Data From The Web
03:01

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!

Finding Data
2 questions
08:36

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Copying Data From The Web
2 questions
00:58

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Transposing Data
1 question
03:53

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Copying Data From The Web II
3 questions
09:23

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Parsing Data
3 questions
02:10

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Web Scraping Software
1 question
Section 7: Manipulating Data
01:44

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Freeze Panes
1 question
01:42

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Filtering Data
2 questions
03:21

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Removing Duplicates
2 questions
01:47

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Sorting Data
1 question
06:07

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "FINDING DATA" lecture above and then downloading the file from there!

Subtotaling Data
2 questions
08:55
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!
Data Tables
2 questions
Section 8: Advanced Filtering
11:22
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!
Exploring The Find Function
2 questions
02:41
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "EXPLORING THE FIND FUNCTION" lecture above and then downloading the file from there!
Exploring Filters Further
2 questions
11:44
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "EXPLORING THE FIND FUNCTION" lecture above and then downloading the file from there!
The Advanced Filter
2 questions
06:31
REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "EXPLORING THE FIND FUNCTION" lecture above and then downloading the file from there!
The Find Function II
2 questions
Section 9: Going Pro With Pivot Tables
02:44

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video directly below!

Introduction to Pivot Tables
2 questions
05:01

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO PIVOT TABLES" lecture above and then downloading the file from there!

Creating a Pivot Table
1 question
03:04

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO PIVOT TABLES" lecture above and then downloading the file from there!

Exploring Pivot Tables
2 questions
02:47

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO PIVOT TABLES" lecture above and then downloading the file from there!

Recommended Pivot Tables
1 question
03:14

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO PIVOT TABLES" lecture above and then downloading the file from there!

Grouping in Pivot Tables
3 questions
02:00

REMEMBER - if the video is blurry, click the "HD" button on the lower right area of the video and change the quality to the highest setting. You can DOWNLOAD the Excel spreadsheet used in this video by going to the "INTRODUCTION TO PIVOT TABLES" lecture above and then downloading the file from there!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Todd McLeod, Faculty in Computer Science and Computer Information Tech

I am passionate about helping others learn and improve their lives. The courses offered under my account are courses taught by myself, along with courses I helped friends create. As for my credentials, I am tenured faculty in Computer Information Technology at Fresno City College. I have also served as adjunct faculty in Computer Science at California State University, Fresno. I began programming in 1996. I began teaching programming in 2001. My area of expertise is web programming, the Go programming language, and online education. I have taught over 560,000 students online how to build websites and use the Go programming language. Follow me on Twitter to stay current @Todd_McLeod 

Ready to start learning?
Take This Course