Categories

## Excel 2016 – The Complete Excel Mastery Course for Beginners

• 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

– 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.

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.

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:

1. Create a basic Kitchen Remodel Costs worksheet.
2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.
3. Create professional looking pie charts, bar charts, column charts and more.
4. Create a table and a range and sort your data.
5. Create pivot charts and tables to do lightening fast analysis of your data.
6. Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
7. 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:

1. VLOOKUP
2. COUNT & COUNTA
3. COUNTIF & COUNTIFS
4. AVERAGE & AVERAGEA
5. SUM, SUMIF & SUMIFS
6. IF
7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

2. Tables
3. Ranges
4. Pie, Column, Bar and Line charts
5. Pivot tables
6. Pivot charts
7. Tons of tips and tricks to make using Excel 2016 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 TAKE THIS COURSE button or check out one of the free preview lectures to see if it’s the perfect fit for you.

Who is the target audience?

• 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.

Created by Steve McDonald
Last updated 9/2018
English
English

Size: 1.22 GB