Ultimate Microsoft Excel Course: Beginner to Excel Expert
4.7 (361 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.
8,533 students enrolled

Ultimate Microsoft Excel Course: Beginner to Excel Expert

Master Excel with this Complete Excel Course. Learn Everything Right Now (Workbooks and Real-World Exercises included).
4.7 (361 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.
8,533 students enrolled
Created by Alan Murray
Last updated 4/2020
English
English
Current price: $104.99 Original price: $174.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 14 hours on-demand video
  • 20 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • 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
  • Become a Confident and Well-Rounded Excel user
  • Learn new techniques that you will be able to apply right way
  • Learn to write Excel formulas from scratch, up to to rock star level
  • Utilise the awesomeness of Power Query to import, shape and transform data for analysis
  • Master some of the most important functions in Excel such as IF, VLOOKUP, INDEX, SUMIF and many more
  • Learn the latest Cutting-Edge Excel Tips and Features that most users will not have even heard of
  • Automate Daily Tasks with the power of Macros and VBA
  • Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support
Requirements
  • You have basic Excel knowledge. The lessons start from a beginner level, but not for complete newbies.
  • Lessons are demonstrated using Excel 2016. Most of the content can be done from Excel 2007. The lessons will state if a specific version of Excel is needed for that technique
Description

★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★

It is time to master Excel. If you are a beginner and want to develop your Excel skills or have the desire to be an Excel guru, you have come to the right place.

This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

This course is perfect if you;

  • Use Excel everyday but want to improve your all-round skills and become the office expert

  • Have a basic knowledge but want to take the plunge and develop your Excel muscles

  • Learn all the essential skills in Excel to help get a new job or promotion

The course has been designed as a one-stop shop for all of the essential skills of Excel. It is very comprehensive and you can come back again and again to re-visit material.

The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel in 2019 and amazing features on the horizon - you can be sure to find lessons added to this course so that you stay ahead of the game.

I teach in a hands-on way with unique examples demonstrating all of the essential features of Excel. You will not only understand HOW these Excel tools and formulas work, but see examples of WHY they are so awesome.

By the end of the course you will be a confident user of Excel with the skills to progress your career further, or become the office Excel guru.

During the course you will learn;

  • To use the power of PivotTables to summarise large amounts of data and produce dynamic reports in minutes.

  • Be confident in using over 30 of the most important Excel functions including INDEX, VLOOKUP, MID, IF, MATCH and COUNTIF.

  • Create charts in a flash that visualize data effectively.

  • Conditional Formatting to highlight data comparisons, progress and issues.

  • Utilise the awesomeness of Power Query to import, shape and transform data.

  • Clean up messy data with formulas, Flash Fill and other Excel features.

  • Understand the data model in Excel and PowerPivot.

  • To use macros to automate time-consuming tasks.

  • And much much more.

Why learn from me?

I have been training business all around the world on how to get the most out of Excel for over 20 years.

Learning and teaching Excel is my passion. I am a full time Excel trainer and consultant, so every day I am in the thick of the action teaching others to master Excel.

I set up the Computergaga blog and YouTube channel 10 years ago where I am lucky enough to have taught millions of people across the globe to increase their skills and overcome everyday real world Excel problems.

The course includes the exact files that I use in the lessons to download and follow along, lifetime access and 1 on 1 instructor support every step of the way.

Don't delay. Take action. Grab a coffee and let's get started.

Your journey towards mastering Excel starts today

Who this course is for:
  • You currently use Excel and want to improve your skills
  • You have a job role that requires a strong level of Excel expertise and you want to get up to speed quickly
  • You work with Excel regularly but are looking for more advanced and well-rounded skills
  • Anyone looking to expand their skill set in Excel to help develop their career
Course content
Expand all 142 lectures 13:55:23
+ Working with Large Worksheets
5 lectures 23:57
Splitting a Worksheet to Reference Two Different Areas
03:50
Hiding and Unhiding Columns
02:47
Filtering a List - One of the Most Useful Excel Skills you will EVER Need
07:10
+ 5 Essential Tricks for Printing Spreadsheets
5 lectures 19:37
Scaling a Print to Fit onto Fewer Pages
05:26
Repeating your Headers Across Multiple Pages
03:06
Printing a Selected Range and Setting a Print Area
04:06
Aligning a Print on a Page
02:30
Using Page Breaks to Logically Break Up a Print
04:29
+ Getting Started with Excel Formulas
12 lectures 01:08:43
Introduction to Formulas - Writing your First Excel Formulas
07:50
The Order of Calculation - BODMAS
03:13
Calculating Percentages
07:54
Unleash the Power of Excel Functions
08:44
Referencing other Sheets and Workbooks
11:45
Calculating Date Difference including Working Days Only
08:09
Understand Absolute Cell Addresses
06:22
The COUNTIF Function - An Incredibly Useful Function
13:12
Exercise 1: Writing Formulas
00:13
Exercise 2: Absolute References
00:32
Exercise 3: Using Functions
00:30
Exercise 4: Calculating Percentage Increase/Decrease
00:18
+ Logical Functions: The Decision Making Formulas of Excel
8 lectures 37:03
IF Function 1 - Testing if a Value is Larger than a Specific Value
04:23
IF Function 2 - Testing if a Cell Contains Certain Text
03:52
IF Function 3 - Tracking Due Dates by Testing if they are Overdue
04:06
Using Multiple IF Functions - Nested IFs
04:50
AND and OR Functions for Testing Multiple Conditions
06:35
The IFS Function - No More Nested IFs
04:10
The SWITCH Function - Another Alternative to Complex Nested IFs
09:00
Exercise: Logical Functions
00:07
+ Conditional Formatting - Make your Data Come to Life
9 lectures 50:40
Create your First Conditional Formatting Rules
07:02
Managing Multiple Rules and Dealing with Conflicts
07:09
Conditional Formatting to Highlight Expired and Due Dates
08:16
Applying Data Bars to Compare Values or Show Progress
05:45
Create a Heat Map using Colour Scales
03:02
Using Icon Sets to Show Monthly Comparisons
08:04
Applying Conditional Formatting to the Entire Row
04:31
Testing Multiple Conditions with the AND Function
06:42
Exercise: Working with Conditional Formatting
00:09
+ Lookup Functions - The Powerful VLOOKUP Function and beyond
7 lectures 37:22
The VLOOKUP Function Explained
07:00
Using VLOOKUP for a Range Lookup
05:09
Advanced VLOOKUP with a Dynamic Column Index Number
08:59
Handling Error Messages with Lookup Formulas
05:24
A Versatile Lookup Formula - The INDEX and MATCH Combo
06:19
Two Way Lookup using INDEX and MATCH
04:16
Exercise: Using the VLOOKUP Function
00:15
+ Validating and Protecting Excel Data
9 lectures 38:23
Validate the Number of Characters
02:23
Create Date Validation Rules
02:23
Drop Down Lists for Easy Data Entry
04:35
Dependent Lists to Break up Large Lists
05:25
Create Custom Data Validation Messages
06:46
Encrypt a File from Unauthorised Access
02:48
Protect the Structure of a Workbook
05:46
Protect the Data on a Worksheet
07:50
Exercise: Validating Data Entry
00:27
+ Advanced Formulas for Analysing Data
7 lectures 41:55
Using SUMIF, COUNTIF and AVERAGEIF
08:00
Summing the Values between Two Dates
05:44
An Advanced Sum Formula with SUMPRODUCT
05:53
Summing Values by a Specific Weekday - SUMPRODUCT Example 2
09:37
The Secret AGGREGATE Function
07:38
An Advanced Array Example of AGGREGATE
04:51
Exercise: Analysing Data with Formulas
00:12
+ Charts - Simple and Effective Data Presentation
12 lectures 01:07:31
Creating your First Charts
07:36
Adding and Removing Chart Elements
05:23
Formatting Charts
06:42
Modify the Chart Axis
07:22
Save Time with Chart Templates
04:35
Combo Charts - Two Chart Types in One Chart
06:20
Chart Filters
02:29
Interactive Charts – Change Chart Data with a Drop Down List
08:03
Using Cell Values for Chart Labels
04:28
Conditional Formatting with Charts
07:58
Using Sparklines for Quick Data Insights
06:03
Exercise: Working with Charts
00:32