Outcomes
| Working with Multiple Worksheets and Workbooks Simultaneously | • Use 3-D references • Use links and external references • Consolidate data |
| Sharing and Protecting Workbooks | • Collaborate on a workbook • Protect worksheets and workbooks |
| Automating Workbook Functionality | • Apply data validation • Work with forms and controls • Work with macros |
| Applying Conditional Logic | • Use Lookup functions • Combine functions • Use formulas and functions to apply conditional formatting |
| Auditing Worksheets | • Trace cells • Search for invalid data and formulas with errors • Watch and evaluate formulas |
| Using Automated Analysis Tools | • Determine potential outcomes using data tables • Determine potential outcomes using scenarios • Use the goal seek feature • Activate and use the solver tool • Analyse data with analysis ToolPak tools |
| Presenting Your Data Visually | • Use advanced chart features • Create Sparklines |
