Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Excel

Complete Excel Course - Beginner to Expert

Become an Excel expert in just 20 hours and 130 videos
Rating: 4.2 out of 54.2 (272 ratings)
10,345 students
Created by Jarrod Hill
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

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

14 sections • 135 lectures • 20h 23m total length

  • Preview00:45
  • Welcome to the Course!
    00:27
  • FAQ
    01:12
  • Course Resources/Materials
    00:12

  • Excel for Complete Beginners
    08:52
  • Basic Math
    09:29
  • Referencing Cells
    13:45
  • Fixed & Relative Cell References
    20:17
  • Fundamentals Quiz
    10 questions
  • Fundamentals Assignment
    1 question

  • Formatting Basics
    21:44
  • Number Formatting
    14:46
  • Custom Formatting Part 1
    33:43
  • Custom Formatting Part 2
    05:06
  • Preview09:15
  • Cell Styles
    05:26
  • Conditional Formatting Part 1
    39:55
  • Conditional Formatting Part 2
    15:37
  • Formatting Quiz
    10 questions
  • Formatting Assignment
    1 question

  • 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
  • Working With Data Quiz
    10 questions
  • Working With Data Assignment
    1 question

  • 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
  • Formulas & Functions Quiz
    10 questions
  • Formulas & Functions Assignment
    1 question

  • 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
  • Arrays Quiz
    6 questions
  • Arrays Assignment
    1 question

  • 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
  • Pivottables Quiz
    10 questions
  • Pivottables Assignment
    1 question

  • 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
  • Charts Quiz
    10 questions
  • Charts Assignment
    1 question

  • 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
  • Print, Page Setup & View Quiz
    5 questions
  • Print, Page Setup & View Assignment
    1 question

  • Proofing
    05:59
  • Comments & Notes
    03:26
  • Sharing & Protection
    13:22
  • Proofing, Sharing & Protection Quiz
    5 questions
  • Proofing, Sharing & Protection Assignment
    1 question

Instructor

Jarrod Hill
Excel Guru
Jarrod Hill
  • 4.2 Instructor Rating
  • 274 Reviews
  • 10,365 Students
  • 2 Courses

I have learned Excel from many different sources including books, websites, Youtube, online courses & analyst employment. My goal is 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 to create the course that I wish I had when I started learning so that you can learn in a short course what takes most people 5-20 years to learn. That is my goal here on Udemy

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.