4.65 out of 5
4.65
4760 reviews on Udemy

Microsoft Excel – Excel from Beginner to Advanced 2023

The complete 8-hour Excel course compatible with MS Office 365, or ANY version of Excel. Zero to HERO!
Instructor:
Warrick Klimaytys
18,350 students enrolled
English [Auto]
Go from complete beginner to proficient Excel user within 8 hours of content.
Learn to create workbooks and spreadsheets everyone will be jealous of.
Acquire critical Excel knowledge within the first 2 hours of tutorials.
Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!

Did you know…

Over 750 million people have Excel on their computers, but most don’t know how to use it!

This might be because Excel can come across as being a little awkward with first-time users.

Well, within this course, ‘Microsoft Excel – Excel from Beginner to Advanced 2023′, I’d like to dispel any awkwardness you may encounter, while using Excel, and quickly get you to the point where using Excel is as natural as rolling out of bed in the morning.

How do I do this?

– I explain concepts within Excel simply and clearly.

– I break down Excel’s various tools, features, and functionality into the finest of detail, so you can gain a much deeper understanding of the program.

– I re-visit areas already taught every now and again, to reinforce what you would have already learned.

– I created this course to suit any level of learner.

I understand that learning Excel can feel like a huge undertaking, as it was for me when I first started using the program over 10 years ago. And so, you might ask yourself, “Do I have to learn everything in Excel before I can use it effectively?”.

Well, the answer is, NO!

You don’t have to learn every aspect of Excel before you can consider yourself qualified. The truth is, there is a certain level of proficiency that once reached, will make you considerably more qualified than the average Excel user.

To help you achieve this level of proficiency, I’ve created a very useful Excel workbook called, “main-workbook-section2” to accompany you throughout the first part of the course (After the basic introduction videos/material). In this workbook, I cover most (if not all) of the most important features and functionality you must know to get up to speed with the program as fast as possible. Then as you progress further into the course there are various other pre-prepared spreadsheets and workbooks you can download and use to follow along with my instructions.

What can you expect after enrolment?

We’ll start with a few introductory tutorials to get you set up for the course along with a basic introduction to Excel itself. Then, it’s onto section two, which I hope you’ll complete, and of course, ENJOY! Then, once this part of the course is completed, we’ll start diving into other areas of Excel to really start sharpening the skills you would have already learned, along with learning some new things as well.

What do you get when you enroll:

– A 30-day money-back guarantee, so you can enroll risk-free.

– A lifetime access guarantee so you can re-visit the course whenever you want.

– Access to the Q and A section so you can get help at any point during the course.

– A certificate of completion to add to your resume/CV.

So, whatever your reason for wanting to learn Excel, enroll in ‘Microsoft Excel – Excel from Beginner to Advanced 2023′ today! And see where my course will take you 🙂

I’ll see you in the first lesson.

Warrick Klimaytys.

Start Here

1
A brief introduction to Excel

In this brief introduction video, I'll show you how to save and open your Excel projects, and find templates that may suit the task you would like to carry out. I'll show you a few other useful things as well ;)

2
A little message before continuing :)
3
The three components that make up a spreadsheet
4
The AutoFill feature, basic functions and more
5
Exercise and solution video
6
Course notebook preview
7
Downloading your notebook templates
8
Must know keyboard shortcuts when doing an online course
9
List of keyboard shortcuts
10
A general overview and brief introduction (MUST WATCH)

Starting on the MainWorkbook

1
Main Workbook download in instructions
2
The three different types of references. Part 1
3
The three different types of references. Part 2
4
References exercise. A quick note
5
References exercise
6
Test your knowledge on references
7
Formulas and functions. What's the difference?
8
Introduction to formulas
9
Updated workbook for next tutorial
10
Formula writing basics
11
How to solve formulas using BODMAS
12
How to write formulas
13
Methods for creating using functions
14
Basic function variations you must know
15
Basic function variations you must know. SumIF and AverageIF
16
Functions exercise instructions
17
Welcome to the Concatenate function
18
Concatenate exercise
19
Test your knowledge on the concatenate function.
20
Update to the IF Function tutorial
21
The IF Function
22
Introduction to charts
23
Inserting a chart
24
Chart exercise instructions
25
Charts solution video and more!
26
Formatting data into a table
27
Formatting data into a table. Part 2
28
Function/formula error in the next tutorial
29
The If/And/Or functions. Part 1
30
Test your knowledge on the IfAndOr function
31
The If/And/Or functions. Part 2
32
Test your knowledge on the IfAndOr function
33
Introduction to printing
34
Printing your first spreadsheet
35
Test your knowledge on printing in Excel
36
Printer settings
37
Printing the second spreadsheet. Solution/exercise
38
Building a navigation pane. A few things to note
39
Building a Navigation Pane. Part 1
40
Building a Navigation Pane. Part 2
41
Test your knowledge on navigation panes and hidden links.
42
Vlookup
43
Note about next tutorial
44
Student request (Conditional formatting)
45
Subtotaling data. Part 1
46
Subtotaling data. Part 2
47
"Goals" Exercise instructions
48
Goals solution video!

Advanced printing

1
Advanced printing
2
Missing printing feature
3
Collation and more
4
Advanced printing. Part 2
5
Advanced printing. Part 3

Welcome to the world of macros

1
Introduction to macros
2
Three Solutions for Macros not working
3
Creating your first macro
4
Creating a macro with cell referencing
5
Creating macro shortcut icons on the ribbon
6
How to save a macro enabled Workbook. Best practices

Using PMT and IPMT functions for a Mortgage

1
Using the PMT function for a mortgage
2
Using the IPMT function for a mortgage

What if analysis

1
What if analysis. Data table
2
What if analysis. Goal seek
3
What if analysis. Goal seek formulas

3D maps

1
Introduction to 3D maps
2
How to use 3D maps. Part 1
3
How to use 3D maps. Part 2
4
Link to Microsoft web page

MUST know functions

1
Must know functions. Part 1
2
Must know functions. Part 2
3
Must know functions. Part 3
4
Must know functions 4 page instruction manual
5
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1
6
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2
7
Missing Draw tab
8
Excels drawing tools and more

Charts in Excel

1
Introduction to Charts in Excel
2
Introduction to Chart formatting
3
Charts in Excel. Chart Design Tab
4
Charts in Excel. Advanced Formatting Tools
5
Inserting and managing Sparklines
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.7
4.7 out of 5
4760 Ratings

Detailed Rating

Stars 5
2906
Stars 4
1498
Stars 3
311
Stars 2
32
Stars 1
13
60212dcb599f7034606353f16aa0451c
30-Day Money-Back Guarantee

Includes

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