Skip to Scheduled Dates
Course Overview
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
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