X

Excel 2016 - Formulas & Charts

Course Overview

In this course, students will create, edit, and enhance spreadsheet formulas and charts using Microsoft Office Excel 2016.

Who Should Attend

This course is intended for individuals who want to gain knowledge of working on Excel using formulas and charts.

Course Objectives

Upon successful completion of this course, students will be able to create formulas and charts using Microsoft Office Excel 2016.

Course Outline

1 - BASIC FORMULAS

  • SUM, AVERAGE, MAX, MIN

2 - ABSOLUTE REFERENCES

3 - CALCULATING DATA WITH ADVANCED FORMULAS

  • 3D Formulas
  • Range Names
  • Special Functions VLOOKUP, IF, CONCATENATE, TODAY, PROPER, SUMIF, COUNTIF, RIGHT

4 - PRESENTING DATA USING CHARTS

  • Create, Modify and format charts
  • Line, Pie and Column Charts
  • Create Sparklines
  • Create line, column and win/loss Sparklines

Enroll Today

This is a half-day class

Price: $195.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time   Where How
11/25/2019 9:00AM - 12:30PM GTR Online LIVE OLL
12/10/2019 9:00AM - 12:30PM GTR Online LIVE OLL

Class times are listed Eastern time
This class is available for Private Group Training