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



Schedule

Contact Us

UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Dec 18, 2024 - 0.5 day(s)
Dec 18, 2024
AMER
Remote-PST
AMER, Remote-PST
0.5
$148 USD
$148 USD
Dec 30, 2024 - 0.5 day(s)
Dec 30, 2024
AMER
Remote-PST
AMER, Remote-PST
0.5
$148 USD
$148 USD

Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud