Chapter 1 Creating Worksheets for Decision-Makers

Case: Rugby Fundraising with Scrip

Session 1.1 Introduction to Excel

Session 1.2 Essentials

Chapter 2 Planning and Creating a Worksheet

Case: Loan Analysis

Session 2.1 Writing Formulas and Copying Cell Contents

Session 2.2 Formatting Cells, Print Setup, and Printing

Chapter 3 Formatting a Worksheet

Case: TBA

Session 3.1 Editing Cells, Adding and Deleting Rows and Columns

Session 3.2 Formatting Cells

Chapter 4 Creating Charts

Case: Tracking Real Estate Sales

Session 4.1 Creating a Chart

Session 4.2 Enhancing a Chart

Chapter 5 Exploring Excel’s List Features

Case: Acme Company Employee Data

Session 5.1 Creating and Sorting a Data List

Session 5.2 Creating Filters and Subtotals

Session 5.3 Pivot Tables

Chapter 6 Common Functions

Case: Managing Accounts Receivable Lists

Session 6.1 Using Popular Statistical Functions

Session 6.2 Using Data Functions and Paste Special

Session 6.3 Using Financial Functions and Index Functions

Chapter 7 Integrating Excel & Office Objects

Case: TBA

Session 7.1 Linking

Session 7.2 Embedding

Session 7.3 Mining the Web

Chapter 8 Developing Multiple Worksheet and Workbook Applications

Case: TBA

Session 8.1 Working with Multiple Worksheets

Session 8.2 Working with Multiple Workbooks

Chapter 9 Using Data Tables and Scenarios

Case: TBA

Session 9.1 Data Tables

Session 9.2 Scenarios

Chapter 10 Using the Solver

Case: TBA

Session 10.1 Solving Problems

Session 10.2 Solving More Complex Problems

Chapter 11 Importing Data

Case: TBA

Session 11.1 Importing Text and Database Files

Session 11.2 Using Queries to Import Data from External Sources

Session 11.3 Querying the Web

Chapter 12 Automating Applications with Visual Basic

Case: TBA

Session 12.1 Building Data Management Macro Instructions

Session 12.2 Custom Functions

Session 12.3 Introducing Visual Basic