Search Training
X

Excel 2013 - Formulas & Charts

Course Overview

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

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
08/12/2019 9:00AM - 12:30PM GTR Online LIVE OLL
10/10/2019 9:00AM - 12:30PM GTR Online LIVE OLL
12/02/2019 9:00AM - 12:30PM GTR Online LIVE OLL

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