Excel - Formulas & Charts
- 0.5 Course
- Language: English
Introduction:
In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.
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
Enroll in this course
£148.00
