Week 7 - Exploring Data Analysis and Business Intelligence (Ch8) | Recording and Editing Macros (Ch9)
Excel provides self-service business intelligence (BI) with its data analysis tools so that you can use Excel to accomplish what previously required the help of an information technology department. In this chapter, you explore scenarios, Goal Seek, Solver, data tables, and more.
Routine tasks such as entering the same label or calculating results for the same range can often be handled by macros. A macro is a series of instructions and keystrokes that executes a command. In this chapter, you learn how to run and record a macro, how to edit a macro in the Visual Basic Editor, and how to create a macro-enabled template.
At the end of this week, you will be able to:
- Create and manage scenarios for worksheet data.
- Use Goal Seek to backsolve a cell value for a formula.
- Use Solver to find a solution for a formula.
- Build data tables with one and two variables.
- Create a forecast sheet for time-based data.
- Get and transform data in a query.
- Explore PivotTable tools.
- Use the Analysis ToolPak to calculate statistical measures.
- Run a macro.
- Record a macro.
- Assign a macro to a Button form control.
- Edit a macro in the Visual Basic Editor (VBE).
- Record a macro with relative references.
- Save a macro-enabled template.
- Create a macros-only workbook.
- Read Excel Ch 8 (SIMBook) in SIMnet.
- Read Excel Ch 9 (SIMBook) in SIMnet.
- Complete the end-of-chapter questions to check your knowledge (you are not required to submit these).
- Complete Excel Ch 8 SIMBook Let Me Try in-reading tasks.
- Complete Excel Ch 8 SIMnet Project 1.
- Complete Excel Ch 8 SIMnet Project 2.
- Complete Excel Ch 9 SIMBook Let Me Try in-reading tasks.
- Complete Excel Ch 9 SIMnet Project 1.
- Complete Excel Ch 9 SIMnet Project 2.