Philadelphia Corporation for Aging Training Catalog

As the title implies, this full-day workshop is for solid intermediate users who want to learn how to make the most of Excel®’ features and functions and push their skills to the next level and advanced users who are eager to learn additional shortcuts and tips that will boost their speed and productivity in Excel.

Learning Objectives

Participants in this workshop will learn:

• 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