Microsoft Excel - Excel From Beginner To Advanced 2022

The complete 8-hour Excel course compatible with MS Office 365, or ANY version of Excel. Zero to HERO!

What you'll learn
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!
Requirements
No experience needed. You'll learn everything you need to know right from the beginning.
This course is compatible with any version of Excel. Including Excel in Microsoft Office 365.
No need to start from scratch. Almost all tutorials have a premade spreadsheet/workbook for you to download and use.
Take you time! Fast forward, rewind, and pause whenever you like.
Description
Did you know…Over 750 million people have Excel on their computer, but most don't know how to use it!This might be because Excel can come across as being a little awkward and not very user-friendly with first-time users.Well… within my course, 'Microsoft Excel - Excel from Beginner to Advanced 2022', I would like to dispel any awkwardness you may encounter, while using Excel, and quickly get you to a 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.- 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-section3" to accompany you during the first part of the course (After the basic introduction). 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.What can you expect after enrolment?We’ll start with a few introductory tutorials to get you set up for the course. Then, it’s onto section three, 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 enrol:- A 30-day money-back guarantee, so you can enrol 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 2022' today! And see where my course will take you :)I’ll see you in the first lesson.Warrick Klimaytys.

Overview

Section 1: Start Here

Lecture 1 A brief introduction to Excel

Lecture 2 The basic layout of spreadsheet

Lecture 3 Auto-fill, basic functions and more

Lecture 4 Exercise and solution video

Lecture 5 Course notebook preview

Lecture 6 Downloading your notebook templates

Lecture 7 Must know keyboard shortcuts when doing an online course

Lecture 8 List of keyboard shortcuts

Lecture 9 A general overview and brief introduction (MUST WATCH)

Section 2: Starting on the MainWorkbook

Lecture 10 Main Workbook download

Lecture 11 The three different types of references. Part 1

Lecture 12 The three different types of references. Part 2

Lecture 13 References exercise. A quick note

Lecture 14 References exercise

Lecture 15 2022 update to main workbook

Lecture 16 Formulas and functions. What's the difference?

Lecture 17 How to write formulas

Lecture 18 Basic function variations you must know

Lecture 19 Basic function variations you must know. SumIF and AverageIF

Lecture 20 Functions exercise instructions

Lecture 21 Welcome to the Concatenate function

Lecture 22 The IF Function

Lecture 23 2022 update to main workbook

Lecture 24 Introduction to charts

Lecture 25 Inserting a chart

Lecture 26 Chart exercise instructions

Lecture 27 Charts (And more) Solution video

Lecture 28 Formatting data into a table

Lecture 29 Formatting data into a table. Part 2

Lecture 30 Function error in next tutorial

Lecture 31 The If/And/Or functions. Part 1

Lecture 32 The If/And/Or functions. Part 2

Lecture 33 2022 course update

Lecture 34 Introduction to printing

Lecture 35 Printing your first spreadsheet

Lecture 36 Printer settings

Lecture 37 Printing the second spreadsheet. Solution/exercise

Lecture 38 Building a Navigation pane

Lecture 39 Vlookup

Lecture 40 Subtotaling data. Part1

Lecture 41 Subtotaling data. Part 2

Lecture 42 "Goals" Exercise instructions

Lecture 43 Goals solution video!

Section 3: Advanced printing

Lecture 44 Advanced printing

Lecture 45 Collation and more…

Lecture 46 Advanced printing. Part 2

Lecture 47 Advanced printing. Part 3

Section 4: Welcome to macros

Lecture 48 Introduction to macros

Lecture 49 Creating your first macro

Lecture 50 Create a macro with cell referencing

Lecture 51 Creating macro shortcut icons on the ribbon

Lecture 52 How to save a macro enabled Workbook. Best practices

Section 5: Using PMT and IPMT functions for a Mortgage

Lecture 53 Using the PMT function for a mortgage

Lecture 54 Using the IPMT function for a mortgage

Section 6: What if analysis

Lecture 55 What if analysis. Data table

Lecture 56 What if analysis. Goal seek

Lecture 57 What if analysis. Goal seek formulas

Section 7: 3D maps

Lecture 58 Introduction to 3D maps

Lecture 59 3D maps. How to use. Part 1

Lecture 60 3D maps. How to use. Part 2

Lecture 61 Link to Microsoft web page with data

Section 8: MUST know functions

Lecture 62 Must know functions. Part 1

Lecture 63 Must know functions. Part 2

Lecture 64 Must know functions. Part 3

Lecture 65 Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1

Lecture 66 Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2

Lecture 67 Excels drawing tools and more

Section 9: CHARTS within Excel

Lecture 68 Introduction to Charts in Excel

Lecture 69 Charts in Excel. Part 1

Lecture 70 Charts in Excel. Part 2

Lecture 71 Charts in Excel. Part 3

Lecture 72 Inserting sparklines and more

Lecture 73 Charts solution video

Section 10: Sorting large amounts of data

Lecture 74 Freezing the panes and more!

Lecture 75 Sorting the data (Exercise instructions)

Lecture 76 Sorting the data (Solution video)

Lecture 77 Filtering and analyzing the data. Part 1

Lecture 78 Filtering and analyzing the data. Part 2

Section 11: Deleting duplicate data, Concatenating and more!

Lecture 79 Locating and deleting duplicate entries

Lecture 80 Concatenate continuation training

Lecture 81 How to use the "DateValue" attribute within the IF function

Section 12: Working out true cost. PMT & IPMT for Finance

Lecture 82 Calculating the payment with the PMT Function

Lecture 83 Exploring true cost

Lecture 84 Calculating total cost

Lecture 85 Using the 'IPMT' function to work out interest

Lecture 86 Inserting a chart for reference (Car Finance)

Section 13: Welcome to Pivot tables and Pivot Charts

Lecture 87 Introduction to pivot tables and charts

Lecture 88 Source data checklist and building your first pivot table

Lecture 89 How the interface works (The field list) and more!

Lecture 90 Inserting our last Pivot table, charts, and beginning on our dashboard

Lecture 91 Building a dashboard and inserting slicers

Lecture 92 Farewell message

Lecture 93 Farewell

Anyone interested in becoming a proficient Excel user.,Anyone who would like to integrate the power of Excel into their personal or professional life.,Anyone who wants to add a truly valuable (and timeless) skill to their current skill set.,Anyone interested in becoming the coolest Excel ninja ever!