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:

Learning Activities

  1. Read Excel Ch 8 (SIMBook) in SIMnet.
  2. Read Excel Ch 9 (SIMBook) in SIMnet.
  3. Complete the end-of-chapter questions to check your knowledge (you are not required to submit these).

Assignments

  1. Complete Excel Ch 8 SIMBook 'Let Me Try' in-reading tasks.
  2. Complete Excel Ch 8 SIMnet Project.
  3. Complete Excel Ch 9 SIMBook 'Let Me Try' in-reading tasks.
  4. Complete Excel Ch 9 SIMnet Project.