- This event has passed.
Excel Advanced (CMPT 0269) – Instructor-led Online Series – Online / Multi-Day
Event Series
(See All)
June 20 @ 9:00 am – 4:00 pm
This 2-day workshop is for experienced users of the Excel program. In this session, we learn some of the more advanced features of Excel, including advanced functions such as lookup, date & time, and financial functions; how to nest functions; Data analysis using Pivot Tables and Pivot Charts; and how to perform What-if Analyses. We also learn how to create forms in Excel. Students should have a good understanding of the basics of the program before taking this course.
Functions & Formulas
- Named Ranges
- Lookup Functions
- Date & Time Functions
- Checking for Formula errors
- Data Verification
- Financial Functions
- Nesting Functions
Pivot Tables & Pivot Charts
- Customizing Pivot Tables
- Filters
- Data Slicers
- Grouping Data
- Creating a Pivot Chart
- Changing Pivot Chart Options
- Drilling Down
Creating Forms in Excel
- Adding Command Buttons
- Spin Buttons and Scroll Bars
- Check Boxes and Option Buttons
- List Boxes and Combo Boxes
- Group Box
- Text Boxes
Performing What-if Analysis
- Using the Goal Seek Tool
- Working with Scenarios
- Using Cell Watch
Date: June 20 & 27, 2024
Time: 9:00 am – 4:00 pm
Cost: $700.00
Instructor: Heather Lyon
$700.00
