Week 7 - Working with Macros (Ch8) | Exploring Data Analysis and Maps (Ch9)
Overview
Routine tasks such as entering the same label or moving and copying a worksheet 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 and write a macro in the Visual Basic Editor, and how to create a macro-enabled workbook.
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, maps, and more.
Objectives
At the end of this week, you will be able to:
- Run a macro.
- Record and save a macro.
- Use form controls with macros.
- Edit and write macro code.
- Record a macro with relative references.
- Save a macro-enabled template.
- Use a macros-only workbook.
- 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.
- Use the Analysis ToolPak to calculate statistical measures.
- Work with Excel maps.
Learning Activities
- 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).
Assignments
- Complete Excel Ch 8 SIMBook 'Let Me Try' in-reading tasks.
- Complete Excel Ch 8 SIMnet Project.
- Complete Excel Ch 9 SIMBook 'Let Me Try' in-reading tasks.
- Complete Excel Ch 9 SIMnet Project.