Philadelphia Corporation for Aging Training Catalog

This full-day workshop is for intermediate users who know the basics but want to learn how to make the most of Excel® features and functions and push their skills to the next level and users who are eager to learn additional shortcuts and tips that will boost their speed and productivity in Excel®.

Learning Objectives

Participants in the workshop will learn:

• To use the VLOOKUP and HLOOKUP functions.
• Why an automatic update of linked worksheets makes your job easier.
• How to create a linking formula with step-by-step guidelines.
• To create interactive macros and pause your macro to allow for user input.
• The most common Excel® printing goofs…and how to avoid them.
• How to perform a what-if analysis using the Scenario Manager.
• Two powerful reasons why you’ll leave this workshop as a macro user.
• How to record a macro in your customized toolbox.