Enhancing Excel Usage with Macros
Automating repetitive tasks Simplifying complex tasks and reducing errors Bulletproofing
Formulating Decisions from Database Information
Distilling data sets for data analysis Managing multiple data sets
Summarizing Business Information
Organizing workbooks and links Arranging multiple workbooks with Workspaces Managing
Optimizing Workbook Models with “What-If” Analysis
Planning for contingencies Managing variables in worksheets with Scenarios Comparing
Analyzing Data with Functions
Summarizing business data with functions Identifying the correct statistical function
Troubleshooting and Enhancing Professional Workbooks
Deciphering and correcting functions for data integrity Accurately interpreting calculations
