Week 7 - Exploring Data Analysis and Business Intelligence (Ch8) | Recording and Editing Macros (Ch9)

Overview

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.

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 1.
  3. Complete Excel Ch 8 SIMnet Project 2.
  4. Complete Excel Ch 9 SIMBook Let Me Try in-reading tasks.
  5. Complete Excel Ch 9 SIMnet Project 1.
  6. Complete Excel Ch 9 SIMnet Project 2.