- This event has passed.
Event Series:
Excel Advanced – Instructor-led Online Series
Excel Advanced – Instructor-led Online Series
March 26 @ 9:00 am – 4:00 pm
This two 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: March 19 & 26, 2024
Time: 9:00 a.m. – 4:00 p.m.
Cost: $700.00
Location: Online
Instructor: Heather Lyon
