Microsoft Excel - From Beginner to Expert in 6 Hours
- Description
- Curriculum
- FAQ
- Reviews
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.
-
15
Introduction To ExcelREMEMBER - 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!
-
16
Introduction To Excel -
17
Writing Formulas
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!
-
18
Writing Formulas
-
19
Formula Essentials
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!
-
20
Formula Essentials
-
21
Relative, Absolute, & Mixed ReferencesREMEMBER - 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!
-
22
Relative, Absolute, and Mixed References
-
23
Introduction to Functions
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!
-
24
Introduction to Functions
-
25
Payment Function & Loans
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!
-
26
Payment Function & Loans
-
27
Future Value Function & PensionsREMEMBER - 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!
-
28
Future Value Function & Pensions
-
29
VLOOKUP Function & GradebooksREMEMBER - 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!
-
30
VLOOKUP Function & Gradebooks
-
31
IF, Concatenate, & EvaluationREMEMBER - 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!
-
32
IF, Concatenate, & Evaluation
-
33
Conditional FormattingREMEMBER - 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!
-
34
Conditional Formatting
-
35
IFERROR Function & Dynamic Amortization TablesREMEMBER - 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!
-
36
IFERROR Function & Dynamic Amortization Tables
-
37
Visually Representing Data
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!
-
38
Visually Representing Data
-
39
Creating Charts
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!
-
40
Creating Charts
-
41
Formatting Charts
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!
-
42
Formatting Charts
-
43
Scatter Charts
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!
-
44
Scatter Charts
-
45
Combo Charts
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!
-
46
Combo Charts
-
47
Pivot Charts
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!
-
48
Pivot Charts
-
49
Finding Data
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!
-
50
Finding Data
-
51
Copying Data From The Web
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!
-
52
Copying Data From The Web
-
53
Transposing Data
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!
-
54
Transposing Data
-
55
Copying Data From The Web II
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!
-
56
Copying Data From The Web II
-
57
Parsing Data
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!
-
58
Parsing Data
-
59
Web Scraping Software
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!
-
60
Web Scraping Software
-
61
Freeze Panes
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!
-
62
Freeze Panes
-
63
Filtering Data
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!
-
64
Filtering Data
-
65
Removing Duplicates
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!
-
66
Removing Duplicates
-
67
Sorting Data
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!
-
68
Sorting Data
-
69
Subtotaling Data
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!
-
70
Subtotaling Data
-
71
Data TablesREMEMBER - 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!
-
72
Data Tables
-
73
Exploring The Find FunctionREMEMBER - 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!
-
74
Exploring The Find Function
-
75
Exploring Filters FurtherREMEMBER - 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!
-
76
Exploring Filters Further
-
77
The Advanced FilterREMEMBER - 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!
-
78
The Advanced Filter
-
79
The Find Function IIREMEMBER - 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!
-
80
The Find Function II
