Excel for Power Users

Pre-registration required. For full course details (including location) or to register for this class, log into the UC Learning Center.

Recommended prerequisite: Significant experience using Excel.

Upon completing this training, you will be prepared to:

Analyzing Spreadsheet Data Effectively with Advanced Formulas

• Derive meaning from the results of statistical formulas … without being a statistician!
• Combine information and logical functions to write formulas which respond to the contents of specific cells.
• Analyze investments rapidly with built-in financial functions.
• Create array formulas to perform calculations on a series of cell values simultaneously.

Taking PivotTable Analysis to the Next Level

• Isolate PivotTable data which cannot be grouped by sorting or filtering with custom grouping.
• Build custom calculations to summarize PivotTable data based on the values of related cells.
• Create calculated fields which modify the way PivotTable data is displayed in relation to other data.

Creating Powerful, Customizable Dashboards to Display Key Data in a Single View

• Design dashboards for optimum usability which highlight data of greatest decision making value.
• Enable consumers of your data to customize dashboard layout and content.
• Test dashboard layouts rapidly for an optimal end product.

Enhancing Spreadsheet Functionality with Powerful, Multi-Purpose VBA Macros

• Understand the full power of macros, not only to automate but to engage and empower users of your spreadsheet.
• Master key techniques to design macros which are both flexible and robust.
• Manage a large number of macros with a minimum of effort.

Giving Users Control Over the Way They Interact with Spreadsheet Data

• Communicate information of greatest value to spreadsheet users with custom message box displays.
• Enable users to provide input to control the way macros perform.
• Integrate logic into the functionality of macros, responding intelligently to user behavior.