Excel - Formulas & Charts

Price
$148.00
Duration
 0.5 Days
Delivery Methods
 VILT    Private Group
Eligible UT Programs: Learning Credits, Coupons, Technical Training Pass, Training Passport
UT PRO This class is part of our UT Pro subscription.   Click here to learn more.

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

Purchase Options

 

Upcoming Individual Class Dates and Times

Dec 13, 2022
8:00AM - 11:30AM CST
0.5 Days
VILT
 GTR
Jan 30, 2023
8:00AM - 11:30AM CST
0.5 Days
VILT
 GTR
Mar 15, 2023
8:00AM - 11:30AM CST
0.5 Days
VILT
 GTR
Apr 26, 2023
8:00AM - 11:30AM CST
0.5 Days
VILT
 GTR
Jun 07, 2023
8:00AM - 11:30AM CST
0.5 Days
VILT
 GTR

UT Pro 1 Year Subscription

Buy the UT PRO subscription for $395
Unlimited access to:
  • Hundreds of full-day and short duration live classes
  • Thousands of on demand videos
  • Digital quick reference cards
Need More Info? Learn More About UT Pro

Course Objectives

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

Agenda

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
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training