Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - From Beginner to Expert in 6 Hours to your Wishlist.

Add to Wishlist

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.
Bestselling
4.5 (3,649 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.
64,323 students enrolled
Created by Todd McLeod
Last updated 5/2015
English English
$10 $25 60% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.

Who 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
Students Who Viewed This Course Also Viewed
What Will I Learn?
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
View Curriculum
Requirements
  • In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel.
Curriculum For This Course
Expand All 83 Lectures Collapse All 83 Lectures 06:33:17
+
Course Information
4 Lectures 09:01

Screen Settings Quiz
1 question

The Quizzes Are Optional
01:18

The Quizzes Are Optional
4 questions

Getting Your Certificate of Completion
05:55

Getting Your Certificate of Completion
1 question

Course Files
00:13
+
Quick Start
7 Lectures 49:43
Excel Quick Start
06:08



Functions
05:47

Creating Charts
05:53

Calculating A Grade Example
15:39

+
Getting Started
4 Lectures 23: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, Course Overview, directly below!

Preview 07:46

Introduction To Excel
7 questions

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
06:47

Writing Formulas
4 questions

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
03:04

Formula Essentials
4 questions

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, & Mixed References
06:20

Relative, Absolute, and Mixed References
5 questions
+
Working With Functions
7 Lectures 28: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 directly below!

Introduction to Functions
07:08

Introduction to Functions
5 questions

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
05:55

Payment Function & Loans
4 questions

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
05:02

Future Value Function & Pensions
2 questions

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
02:36

VLOOKUP Function & Gradebooks
2 questions

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
02:56

IF, Concatenate, & Evaluation
2 questions

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
01:39

Conditional Formatting
2 questions

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
03:04

IFERROR Function & Dynamic Amortization Tables
1 question
+
Creating Charts & Graphs
6 Lectures 33: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 directly below!

Preview 04:11

Visually Representing Data
3 questions

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
05:57

Creating Charts
4 questions

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
05:47

Formatting Charts
4 questions

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
06:54

Scatter Charts
3 questions

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
06:27

Combo Charts
3 questions

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
03:54

Pivot Charts
3 questions
+
Harvesting Data From The Web
6 Lectures 28: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
03:01

Finding Data
2 questions

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
08:36

Copying Data From The Web
2 questions

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
00:58

Transposing Data
1 question

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
03:53

Copying Data From The Web II
3 questions

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
09:23

Parsing Data
3 questions

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
02:10

Web Scraping Software
1 question
+
Manipulating Data
6 Lectures 23: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!

Freeze Panes
01:44

Freeze Panes
1 question

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
01:42

Filtering Data
2 questions

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
03:21

Removing Duplicates
2 questions

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
01:47

Sorting Data
1 question

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
06:07

Subtotaling Data
2 questions

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
08:55

Data Tables
2 questions
+
Advanced Filtering
4 Lectures 32:18
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
11:22

Exploring The Find Function
2 questions

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
02:41

Exploring Filters Further
2 questions

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
11:44

The Advanced Filter
2 questions

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
06:31

The Find Function II
2 questions
+
Going Pro With Pivot Tables
7 Lectures 21:37

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
02:44

Introduction to Pivot Tables
2 questions

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
05:01

Creating a Pivot Table
1 question

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
03:04

Exploring Pivot Tables
2 questions

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
02:47

Recommended Pivot Tables
1 question

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
03:14

Grouping in Pivot Tables
3 questions

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!

Using "Slicers" in Pivot Tables
02:00

Using "Slicers" in Pivot Tables
3 questions

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 Pivot Charts
02:47

Creating Pivot Charts
2 questions
+
Formatting For Impact
8 Lectures 32: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!

Formatting Your Worksheet
02:37

Formatting Your Worksheet
2 questions

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

Formatting Essentials
03:51

Formatting Essentials
3 questions

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

Formatting Fundamentals
04:11

Formatting Fundamentals
3 questions

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

Design Considerations
03:46

Design Considerations
4 questions

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

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

Inserting & Deleting Cells, Columns, & Rows
1 question

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

Formatting Options
05:00

Formatting Options
3 questions

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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!

Formatting Examples
05:00

Formatting Examples
3 questions

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 spreadsheets used in this video by going to the "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there AND ALSO by download the separate file from directly below!

Formatting Secrets
06:35

Formatting Secrets
3 questions
12 More Sections
About the Instructor
4.5 Average rating
7,382 Reviews
116,073 Students
11 Courses
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 

Report Abuse