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 ExcelVideo lesson
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 :)Text lesson
-
3The three components that make up a spreadsheetVideo lesson
-
4The AutoFill feature, basic functions and moreVideo lesson
-
5Exercise and solution videoVideo lesson
-
6Course notebook previewVideo lesson
-
7Downloading your notebook templates and moreText lesson
-
8Must know keyboard shortcuts when doing an online courseVideo lesson
-
9List of keyboard shortcutsText lesson
-
10A general overview and brief introduction (MUST WATCH)Video lesson
-
11Main Workbook download in instructionsText lesson
-
12The three different types of references. Part 1Video lesson
-
13The three different types of references. Part 2Video lesson
-
14References exercise. A quick noteText lesson
-
15References exerciseVideo lesson
-
16Your 3-page instruction manual on referencesText lesson
-
17Test your knowledge on referencesQuiz
-
18Formulas and functions. What's the difference?Video lesson
-
19Introduction to formulasVideo lesson
-
20Formula writing basicsVideo lesson
-
21Test your knowledge on formula writingQuiz
-
22How to solve formulas using BODMASVideo lesson
-
23Test you knowledge on the BODMAS ruleQuiz
-
24How to write formulasVideo lesson
-
25Methods for creating using functionsVideo lesson
-
26Update to the next 3 tutorials.Text lesson
-
27Basic function variations you must know. Part 1Video lesson
-
28Basic function variations you must know. Part 2Video lesson
-
29Functions exercise. SumIfs, AverageIfs, & CountIfsVideo lesson
-
30Welcome to the Concatenate functionVideo lesson
-
31Concatenate exerciseText lesson
-
32Test your knowledge on the concatenate function.Quiz
-
33Update to the IF Function tutorialText lesson
-
34The IF FunctionVideo lesson
-
35Test your knowledge on the IF functionQuiz
-
36Introduction to chartsVideo lesson
-
37Inserting a chartVideo lesson
-
38Test your knowledge of chartsQuiz
-
39Chart exercise instructionsVideo lesson
-
40Charts solution video and more!Video lesson
-
41Formatting data into a tableVideo lesson
-
42Formatting data into a table. Part 2Video lesson
-
43Function/formula error in the next tutorialText lesson
-
44The If/And/Or functions. Part 1Video lesson
-
45Test your knowledge on the IfAndOr functionQuiz
-
46The If/And/Or functions. Part 2Video lesson
-
47Test your knowledge on the IfAndOr functionQuiz
-
48Introduction to printingVideo lesson
-
49Printing your first spreadsheetVideo lesson
-
50Test your knowledge on printing in ExcelQuiz
-
51Printer settingsVideo lesson
-
52Printing the second spreadsheet. Solution/exerciseVideo lesson
-
53Building a navigation pane. A few things to noteVideo lesson
-
54HEX to RGB converter link.Text lesson
-
55Building a Navigation Pane. Part 1Video lesson
-
56Building a Navigation Pane. Part 2Video lesson
-
57Test your knowledge on navigation panes and hidden links.Quiz
-
58VlookupVideo lesson
-
59Note about next tutorialText lesson
-
60Student request (Conditional formatting)Video lesson
-
61Subtotaling data. Part 1Video lesson
-
62Subtotaling data. Part 2Video lesson
-
63"Goals" Exercise instructionsVideo lesson
-
64Goals solution video!Video lesson
-
71Introduction to macrosVideo lesson
-
72Saving as an Excel Macro-Enabled DocumentVideo lesson
-
73How to create a macroVideo lesson
-
74How to create macros (Use Relative Referencing)Video lesson
-
75Macros exercise instructionsVideo lesson
-
76Macros exercise solutionVideo lesson
-
77Work with macros convenientlyVideo lesson
-
78Final thoughts on macrosVideo lesson
-
79Your 8-page instruction manual on MacrosText lesson
-
80A quick introduction to this sectionVideo lesson
-
81How to workout monthly payments with the PMT functionVideo lesson
-
82How to work out monthly payments with the IPMT functionVideo lesson
-
83How to work out yearly payments with the PMT & IPMTVideo lesson
-
84Exercise instructions and solution (PMT, IPMT, and more)Video lesson
-
85Working out variable rate payments with the PMTVideo lesson
-
86The interest only and weekly payment example spreadsheetsVideo lesson
-
87Your 4-page instruction manual on the PMT and IPMTText lesson
