Complete Excel Course - Beginner to Expert
4.6 (222 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,253 students enrolled

Complete Excel Course - Beginner to Expert

Become an Excel expert in just 20 hours and 130 videos
4.6 (222 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,253 students enrolled
Created by Jarrod Hill
Last updated 7/2020
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20.5 hours on-demand video
  • 5 articles
  • 25 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Analyse large data sets in a few clicks using Pivot Tables & Pivot Charts
  • Visualise data using Graphs & Dashboards
  • Create dynamic Graphs which automatically capture new data
  • Format data to highlight key points
  • Solve problems using Formulas and Functions
  • Monitor unkwown factors using 'What If Analysis'
  • Sort, Filter, manipulate & summarise data to draw quick conclusions
  • Increase productivity using Array Formulas
  • Customise reports in a professional and presentable way
  • Add security & protection to improve data integrity
  • Learn tips and tricks in the case of system crashes
  • Save time with keyboard shortcuts
  • Apply built-in templates and add-ins for thousands of applications
  • Master basics of Excel spreadsheets-navigating, saving, printing, math
  • Connect to data from external sources including text, websites, databases, stocks and geographical sources
Requirements
  • Require a computer with excel installed (2013 version or later reccomended)
Description

I have learned Excel from many different sources including books, websites, Youtube, online courses & analyst employment. My goal was to create a course that has everything in 1 place so that you don't have to go searching everywhere like I did. It took me a long time to master Excel and now I want the course that I wish I had when I started learning so that you can learn in a 20 hour course what takes most people 5-20 years to learn. That is my goal with this course.

As far as the content goes, I cover everything except for VBA/Macros because that really needs a whole course of it's own. But everything else in Excel I cover and that's why the course is so long. But it's not really not that long if you think about the benefits, including the time it will save you when you become an excel expert and also the career opportunities. You could be less than a week away from becoming an Excel expert! Or you can do the course slowly over years, it's completely up to you. The course can be done at your own pace and in any order. I have arranged it logically into what I think is the best way to learn but you can do the videos in any order. If one video requires having seen another as a prerequisite then I mention that in the video so you can go back and watch that if you need to. The main thing is that you find the course valuable and learn a lot.

The course is suitable for complete beginners and I have a video at the start teaching excel for people who have never used it before. But that's not to say it won't be useful for advanced users. As you can see from the content we cover everything, including the most advanced formulas and features. I try to do this with a lot of examples and explain as clearly as possible so that you understand why we do certain things not just how to do it. In only 20 hours and 130 videos, I guarantee you will the Excel guru among your friends & co-workers.


Contents

  1. Fundamentals

  2. Formatting

  3. Working With Data

  4. Formulas & Functions

  5. Arrays

  6. Pivottables

  7. Charts

  8. Print, Page Set & View

  9. Proofing, Sharing & Protection

  10. Shortcuts

  11. Other Useful Tips

  12. File, Ribbon & Quick Access Toolbar

The course is 130 videos, 20 hours long and all course materials are available to download

Who this course is for:
  • Excel users of all levels
Course content
Expand all 133 lectures 20:23:28
+ Introduction
3 lectures 02:21
Welcome to the Course!
00:32
Course Guidelines & Downloadable Materials
01:04
+ Fundmentals
4 lectures 52:23
Excel for Complete Beginners
08:52
Basic Math
09:29
Referencing Cells
13:45
Fixed & Relative Cell References
20:17

Test your knowledge of the section Excel Fundamentals

Fundamentals Quiz
10 questions
Practice what you've learn in the proceeding section by downloading the file and completing the exercises
Fundamentals Assignment
1 question
+ Formatting
8 lectures 02:25:32
Formatting Basics
21:44
Number Formatting
14:46
Custom Formatting Part 1
33:43
Custom Formatting Part 2
05:06
Cell Styles
05:26
Conditional Formatting Part 1
39:55
Conditional Formatting Part 2
15:37

Test your knowledge of the section Fundamentals

Formatting Quiz
10 questions
Practice what you've learnt in the Formatting section by completing the exercises in the file
Formatting Assignment
1 question
+ Working With Data
20 lectures 02:48:32
Sorting
08:59
Filtering
09:49
Advanced Filter
10:47
Hiding, Grouping & Subtotals
14:19
Text to Columns
05:33
Flash Fill
04:11
Data Validation
18:10
Connecting to an External Workbook
04:01
Connecting to a Text File
02:57
Connecting to a Website
04:58
Stocks & Geography
02:25
Consolidate Data
04:40
Scenario Manager
08:41
Data Tables
08:03
Goal Seek
08:01
Solver
07:44
Forecasting
03:23
Named Ranges
22:12
Booleans
07:18
Tables
12:21

Test your knowledge of the section Working With Data

Working With Data Quiz
10 questions
Practice what you've learnt in the Working With Data section by downloading the file and completing the exercises
Working With Data Assignment
1 question
+ Formulas & Functions
20 lectures 04:41:58
Intro to Functions
08:19
Logial Functions
23:14
Errors
06:14
INDIRECT
15:12
Basic Functions on Ranges
05:29
OFFSET
17:22
SUM/COUNT/AVERAGE IF(S)
10:26
SUMPRODUCT
12:52
More Math Functions
12:18
More Text Functions
26:00
Lookup Functions-VLOOKUP, HLOOKUP & LOOKUP
38:02
INDEX & MATCH
17:10
INDEX Part 2
16:21
Formula Auditing & Formula Ribbon Tab
07:32
Date & Time Functions
18:50
SUBTOTAL & AGGREGATE
05:47
CHOOSE
10:00
FREQUENCY
02:44
Financial Functions
18:26
Other Functions
09:40

Test your knowledge of the section Formulas & Functions

Formulas & Functions Quiz
10 questions
Practice what you've learnt in the Formulas & Functions section by downloading the file and completing the exercises
Formulas & Functions Assignment
1 question
+ Arrays
11 lectures 01:38:26
Note On Videos In This Section
00:31
Old Array Formulas (Pre-2018)
17:25
FILTER
13:09
SORT & SORTBY
09:09
RANDARRAY & SEQUENCE
06:19
UNIQUE
01:29
SINGLE
02:57
XLOOKUP
24:29
XMATCH
07:58
Applying Arrays to Standard Functions
04:06
Using Arrays To Create A Searchable Dropdown List
10:54

Test your knowledge of the section Arrays

Arrays Quiz
6 questions
Practice what you've learnt in the Arrays section by downloading the file and completing the exercises
Arrays Assignment
1 question
+ Pivottables
15 lectures 01:44:31
Pivottable Introduction
00:23
Pivottable Examples 1
22:03
Pivottable Examples 2
10:39
Manual Sort, Multiple Filter & Pivottable Options
04:26
Drill Down
01:35
Conditional Formatting in Pivottables
01:16
Grouping Dates
03:17
Slicers
10:30
Timelines
06:43
Analyse & Design
12:17
Calculated Fields
06:31
GETPIVOTDATA Formula
06:20
Pivotcharts
04:44
Pivottables Summary
09:48
Introduction to Powerpivot
03:59

Test your knowledge of the section Pivottables

Pivottables Quiz
10 questions
Practice what you've learnt in the Pivottables section by downloading the file and completing the exercises
Pivottables Assignment
1 question
+ Charts
20 lectures 02:34:47
Chart Foundations
10:44
Dynamic Chart Ranges
10:29
Chart Design
06:25
Chart Formatting Part 1
22:00
Chart Formatting Part 2
05:25
Column vs Bar Charts
04:59
Line Charts
08:09
Pie Charts
04:34
Scatter & Bubble Charts
05:13
Histogram
02:27
Other Charts-Box & Whisker, Sunburst, Treemap, Funnel, Surface, Radar
09:45
Maps
02:23
Project Timeline
05:52
Combo Charts
08:47
Sparklines
04:22
Selecting Flags Using a Dropdown
04:21
Camera
03:41
Infographics & Battery Chart
16:15
Speedometer
06:03
Introduction to Dashboards
12:53

Test your knowledge of the section Charts

Charts Quiz
10 questions
Practice what you've learnt in the Charts section by downloading the file and completing the exercises
Charts Assignment
1 question
+ Print, Page Setup & View
7 lectures 44:23
Themes
01:43
Page Setup
16:12
Headers & Footers
08:53
Printing
02:58
Spreadsheet Views
04:36
Arranging Windows
04:50
Page Layout & View Summary
05:11

Test your knowledge of the section Print, Page Setup & View

Print, Page Setup & View Quiz
5 questions
Practice what you've learnt in the Page, Print Setup & View section by downloading the file and completing the exercises
Print, Page Setup & View Assignment
1 question
+ Proofing, Sharing & Protection
3 lectures 22:47
Proofing
05:59
Comments & Notes
03:26
Sharing & Protection
13:22

Test your knowledge of the section Proofing, Sharing & Protection

Proofing, Sharing & Protection Quiz
5 questions
Practice what you've learnt in the Proofing, Sharing & Protection section by downloading the file and completing the exercises
Proofing, Sharing & Protection Assignment
1 question