Learn Excel 2016. Master Excel formulas, functions, pivot charts & Excel shortcuts. Also works w/Excel 2010 & Excel 2013
What you’ll learn
Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons.
Learn all of the basics of opening an Excel document, creating a spreadsheet and saving your document to your computer.
Create a spreadsheet from scratch in Excel.
Use the most commonly used Excel functions to make powerful calculations.
Create your own Excel charts, graphs and tables.
Learn to use several of the new Excel 2016 features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
Create pivot tables and charts for lightening fast sorting and organizing.
Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016.
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 within the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that need digital skills also pay 13% quite people who don’t.
Are you able to land your next job and increase your pay by 13%?
This course is meant to show you the fundamentals and beyond of Excel 2016. It’s perfect for you if you’re a beginner or intermediate Excel user who must drastically increase your Excel skills to impress your boss, get a raise or maybe land a replacement job. Everything within the course is taught step-by-step in a simple , stress-free way.
Note: This course is specifically designed for learning on a PC. If you’re learning on a Mac, the shortcut keystrokes could also be different on your machine.
You’ll start at the very beginning by opening and saving your first Excel document. Then you’ll advance to:
Create a basic Kitchen Remodel Costs worksheet.
Learn to use the 7 hottest functions in Excel, including IF functions and VLOOKUP.
Create professional looking pie charts, bar charts, column charts and more.
Create a table and a variety and type your data.
Create pivot charts and tables to try to to lightening fast analysis of your data.
Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
Take your Excel skills to an entire new level to impress your boss and (although it’s ultimately up to you) position yourself for the raise or promotion you deserve.
Excel are often challenging to find out . the toughest part is knowing what to find out . This course is meant to show you the foremost popular functions and features of Excel that the majority people wish they knew the way to do. This includes the 7 hottest functions, which you’ll learn during this course:
VLOOKUP
COUNT & COUNTA
COUNTIF & COUNTIFS
AVERAGE & AVERAGEA
SUM, SUMIF & SUMIFS
IF
LEFT, RIGHT & MID
Here are more of the foremost wanted skills in Excel that are included during this course:
Spreadsheets
Pie, Column, Bar and Line charts
Pivot tables
Pivot charts
Tons of tips and tricks to form using Excel 2016 easier a day .
So if you’re able to take your Excel skills to subsequent level and need to find out in an easy-to-follow way, click the TAKE THIS COURSE button or inspect one among the free preview lectures to ascertain if it’s the right fit you.
Who is that the target audience?
This course is ideal for a primary time beginner who must learn far more than simply the fundamentals .
This course would even be helpful for an intermediate Excel user who must improve their skills in areas like 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 useful for increasing personal productivity, efficiency at work or maybe develeping skills to get a far better job.
This course wouldn’t 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
