Description
In this Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.Objectives
Course Objectives
Upon successful completion of this course, students will be able to create Intermediate Formulas and Charts using Microsoft Office Excel.Target audience
Blank1 - 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.