Excel 2016 - The Complete Course for Excel Mastery
A complete guide to Excel 2016, including spreadsheet basics, 2016 features, functions, charts, tables and pivot charts.
"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 and beyond of Excel 2016. 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.
You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:
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:
Here are more of the most sought after skills in Excel that are included in this course:
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 TAKE THIS COURSE button or check out one of the free preview lectures to see if it's the perfect fit for you.
Steve McDonald
Promo Video
Introduction
Tour of Excel
Templates Tour
Saving Your Excel Document
Entering Data and Navigating Cells
Creating Simple Formulas
Working With Worksheets and Workbooks
Creating and Formatting a Heading
Formatting Subheadings and Columns and Alphabetizing Lists
Entering and Formatting Numbers
Final formatting Grids
Intro to Formulas and Functions
What is a Formula
Create Formulas to Calculate Total Costs
What is a Function
Anatomy of a Formula
Quickly Select Cells When Entering a Formula
Absolute vs Relative Cell reference
AVERAGE and AVERAGEA
COUNT COUNTA and COUNTBLANK Fixed
IF Function
SUMIF and SUMIFS Functions Fixed
COUNIF and COUNTIFS Functions
VLOOKUP Function
LEFT RIGHT MID Functions
Concatenate
LEN
FIND and SEARCH
Min and Max
AND and OR
ROUND
Conditional Formatting
Charts and Graphs
Charts Formatting
Bar Chart Creation
Pie Chart
Line Chart
Pivot Tables Prepare Your Data
Pivot Tables Creating a Pivot Table the 4 parts
Pivot Tables Quick Calculations with Lots of Examples
Pivot Charts
New Features for 2016
New Charts for 2016
Tell Me What You Want to Do Feature
1 Click Forecasting
Excel 2016 3D Maps Demo
Conclusion