Microsoft Excel - Excel from Beginner to Advanced 2023
- Description
- Curriculum
- FAQ
- Reviews
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.
-
1A 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 ;)
-
2A little message before continuing :)
-
3The three components that make up a spreadsheet
-
4The AutoFill feature, basic functions and more
-
5Exercise and solution video
-
6Course notebook preview
-
7Downloading your notebook templates and more
-
8Must know keyboard shortcuts when doing an online course
-
9List of keyboard shortcuts
-
10A general overview and brief introduction (MUST WATCH)
-
11Main Workbook download and instructions
-
12The three different types of references. Part 1
-
13The three different types of references. Part 2
-
14References exercise. A quick note
-
15References exercise
-
16Your 3-page instruction manual on references
-
17Test your knowledge on references
-
18Formulas and functions. What's the difference?
-
19Introduction to formulas
-
20Formula writing basics
-
21Test your knowledge on formula writing
-
22How to solve formulas using BODMAS
-
23Test you knowledge on the BODMAS rule
-
24How to write formulas
-
25Methods for creating using functions
-
26Update to the next 3 tutorials.
-
27Basic function variations you must know. Part 1
-
28Basic function variations you must know. Part 2
-
29Functions exercise. SumIfs, AverageIfs, & CountIfs
-
30Welcome to the Concatenate function
-
31Concatenate exercise
-
32Test your knowledge on the concatenate function.
-
33The IF Function
-
34Test your knowledge on the IF function
-
35Introduction to charts
-
36Inserting a chart
-
37Test your knowledge of charts
-
38Chart exercise instructions
-
39Charts solution video and more!
-
40Formatting data into a table
-
41Formatting data into a table. Part 2
-
42Update to the next two tutorials
-
43The I|f/And/Or functions. Part 1
-
44Test you knowledge on the "If/And" function
-
45The If/And/Or functions. Part 2
-
46Test your knowledge on the "If/Or" function
-
47Introduction to printing
-
48Printing your first spreadsheet
-
49Test your knowledge on printing in Excel
-
50Printer settings
-
51Printing the second spreadsheet. Solution/exercise
-
52Building a navigation pane. A few things to note
-
53HEX to RGB converter link.
-
54Building a Navigation Pane. Part 1
-
55Building a Navigation Pane. Part 2
-
56Test your knowledge on navigation panes and hidden links.
-
57Vlookup
-
58Note about next tutorial
-
59Student request (Conditional formatting)
-
60Subtotaling data. Part 1
-
61Subtotaling data. Part 2
-
62"Goals" Exercise instructions
-
63Goals solution video!
-
70Introduction to macros
-
71Saving as an Excel Macro-Enabled Document
-
72How to create a macro
-
73How to create macros (Use Relative Referencing)
-
74Macros exercise instructions
-
75Macros exercise solution
-
76Work with macros conveniently
-
77Final thoughts on macros
-
78Your 8-page instruction manual on Macros
-
79A quick introduction to this section
-
80How to workout monthly payments with the PMT function
-
81How to work out monthly payments with the IPMT function
-
82How to work out yearly payments with the PMT & IPMT
-
83Exercise instructions and solution (PMT, IPMT, and more)
-
84Working out variable rate payments with the PMT
-
85The interest only and weekly payment example spreadsheets
-
86Your 4-page instruction manual on the PMT and IPMT