Thebestexcel Course
Tags: Excel
This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.
Last updated 2022-01-10 | 4.6
- Learn Microsoft Excel 2013- Learn from a Microsoft Certified Master Instructor with over 20 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
What you'll learn
* Requirements
* In order to participate in the hands-on portions of this course* you will need to have Microsoft Excel.
Description
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 provides comprehensive coverage on Microsoft Excel. A university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Microsoft Excel.
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
how to harvest data from the web
how to create online forms which allow you to gather data from individuals
Download all of the Excel project files that are used in the videos
This class is guaranteed to teach you Microsoft 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 this course is for:
- 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
Course content
21 sections • 140 lectures
Excel Quick Start Preview 06:08
Relative References Preview 04:04
Absolute References Preview 05:14
Functions Preview 05:47
Creating Charts Preview 05:53
Calculating A Grade Example Preview 15:39
Gathering Data With Google Forms Preview 06:58
Introduction To Excel Preview 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
Writing Formulas Preview 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
Formula Essentials Preview 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
Relative, Absolute, & Mixed References Preview 06:20
Relative, Absolute, and Mixed References
Introduction to Functions Preview 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!
Introduction to Functions
Payment Function & Loans Preview 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
Future Value Function & Pensions Preview 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
VLOOKUP Function & Gradebooks Preview 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
IF, Concatenate, & Evaluation Preview 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
Conditional Formatting Preview 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
IFERROR Function & Dynamic Amortization Tables Preview 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
Visually Representing Data Preview 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
Creating Charts Preview 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
Formatting Charts Preview 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
Scatter Charts Preview 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
Combo Charts Preview 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
Pivot Charts Preview 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
Finding Data Preview 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
Copying Data From The Web Preview 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
Transposing Data Preview 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
Copying Data From The Web II Preview 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
Parsing Data Preview 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
Web Scraping Software Preview 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
Freeze Panes Preview 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
Filtering Data Preview 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
Removing Duplicates Preview 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
Sorting Data Preview 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
Subtotaling Data Preview 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
Data Tables Preview 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
Exploring The Find Function Preview 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
Exploring Filters Further Preview 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
The Advanced Filter Preview 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
The Find Function II Preview 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
Introduction to Pivot Tables Preview 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
Creating a Pivot Table Preview 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
Exploring Pivot Tables Preview 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
Recommended Pivot Tables Preview 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
Grouping in Pivot Tables Preview 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
Using "Slicers" in Pivot Tables Preview 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!
Using "Slicers" in Pivot Tables
Creating Pivot Charts Preview 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!
Creating Pivot Charts
Formatting Your Worksheet Preview 02: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!
Formatting Your Worksheet
Formatting Essentials Preview 03:51
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
Formatting Fundamentals Preview 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 by going to the "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!
Formatting Fundamentals
Design Considerations Preview 03: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 by going to the "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!
Design Considerations
Inserting & Deleting Cells, Columns, & Rows Preview 01: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 by going to the "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!
Inserting & Deleting Cells, Columns, & Rows
Formatting Options Preview 05: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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!
Formatting Options
Formatting Examples Preview 05: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 "FORMATTING YOUR WORKSHEET" lecture above and then downloading the file from there!
Formatting Examples
Formatting Secrets Preview 06:35
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
Understanding Macros Preview 06:24
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!
Understanding Macros
Macro Automation Preview 06: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 "UNDERSTANDING MACROS" lecture above and then downloading the file from there!
Macro Automation
Object Linking & Embedding Preview 06:40
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 files used in this video directly below!
Object Linking & Embedding
Securing Your Worksheets Preview 07:24
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!
Securing Your Worksheets
Securing Your Workbooks Preview 05:24
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 "SECURING YOUR WORKSHEETS" lecture above and then downloading the file from there!
Securing Your Workbooks
Preparing To Print Preview 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 directly below!
Preparing To Print
Printing & Sharing Preview 04:09
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 "PREPARING TO PRINT" lecture above and then downloading the file from there!
Printing & Sharing
Awesome Stuff With Google Preview 06:48
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. This video shows you how to work with google spreadsheets and google forms which are both found in google drive.
Awesome Stuff With Google
Google Form Examples Preview 03:35
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. This video gives examples of using google forms, google spreadsheets, google sites, and google drive.
Google Form Examples
Creating A Gradebook Preview 01:58
Initial Considerations Preview 03:11
Tracking Attendance Preview 08:00
Gradebook Adjustments Preview 02:38
Entering and Adjusting Data Preview 02:51
Entering Formulas and Functions Preview 03:40
Automated Error Checking Preview 02:47
Calculating All Grades Preview 05:10
Looking Up The Letter Grade Preview 03:22
Freeze Panes and Sorting Preview 02:21
Importing Data From Blackboard Preview 09:41
Creating A Loan Amortization Schedule Preview 08:54
Templates Shown Throughout Course Preview 00:04
Final Exam
You must take this exam to get your certificate!