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 firsttime 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 revisit 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, “mainworkbooksection2” 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 preprepared 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 30day moneyback guarantee, so you can enroll riskfree.
– A lifetime access guarantee so you can revisit 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.
Starting on the MainWorkbook

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)
Advanced printing

11Main Workbook download in 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 3page 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.

33Update to the IF Function tutorial

34The IF Function

35Test your knowledge on the IF function

36Introduction to charts

37Inserting a chart

38Test your knowledge of charts

39Chart exercise instructions

40Charts solution video and more!

41Formatting data into a table

42Formatting data into a table. Part 2

43Function/formula error in the next tutorial

44The If/And/Or functions. Part 1

45Test your knowledge on the IfAndOr function

46The If/And/Or functions. Part 2

47Test your knowledge on the IfAndOr function

48Introduction to printing

49Printing your first spreadsheet

50Test your knowledge on printing in Excel

51Printer settings

52Printing the second spreadsheet. Solution/exercise

53Building a navigation pane. A few things to note

54HEX to RGB converter link.

55Building a Navigation Pane. Part 1

56Building a Navigation Pane. Part 2

57Test your knowledge on navigation panes and hidden links.

58Vlookup

59Note about next tutorial

60Student request (Conditional formatting)

61Subtotaling data. Part 1

62Subtotaling data. Part 2

63"Goals" Exercise instructions

64Goals solution video!
Welcome to the world of macros
Using PMT and IPMT functions for a Mortgage

71Introduction to macros

72Saving as an Excel MacroEnabled Document

73How to create a macro

74How to create macros (Use Relative Referencing)

75Macros exercise instructions

76Macros exercise solution

77Work with macros conveniently

78Final thoughts on macros

79Your 8page instruction manual on Macros
What if analysis

80A quick introduction to this section

81How to workout monthly payments with the PMT function

82How to work out monthly payments with the IPMT function

83How to work out yearly payments with the PMT & IPMT

84Exercise instructions and solution (PMT, IPMT, and more)

85Working out variable rate payments with the PMT

86The interest only and weekly payment example spreadsheets

87Your 4page instruction manual on the PMT and IPMT