• LOGIN
  • No products in the cart.

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.

 

  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.
  8. VLOOKUP
  9. COUNT & COUNTA
  10. COUNTIF & COUNTIFS
  11. AVERAGE & AVERAGEA
  12. SUM, SUMIF & SUMIFS
  13. IF
  14. LEFT, RIGHT & MID

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

  1. Spreadsheets
  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.
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.

Course content

59 lectures 05:47:25
Introduction to Excel 2016
27:58
02:31
Take a Tour of the Excel Dashboard – How to Use the Tabs and Ribbon
09:47
Using Excel Templates to Save Time and Effort
08:56
Creating Your First Excel Document
21:43
Creating Simple Formulas to Do Powerful Calculations
07:03
Working with Workbooks and Worksheets
08:42
Put Your Knowledge to Work – Create Your First Excel Document
00:24
Create a Kitchen Remodel Cost Worksheet
19:20
Formatting Subheadings and Columns and Alphabetizings Lists
03:28
Entering and Formatting Numbers
02:55
Create Formulas to Quickly Calculate Your Costs
06:08
Formatting – Grids and Spacing
03:25
Introduction to Excel Formulas and Functions
14:32
What is a Formula and What Can It DO for You?
02:00
What is a Function and What Does IT Do?
08:32
3 Things to Know Before You Start Using Functions
17:55
Absolute vs. Relative Cell References
06:52
Excel Shortcuts for Mac
00:42
How to Use the 7 Most Popular Excel Functions
53:16
How to Use the Downloads to Learn Functions Faster
04:14
COUNT, COUNTA and COUNTBLANK Functions
04:05
IF Functions
09:36
SUMIF and SUMIFS Functions
06:22
COUNTIF and COUNTIFS Functions
04:26
VLOOKUP Function
12:35
LEFT, RIGHT and MID Functions
08:54
Other Popular Excel Functions
01:01:10
CONCATENATE – Combining Text
04:36
LEN – Length of Text
03:04
FIND and SEARCH
03:52
MIN and MAX
04:54
AND and OR
06:10
ROUND, CEILING and FLOOR
13:24
TODAY and NOW
02:30
CONDITIONAL FORMATTING
08:46
ALT Shortcut Keys for INDEX/MATCH Lecture
04:17
INDEX and MATCH
09:37
Creating Charts From Your Spreadsheet
37:21
Charts Download
00:10
Introduction – How to Create a Chart
07:14
Format Your Chart
07:13
Create a Bar Chart
05:54
Create a Pie Chart
11:36
Create a Line Chart
05:14
Pivot Tables and Pivot Charts
44:05
Pivot Tables Download
00:04
Introduction to Pivot Tables – Preparing Your Data
11:07
How to Create a Pivot Table
12:13
Put Your Pivot Table to Work
13:37
Pivot Charts Download
00:07
Pivot Charts
06:57
Importing Data from Other Sources
07:30
Import from Web, Copy/Paste, and Cleaning Up Data
07:30
+New Features for Excel 2016
5 lectures38:19
What’s New in Excel 2016?
05:24
6 New Chart Types for 2016
10:36
“Tell Me What You Want To Do” – The New Help Feature
03:23
1-Click Forecasting
06:23
3D Maps
12:33
+Conclusion
2 lectures04:38
Conclusion
03:53
Where to Next? – Learn Advanced Excel
00:45
Download This Course
X