Excel - Formulas & Charts
In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.
Upon successful completion of this course, students will be able to create Intermediate Formulas and Charts using Microsoft Office Excel.
1 – PERFORMING CALCULATIONS
- 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
Enroll in this course
Select a start date for your 0.5 course
Questions About This Course?
Need Help Finding The Right Training Solution?
Our training advisors are here for you.