4 out of 5
4
6 reviews

Microsoft Excel

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 [...]
53 students enrolled

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.

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

Description

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

  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.

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.

Introduction to Excel 2016

1
How to get The Most Out of This course
2
Excel Dashboard Tour
3
Using Excel Templates to save time and Effort

Creating Your First Excel Document

1
Saving and Finding your Document
2
Entering Data and Navigating around the Cells
3
Creating simple Formulas to do Powerful Calculations
4
Working with books and Worksheet

Create a Kitchen Remodel Cost Worksheet

1
Creating and Formatting your Heading
2
Formatting Subheadings, Columns and Alphabet listings
3
Entering and Formatting Numbers
4
Create Formulas to quickly calculate your costs
5
Formatting- Grids and Spacing

Introduction to Excel Formulas and Functions

1
Introduction to Excel formulas and Functions
2
What a Formula is and what it does
3
What a Function is and what it does

3 Things you need to know before using Functions

1
The Anatomy of a Formula
2
Quickly Select Cells to use in your Formula
3
Absolute Vs Relative Cell references

How to use the 7 most popular Excel Functions

1
How to use the Downloads to Learn Functions faster
2
AVERAGE and AVERAGEA Functions
3
COUNT, COUNTA and COUNT BLANK Functions
4
IF Functions
5
SUMIF and SUMIFs Functions
6
COUNTIF and COUNTIFs Functions
7
VLOOKUP Functions
8
LEFT RIGHT and MID Functions

Other Popular Excel Functions

1
Concatenate
2
Length of Text
3
Min and Max
4
And and OR
5
Round, Ceiling and Floor
6
Today and Now
7
Conditional Formatting
8
Alt shortcut Keys for Index Match Lecture
9
Index and Match
10
Find and Search

Creating Charts from your Spreadsheet

1
How to Create a Chart
2
Format your chart
3
Create a Bar Chart
4
Create a Pie Chart
5
Create a line Chart

Pivot Tables and Pivot Charts

1
Introduction to Pivot Tables
2
How to Create a Pivot Table
3
Put your Pivot Table to work
4
Pivot Charts

Importing data from other sources

1
Import the Web, Copy, Paste and Cleaning up Data

New Features for Excel 2016

1
What is new in Excel 2016
2
6 New Chart types for 2016
3
New Help Feature
4
1 Click Forecasting
5
3D Maps
4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
microsoft excel
30-Day Money-Back Guarantee

Includes

9 hours
Full lifetime access
Access on mobile and TV
Microsoft Excel
Category:
4 out of 5
4
6 reviews
Price:
Free