Excel - Formulas & Charts

Skip to Scheduled Dates

Course Overview

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

Course Objectives

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

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

< Back to Course Search

Class Dates & Times

Class times are listed Eastern time
‘GTR’ = Guaranteed to Run

This is a half-day class

Price: $148.00

Register for Class

Register When Time GTR How
Register 04/23/2024 1:30PM - 5:00PM GTR VILT
Register 05/15/2024 9:00AM - 12:30PM GTR VILT
Register 06/06/2024 1:30PM - 5:00PM GTR VILT
Register 06/28/2024 9:00AM - 12:30PM GTR VILT
Register 07/24/2024 9:00AM - 12:30PM GTR VILT
Register 08/16/2024 9:00AM - 12:30PM GTR VILT
Register 09/10/2024 9:00AM - 12:30PM GTR VILT
Register 10/03/2024 9:00AM - 12:30PM GTR VILT
Register 10/28/2024 9:00AM - 12:30PM GTR VILT
Register 11/22/2024 9:00AM - 12:30PM GTR VILT
Register 12/18/2024 9:00AM - 12:30PM GTR VILT
Register 12/30/2024 9:00AM - 12:30PM GTR VILT