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
UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Dec 18, 2024 - 0.5 day(s)
Dec 18, 2024
AMER
Remote-PST
AMER, Remote-PST
0.5
$148 USD
$148 USD
Dec 30, 2024 - 0.5 day(s)
Dec 30, 2024
AMER
Remote-PST
AMER, Remote-PST
0.5
$148 USD
$148 USD
Do you have more questions? We're delighted to assist you!
1-877-797-2799
info@firefly.cloud