Microsoft Excel - From Beginner to Expert in 6 Hours
All LevelsOffice ProductivityExcel

Microsoft Excel - From Beginner to Expert in 6 Hours

Excel Made Easy - From Beginner to Expert - Microsoft Certified Master Instructor - MOS Expert - Master Microsoft Excel

Created by Todd McLeod
5.5 hours
Video Content
68
Lectures
206,048
Students
4.6
Rating
4.6
(206,048 students enrolled)

What you'll learn

Learn Microsoft Excel Fast: Excel formulas and functions, Excel shortcuts and tips, Excel charts and graphs, Excel for beginners & intermediate users
Taught by a best-selling Udemy author, Microsoft Certified Educator, Microsoft Office Specialist Expert, & Tenured College Professor
Conditional formatting in Excel, Excel date functions and formatting, Excel templates, Excel for Data Management
Data analysis in Excel, Pivot tables in Excel, Excel for data visualization, Excel data validation, Excel macros
Excel for business analysis, Excel for finance and accounting, Excel for sales and marketing
Excel for budgeting and forecasting, Excel for project management, Excel for inventory management
Excel functions: sum, vlookup, xlookup, if, count, average, concatenate, max, min, round, and more
Excel documentation: learn how to read Excel's documentation so that you are empowered to find answers
Hands-on exercises with solutions, Over 500,000 students taught, Lifetime course access
100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven

Course Content

22 sections • 68 lectures • 05:32:27 total length

Course information

3 lectures • 10:26

Welcome06:22
Course files00:31
Getting your certificate03:33
Quiz #18 questions

Quick start with MS Excel

8 lectures • 45:57

Introduction04:54
Microsoft Excel05:07
Relative references05:05
Absolute references07:32
Calculating a grade05:17
+4 more lectures

Hands-on exercises #1

1 lectures • 06:52

Hands-on exercises06:52

MS Excel fundamentals

6 lectures • 31:29

Introduction02:06
A tour of Excel08:43
Mouse pointer awareness06:46
The power of right clicking05:28
Autosave & autorecover04:21
+2 more lectures

Hands-on exercises #2

1 lectures • 02:18

Hands-on exercises02:18

MS Excel functions

4 lectures • 31:05

Max, min, & documentation09:26
Rand & randbetween05:46
Concat & textjoin07:11
Documentation08:42
Quiz #46 questions

Hands-on exercises #3

1 lectures • 09:00

Hands-on exercises09:00

Popular Excel functions

9 lectures • 44:25

Introduction03:35
Top 10 functions03:30
Xlookup, vlookup, & hlookup07:14
PMT payment function06:41
PMT IPMT loan amortization06:59
+5 more lectures

Hands-on exercises #4

1 lectures • 03:36

Hands-on exercises03:36

Formatting for impact

5 lectures • 25:41

Fundamentals of formatting04:11
Formatting tables of data quickly04:30
Font is feeling - font formatting05:40
Exploring the home ribbon07:12
Zebra stripe rows04:08
+1 more lectures

Hands-on exercises #5

1 lectures • 01:51

Hands-on exercises01:51

Creating charts & graphs

6 lectures • 35:31

Content & form06:35
Creating charts07:12
Formatting charts06:32
Chart trendlines04:40
Combo charts07:12
+2 more lectures

Hands-on exercises #6

1 lectures • 04:17

Hands-on exercises04:17

Working with data

4 lectures • 19:53

Gapminder data05:26
Scraping web data04:39
Outdoor gear coop05:06
Name generator04:42

Massaging data

4 lectures • 12:57

Sorting data05:06
Freeze panes03:26
Removing duplicates01:14
Filtering data03:11
Quiz #84 questions

Hands-on exercises #7

1 lectures • 03:31

Hands-on exercises03:31

Pivot tables in Excel

4 lectures • 17:09

Introduction06:49
Creating pivot tables04:43
Slicers - filtering pivot tables02:26
Pivot charts03:11
Quiz #92 questions

Hands-on exercises #8

1 lectures • 01:16

Hands-on exercises01:16

Odds & ends

3 lectures • 12:47

Printing your worksheet05:39
Protecting (locking) workbooks, sheets, and cells05:34
Object linking & embedding (OLE)01:34

Creating macros

1 lectures • 04:53

Introduction to macros04:53
Quiz #104 questions

Hands-on exercises #9

1 lectures • 03:30

Hands-on exercises03:30

Congratulations

2 lectures • 04:02

Great work!01:47
Bonus lecture02:15

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 80 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:

  • This course is perfect for beginners to Microsoft Excel & for people with some experience with Excel
  • Lifetime access to this Excel training allows you to come back to review material or learn more about MS Excel

This course includes:

  • 5.5 hours on-demand video
  • 1 articles
  • 128 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

Todd McLeod

Students also download

Explore related courses to expand your learning journey.