Advanced Microsoft Excel - 0.1 credits

Presenter:  Patricia Edgecomb

This workshop intersperses timesaving tips, tricks, and shortcuts with several of Excel's most useful features and functions. The session is organized into three areas: Worksheet Features, Functions, and Analysis Tools.

Worksheet Features:

• Work with external data sources?
• Use auditing tools to study worksheet formulas and fix errors in calculations?

Functions:

• Explore popular financial functions ?
• Explore text manipulations functions
• Use the VLOOKUP function to locate values in a table ??
• Use INDEX with MATCH to locate values in a table

Analysis Tools:

• Use Scenario Manager to store sets of input values for several models ?
• Use Solver to calculate the optimal result of a model ?
• Use Data Table to create a sensitivity table ?
• Aggregate data into Pivot Tables and Pivot Charts ?
• Collapse multiple worksheets into a consolidation Pivot Table ?

Prerequisites: ?Competence building Excel worksheets, including how to build formulas, use functions, move and copy cells, format cells, and use absolute cell references. Participants are expected to have the current version of Microsoft Office for Mac or Windows installed. Not all Excel features are available with Microsoft Office for Mac.