Helena Daily Courses > Office Productivity > Ultimate Microsoft Excel Course: Beginner to Excel Expert
4.55 out of 5
4.55
669 reviews on Udemy

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).
Instructor:
Alan Murray
9,426 students enrolled
English
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

★★★★★ 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 every day 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 revisit the material.

The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel 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 50 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 businesses 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 a Microsoft MVP, 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 > 13 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. 

Introduction

1
Introduction to the Ultimate Excel Course
2
Download your Exercise Files

Working with Large Worksheets

1
Keeping your Headings Visible as you Scroll
2
Splitting a Worksheet to Reference Two Different Areas
3
Hiding and Unhiding Columns
4
Sorting a Large List - Including a Super Shortcut
5
Filtering a List - One of the Most Useful Excel Skills you will EVER Need

5 Essential Tricks for Printing Spreadsheets

1
Scaling a Print to Fit onto Fewer Pages
2
Repeating your Headers Across Multiple Pages
3
Printing a Selected Range and Setting a Print Area
4
Aligning a Print on a Page
5
Using Page Breaks to Logically Break Up a Print

Getting Started with Excel Formulas

1
Introduction to Formulas - Writing your First Excel Formulas
2
The Order of Calculation - BODMAS
3
Calculating Percentages
4
Unleash the Power of Excel Functions
5
Referencing other Sheets and Workbooks
6
Calculating Date Difference including Working Days Only
7
Understand Absolute Cell Addresses
8
The COUNTIF Function - An Incredibly Useful Function
9
Exercise 1: Writing Formulas
10
Exercise 2: Absolute References
11
Exercise 3: Using Functions
12
Exercise 4: Calculating Percentage Increase/Decrease

Logical Functions: The Decision Making Formulas of Excel

1
IF Function 1 - Testing if a Value is Larger than a Specific Value
2
IF Function 2 - Testing if a Cell Contains Certain Text
3
IF Function 3 - Tracking Due Dates by Testing if they are Overdue
4
Using Multiple IF Functions - Nested IFs
5
AND and OR Functions for Testing Multiple Conditions
6
The IFS Function - No More Nested IFs
7
The SWITCH Function - Another Alternative to Complex Nested IFs
8
Exercise: Logical Functions

Conditional Formatting - Make your Data Come to Life

1
Create your First Conditional Formatting Rules
2
Managing Multiple Rules and Dealing with Conflicts
3
Conditional Formatting to Highlight Expired and Due Dates
4
Applying Data Bars to Compare Values or Show Progress
5
Create a Heat Map using Colour Scales
6
Using Icon Sets to Show Monthly Comparisons
7
Applying Conditional Formatting to the Entire Row
8
Testing Multiple Conditions with the AND Function
9
Exercise: Working with Conditional Formatting

Dynamic Array Functions - Formulas Have Changed

1
Introduction to Dynamic Arrays
2
The UNIQUE Function
3
The SORT Function - Sort Formula Results Automatically
4
The SORTBY Function - Sort by Any Column
5
The FILTER Function - Lookup and Return Multiple Values
6
The SEQUENCE Function

Lookup Functions - The Powerful VLOOKUP Function and beyond

1
The VLOOKUP Function Explained
2
Using VLOOKUP for a Range Lookup
3
Advanced VLOOKUP with a Dynamic Column Index Number
4
Handling Error Messages with Lookup Formulas
5
A Versatile Lookup Formula - The INDEX and MATCH Combo
6
Two Way Lookup using INDEX and MATCH
7
Return Non-Adjacent Columns in an Array with INDEX and MATCH
8
XLOOKUP Function - The Successor to VLOOKUP and HLOOKUP
9
Multi-Column Lookup with XLOOKUP
10
Two-Way Lookup with XLOOKUP
11
Exercise: Using the VLOOKUP Function

Validating and Protecting Excel Data

1
Validate the Number of Characters
2
Create Date Validation Rules
3
Drop Down Lists for Easy Data Entry
4
Dependent Lists to Break up Large Lists
5
Create Custom Data Validation Messages
6
Encrypt a File from Unauthorised Access
7
Protect the Structure of a Workbook
8
Protect the Data on a Worksheet
9
Exercise: Validating Data Entry

Advanced Formulas for Analysing Data

1
Using SUMIF, COUNTIF and AVERAGEIF
2
Summing the Values between Two Dates
3
An Advanced Sum Formula with SUMPRODUCT
4
Summing Values by a Specific Weekday - SUMPRODUCT Example 2
5
The Secret AGGREGATE Function
6
An Advanced Array Example of AGGREGATE
7
Exercise: Analysing Data with Formulas

Charts - Simple and Effective Data Presentation

1
Creating your First Charts
2
Adding and Removing Chart Elements
3
Formatting Charts
4
Modify the Chart Axis
5
Save Time with Chart Templates
6
Combo Charts - Two Chart Types in One Chart
7
Chart Filters
8
Interactive Charts – Change Chart Data with a Drop Down List
9
Using Cell Values for Chart Labels
10
Conditional Formatting with Charts
11
Using Sparklines for Quick Data Insights
12
Exercise: Working with Charts

Manipulating Text in Excel

1
Splitting Text across Multiple Columns
2
The CONCAT and CONCATENATE Functions
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
669 Ratings

Detailed Rating

Stars 5
358
Stars 4
253
Stars 3
49
Stars 2
5
Stars 1
4
7b9fedb81de602465f5b81c295f95f27
Get on Udemy
30-Day Money-Back Guarantee

Includes

15 hours on-demand video
20 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion