X

Excel 2016 Formulas & 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
07/17/2020 9:00AM - 12:30PM GTR Online LIVE OLL
08/20/2020 9:00AM - 12:30PM GTR Online LIVE OLL
09/21/2020 9:00AM - 12:30PM GTR Online LIVE OLL
10/21/2020 9:00AM - 12:30PM GTR Online LIVE OLL
11/30/2020 9:00AM - 12:30PM GTR Online LIVE OLL
12/31/2020 9:00AM - 12:30PM GTR Online LIVE OLL

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