What you'll learn
In this course, you'll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools.
You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer.
I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations.
Use the most commonly used Excel functions to make powerful calculations.
Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond.
Great for beginners to intermediate Excel users.
Requirements
All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning.
Description
"
Your Excel skills could land your next job."
- Fortune Magazine
A study reported in the Wall Street Journal found that
78% of middle-skill jobs
require digital skills like Excel and Word. And jobs that require digital skills also
pay 13% more
than those that don't.
Are you ready to
land your next job and increase your pay by 13%
?
This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery.
It's perfect for you
if you are a beginner or intermediate Excel user who needs to
drastically increase your Excel skills
to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.
Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.
You'll start at the very beginning
by opening and saving your first Excel document. Then you'll move on to
Create a
basic Kitchen Remodel Costs worksheet
.
Learn to use the
7 most popular functions in Excel
, including IF functions and VLOOKUP.
Create professional looking
pie charts, bar charts, column charts
and more.
Create a
table and a range
and sort your data.
Create
pivot charts and tables
to do lightening fast analysis of your data.
Learn to use new features of Excel including
1-click forecasting and 3D maps
.
Take your Excel skills to a whole new level to
impress your boss
and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.
Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that
most people wish they knew how to do
. This includes the 7 most popular functions, which you'll learn in this course
VLOOKUP
COUNT & COUNTA
COUNTIF & COUNTIFS
AVERAGE & AVERAGEA
SUM, SUMIF & SUMIFS
IF
LEFT, RIGHT & MID
Here are more of the
most sought after skills in Excel
that are included in this course
Spreadsheets
Tables
Ranges
Pie, Column, Bar and Line charts
Pivot tables
Pivot charts
Tons of tips and tricks to make using Excel easier every day.
So if you're ready to
take your Excel skills to the next level
and want to learn in an easy-to-follow way, click the
Buy now
button or check out one of the free preview lectures and I'll see you in the course.
100% Satisfaction Guaranteed
Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free.
So if you're even
considering
learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.
Who this course is for
This course is perfect for a first time beginner who needs to learn much more than just the basics.
This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
This course would not be useful for an Excel user who has already reached the advanced or expert stage.
Homepage

https://www.udemy.com/course/how-to-use-microsoft-excel-beginning-to-advanced-tutorials