- This event has passed.
Excel Advanced – Instructor-led Online Series
October 30, 2023 @ 9:00 am – 4:00 pm
This 1-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: October 30, 2023
Time: 9:00 a.m. – 4:00 p.m.
Cost: $350.00
Instructor: Heather Lyon
