Programming & Development

Excel - Formulas & Charts

Introduction:

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

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

Enroll in this course

$148.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.