Virtual Excel Training – Level 2 (multiple sessions)

The Education Committee is partnering with instructors to provide virtual, interactive courses in 3 different levels of Excel. Each course will consist of (2) three hour sessions spread over 2 days. The cost of each course is $175 and includes course materials. The sessions are recorded and attendees will have access to the recordings for 30 days.

Attendees will receive 1 continuing education point completing the course.

Each course needs a minimum of 10 students enrolled and to preserve the best environment for interaction during the sessions, the class is capped at 30.

Course Sessions

• Group A: May 2, 9am – noon & May 4, 9am – noon
• Group B: May 9, 9am – noon & May 11, 9am – noon
• Group C: May 16, 9am – noon & May 18, 9am – noon

Here is what the course will cover:

Begin automating spreadsheets and learn how to create linking formulas that automatically connect data over many different worksheets, allowing for easy one-time data entry. Grow your portfolio by adding a group of the most powerful formulas frequently used in Excel and then splash your spreadsheet with useful graphics and templates to highlight and connect key informational points. In this course, you will learn: (1) advanced formatting: themes, cell styles, customizing page setup, (2) date and time functions, conditional formatting, (3) advanced functions for text and analysis: IF criteria, troubleshooting formulas, and (4) introducing lookup functions and the outline features.