Microsoft Excel - Excel from Beginner to Advanced 2024
- 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 2024′, 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 2024′ 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, we'll take a look at the Excel home screen. The Excel home screen is a great place to be! There is a tonne of things to take advantage of and enjoy.
-
2A little message before continuing :)Text lesson
-
3The components that make up a spreadsheet, and more (INTRO)Video lesson
-
4The components of a spreadsheet and moreVideo lesson
-
5Open this website for the next tutorialText lesson
-
6Basic text/data managementVideo lesson
-
7Autofill/FlashfillVideo lesson
-
8Autofill/Flashfill. Part 2Video lesson
-
9Autofill/Flashfill. Part 3Video lesson
-
10Exercise InstructionsVideo lesson
-
11Solution videoVideo lesson
-
12Course notebook previewVideo lesson
-
13Downloading your notebook templates and moreText lesson
-
14Must know keyboard shortcuts when doing an online courseVideo lesson
-
15List of keyboard shortcutsText lesson
-
16A general overview and brief introduction (MUST WATCH)Video lesson
-
17The main workbook download and instructionsText lesson
-
18The three different types of references. Part 1Video lesson
-
19The three different types of references. Part 2Video lesson
-
20References exercise. A quick noteText lesson
-
21References exerciseVideo lesson
-
22Your 3-page instruction manual on referencesText lesson
-
23Test your knowledge on referencesQuiz
-
24Formulas and functions. What's the difference?Video lesson
-
25Introduction to formulasVideo lesson
-
26Formula writing basicsVideo lesson
-
27Test your knowledge on formula writingQuiz
-
28How to solve formulas using BODMASVideo lesson
-
29Test you knowledge on the BODMAS ruleQuiz
-
30How to write formulasVideo lesson
-
31Methods for creating using functionsVideo lesson
-
32Basic function variations you must know. Part 1Video lesson
-
33Basic function variations you must know. Part 2Video lesson
-
34Functions exercise. SumIfs, AverageIfs, & CountIfsVideo lesson
-
35Welcome to the Concatenate functionVideo lesson
-
36Concatenate exerciseText lesson
-
37Test your knowledge on the concatenate function.Quiz
-
38Update to the IF Function tutorialText lesson
-
39The IF FunctionVideo lesson
-
40Test your knowledge on the IF functionQuiz
-
41Introduction to chartsVideo lesson
-
42Inserting a chartVideo lesson
-
43Test your knowledge of chartsQuiz
-
44Chart exercise instructionsVideo lesson
-
45Charts solution video and more!Video lesson
-
46Formatting data into a tableVideo lesson
-
47Formatting data into a table. Part 2Video lesson
-
48The I|f/And/Or functions. Part 1Video lesson
-
49Test you knowledge on the "If/And" functionQuiz
-
50The If/And/Or functions. Part 2Video lesson
-
51Test your knowledge on the "If/Or" functionQuiz
-
52Introduction to printingVideo lesson
-
53Printing your first spreadsheetVideo lesson
-
54Test your knowledge on printing in ExcelQuiz
-
55Printer settingsVideo lesson
-
56Printing the second spreadsheet. Solution/exerciseVideo lesson
-
57Building a navigation pane. A few things to noteVideo lesson
-
58HEX to RGB converter link.Text lesson
-
59Building a Navigation Pane. Part 1Video lesson
-
60Building a Navigation Pane. Part 2Video lesson
-
61Test your knowledge on navigation panes and hidden links.Quiz
-
62VlookupVideo lesson
-
63Note about next tutorialText lesson
-
64Student request (Conditional formatting)Video lesson
-
65Subtotaling data. Part 1Video lesson
-
66Subtotaling data. Part 2Video lesson
-
67"Goals" Exercise instructionsVideo lesson
-
68Goals solution video!Video lesson
-
69Advanced printingVideo lesson
We've already covered how to print in Excel in the previous section. While that information is still fresh in your head, I'd like to go into a little more detail about this area in Excel. Basically, we're going to look at some of the other settings and methods that can be used to achieve your printing goals. Please be aware that some of the printing settings you see me using in this section might not be available in your version of Excel. Though Excel tends to remain the same when it is updated, the printing settings seem to change the most.
-
70Missing printing featureText lesson
-
71Collation and moreVideo lesson
-
72Advanced printing. Part 2Video lesson
-
73Advanced printing. Part 3Video lesson
-
74Your 6-page printing instruction manualText lesson
-
75Introduction to macrosVideo lesson
You may have come across Macros in Excel or even used them. Well, this section is entirely dedicated to the world of Macros! Macros can be a bit peculiar as they have the potential to either be your greatest ally or your biggest challenge. What I aim to do is provide a thorough explanation and demonstration of Macros to ensure they become your trusted companion.
-
76Saving as an Excel Macro-Enabled DocumentVideo lesson
-
77How to create a macroVideo lesson
-
78Test your knowledge on MacrosQuiz
-
79How to create macros (Use Relative Referencing)Video lesson
-
80Test your knowledge on MacrosQuiz
-
81Macros exercise instructionsVideo lesson
-
82Macros exercise solutionVideo lesson
-
83Work with macros convenientlyVideo lesson
-
84Test your knowledge on MacrosQuiz
-
85Final thoughts on macrosVideo lesson
-
86Your 8-page instruction manual on MacrosText lesson
-
87A quick introduction to this sectionVideo lesson
In this section, you'll find the PMT and IPMT functions to be incredibly useful for calculating monthly mortgage payments. With the PMT, you can figure out the fixed monthly installment, even with a variable interest rate and different loan durations. Meanwhile, the IPMT breaks down the payments, showing you exactly how much goes towards interest and how much towards the principal amount each month. This knowledge will be invaluable to anyone who wants to navigate mortgage calculations. The PMT and IPMT functions can also be used to workout standard loans.
-
88How to workout monthly payments with the PMT functionVideo lesson
-
89How to work out monthly payments with the IPMT functionVideo lesson
-
90How to work out yearly payments with the PMT & IPMTVideo lesson
-
91Exercise instructions and solution (PMT, IPMT, and more)Video lesson
-
92Working out variable rate payments with the PMTVideo lesson
-
93The interest only and weekly payment example spreadsheetsVideo lesson
-
94Your 4-page instruction manual on the PMT and IPMTText lesson