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
