Excel 2016 Formulas & Charts

Price
$295.00
Duration
 0.5 Days
Delivery Methods
 VILT    Private Group

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

 

Upcoming Class Dates and Times

Oct 06, 2021
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Nov 04, 2021
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Dec 03, 2021
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR

Who Should Attend

This course is intended for individuals who want to gain basic knowledge of working on Excel.

Course Objectives

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

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