Microsoft Excel - From Beginner to Pro

Go from complete Excel Newbie to Rock Star in just a few hours


What you'll learn
Be confident in Excel even if you’re a complete beginner
Advance your career with your new Excel skills
Enter and format different data type such as text, numbers and dates
Copy and Paste values, formats and formulas with ease
Master tools like AutoFill, FlashFill and Remove Duplicates
Easily Sort, Filter, Find, and Find & Replace data
Find out how Formulas and Functions work in Excel
Learn your first Excel Functions and several advanced Functions
Find out how to print one page, multiple pages and PDFs
Protect and secure your worksheets, workbook structure and files
Create your first Excel Charts
Discover Excel Tables, Pivot Tables and Pivot Charts with Slicers



Requirements
You do NOT need any prior Excel knowledge to do this course
You need to have Excel 2013, 2016, 2019, 2021 or Microsoft 365 installed on your device

Description
Go From Excel Newbie To Rock Star In Just a Few Hours!
Do you need to learn how to use Excel from the very beginning?
Do you wish someone would slow down, explain things properly and talk to you without the jargon?
Are you sick of Excel tutorials that you can hardly see because they don't zoom in?
Would you like fully interactive lessons with practice files you can download and use in Excel?
Well, You’ve Come To The Right Place!
Our
“Microsoft Excel - From Beginner to Pro”
course gives you everything you need to go from Excel Newbie to total Rock Star in just a few hours.
And unlike many other Excel courses, I slow things down, explain things properly and
ZOOM IN
so you can see everything clearly on your screen.
We Start At The Very Beginning
First up, I take you on a
Tour
of the main screens and menus so you can find your way around Excel. You’ll also learn a few ways to change the look and feel of your Excel screen so you can customise it to your liking.
Then we do some
Jargon-Busting
so you can get to grips with what words like: spreadsheet, workbook, worksheet, row, column and cell actually mean.
You will then learn how to create a new spreadsheet, give it a name and save the file to your device or to OneDrive.
Then It’s Time To Get Into The Good Stuff!
Over the next few sections you will learn the
Fundamentals
of how to manage the
Worksheets, Rows, Columns
and
Cells
of your Excel spreadsheets. This includes:
Inserting, deleting and renaming worksheets
Changing the height and width of rows and columns
Entering data into cells
Merging and unmerging cells
And much more
I will then show you the different
Data Formats
you can have in your spreadsheet’s cells such as:
Text, Numbers
and
Dates
and how to easily change the formats if you need to.
After that, you will learn a bunch of different ways to
Copy and Paste
in Excel, including how to paste only values, formats or formulas.
Don’t miss this!
You'll Master Excel's Time-Saving Data Tools
We then run through some
Amazing Tools
that will
save you lots of time
in Excel when using large ranges of data, such as:
AutoFill and Flash Fill
Find and Replace
Remove Duplicates
Sort and Filter
Easily Learn Formulas and Functions
Next up, I explained the
Basics of Formulas and Functions
in Excel so you can understand how they work before we dive into the lessons on a few of Excel’s most basic but popular functions: SUM, AVERAGE, COUNT, MAX and MIN.
Once you’re ready, you can move on to learning how to use a few more
Advanced Functions
such as: CONCAT, IF and VLOOKUP.
Get On Top of Printing and Security
I then show you how to set up your Excel spreadsheets properly so you can
Print
them to one page, multiple pages or PDFs.
After that, we'll cover some important security features in Excel such as how to prevent other people from making changes to various parts of your spreadsheets and how to
Password Protect
your Excel files for added security.
Create Your First Charts, Tables and Pivot Tables
Then, you’ll learn step-by-step how to create your first charts in Excel which are a great way to make large amounts of data easy to read.
You’ll also learn how to create Excel tables so you can filter and sort your data however you like.
Finally, we’ll finish the course by learning about how to use Pivot Tables and Pivot Charts, which are powerful tools that you can use to calculate, summarise, and analyse your data.
You'll Become An Excel Rock Star
I’m confident that I can make you an Excel Rock Star
in just a few hours
even if you’re a total Newbie.
So what are you waiting for? Sign up today and take your knowledge of Excel to the next level.
See you on the course!
Who this course is for:
This course is perfect if you are new to Excel and you want to start at the beginning
This course if perfect for you if you like well-paced lessons with clear, detailed explanations
This course is perfect for you if you have some experience with Excel but you want to build on your knowledge

More Info