X

Excel 2016 - Formulas and Charts

Course Overview

In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.

Who Should Attend

This course is intended for individuals who want to gain basic knowledge of working on Excel.

Course Objectives

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

Course Outline

1 - PERFORMING CALCULATIONS

  • Functions
  • Absolute reference

2 - WORKING WITH FUNCTIONS

  • Named ranges
  • Logical functions

3 - WORKING WITH LISTS

  • Database functions

4 - VISUALIZING DATA WITH CHARTS

  • Creating and modifying charts

5 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

  • Creating links
  • 3-D references
  • Consolidating data

6 - USING LOOKUP FUNCTIONS

  • Vlookups
  • Hlookups

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
02/21/2020 9:00AM - 12:30PM GTR Online LIVE OLL
02/27/2020 9:00AM - 12:30PM GTR Online LIVE OLL
03/16/2020 9:00AM - 12:30PM GTR Online LIVE OLL
03/20/2020 9:00AM - 12:30PM GTR Online LIVE OLL
03/31/2020 9:00AM - 12:30PM GTR Online LIVE OLL
04/17/2020 9:00AM - 12:30PM GTR Online LIVE OLL
05/21/2020 9:00AM - 12:30PM GTR Online LIVE OLL
06/19/2020 9:00AM - 12:30PM GTR Online LIVE OLL

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