Philadelphia Corporation for Aging Training Catalog

Format: In-Person | Level: Intermediate | Duration: Full-day

Course Description

Now that you have mastered basic formulas, absolute and relative referencing, this course will take you to the next level. 

At 9:00 am SHARP, you'll sit back, relax, and watch a live guided demo on preparing Excel Tables, Pivot Tables reports, and charts. With no laptops needed, you can fully focus on finessing reports with sorting and subtotaling data, without the pressure of keeping up.

After lunch, bring your powered-up Windows based laptop (no plugging in permitted). In this hands-on session, apply what you’ve just seen with Excel practice files—step by step, with real support.

Learning Objectives:

After participating in this workshop you will know:

• The fastest-growing way to share your spreadsheets with others 
• Control functions most people don’t know they have or can use 
• Times when AutoFilter is a terrific tool – and times when it’s not 
• Simple shortcuts for creating Custom AutoFilters 
• Using macros to automate your worksheets 
• The 7 parts of the VB workspace and how to maximize your abilities with each 
• Everything you’ve ever wanted to know about Pivot Tables

DATE & TIME:

Tuesday, October 21, 2025

9:00 AM – 4:00 PM  – Trainer: Teresa Bell