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

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

 

Upcoming Class Dates and Times

Aug 12, 2022
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Sep 13, 2022
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Oct 10, 2022
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Nov 09, 2022
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Dec 13, 2022
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR

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