Excel - Formulas & Charts (UT-EXCEL)

Course Description

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

There are no prerequisites for this course.

Course Information

Length: 0.5 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16