4.65 out of 5
4.65
2962 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
11,476 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 the 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, enrol 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
Auto-fill, 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
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
How to write formulas
9
Basic function variations you must know
10
Basic function variations you must know. SumIF and AverageIF
11
Functions exercise instructions
12
Welcome to the Concatenate function
13
Test your knowledge on the concatenate function.
14
The IF Function
15
Introduction to charts
16
Inserting a chart
17
Chart exercise instructions
18
Charts solution video and more!
19
Formatting data into a table
20
Formatting data into a table. Part 2
21
Function/formula error in the next tutorial
22
The If/And/Or functions. Part 1
23
Test your knowledge on the IfAndOr function
24
The If/And/Or functions. Part 2
25
Test your knowledge on the IfAndOr function
26
Introduction to printing
27
Printing your first spreadsheet
28
Test your knowledge on printing in Excel
29
Printer settings
30
Printing the second spreadsheet. Solution/exercise
31
Building a Navigation pane
32
Test your knowledge of building a navigation pane.
33
Vlookup
34
Note about next tutorial
35
Student request (Conditional formatting)
36
Subtotaling data. Part 1
37
Subtotaling data. Part 2
38
"Goals" Exercise instructions
39
Goals solution video!

Advanced printing

1
Advanced printing
2
Collation and more
3
Advanced printing. Part 2
4
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
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1
5
Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2
6
Missing Draw tab
7
Excels drawing tools and more

Charts in Excel

1
Introduction to Charts in Excel
2
Charts in Excel. Part 1
3
Charts in Excel. Part 2
4
Charts in Excel. Part 3
5
Inserting sparklines and more
6
Charts solution video

Sorting large amounts of data

1
Freezing the panes and more!
2
Sorting the data (Exercise instructions)
3
Sorting the data (Solution video)
4
Filtering and analyzing the data. Part 1
5
Filtering and analyzing the data. Part 2

Deleting duplicate data, Concatenating and more!

1
Locating and deleting duplicate entries

Data sets can get HUGE. So trying to locate and delete duplicate data can be VERY time consuming and inaccurate if done manually. I'm sure you would agree, having Excel do all this hard work for you is preferable. In this tutorial, I'll show you how to use Excel to find and delete duplicate data quickly and efficiently. 

2
Concatenate continuation training
3
How to use the "DateValue" attribute within the IF function
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
2962 Ratings

Detailed Rating

Stars 5
1780
Stars 4
943
Stars 3
207
Stars 2
26
Stars 1
6
7e40f1e0f5f8872385ea70feb0cd1de2
30-Day Money-Back Guarantee

Includes

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

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Microsoft Excel – Excel from Beginner to Advanced 2023
Price:
INR3,999 INR529
Layer 1