Exploring Microsoft Office Excel 2007 Volume 1

Chapter 1 - Introduction to Excel

 

Section 1: Introduction to Spreadsheets

    Defining Worksheets and Workbooks

    Using Spreadsheets Across Disciplines

    Planning for Good Workbook and Worksheet Design

    Identifying Excel Window Components

    Entering and Editing Data in Cells

        Hands-On Exercise #1:  Introduction to Microsoft Excel

 

Section 2: Mathematics and Formulas

    Describing and Using Symbols and the Order of Precedence

    Displaying Cell Formulas

    Inserting and Deleting Rows and Columns

    Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill

        Hands-On Exercise #2:  Jakes Gym Continued

 

Section 3: Workbook and Worksheet Enhancements

    Managing Worksheets

    Formatting Worksheets

        Hands-On Exercise #3: Formatting Jake's Gym Worksheet

 

Section 4: Page Setup and Printing

    Selecting Page Setup Options for Printing

    Managing Cell Comments

        Hands-On Exercise #4: Printing Jake's Gym Worksheet

 

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

 

Chapter 2 - Microsoft Excel: Formulas and Functions 

 

Section 1: Formula Basics         

    Creating and Copying Formulas  

    Using Relative and Absolute Cell Addresses        

        Hands-On Exercise #1:  Smithtown Hospital Radiology Department Payroll           

           

Section 2: Function Basics        

    Using AutoSum

    Inserting Basic Statistical Functions       

    Using Date Functions    

        Hands-On Exercise #2:  Completing the Smithtown Hospital Radiology Department

 

Section 3: Logical and Lookup Functions

    Using the IF Function

    Using the VLOOKUP Function

        Hands-On Exercise #3:  Athletic Department Eligibility Gradebook

           

Section 4: Financial Functions   

    Using the PMT Function

    Using the FV Function   

        Hands-On Exercise #4: Purchasing a Van for the School for Exceptional Children  

 

Summary         

Key Terms       

Multiple Choice 

Practice Exercises        

Mid-Level Exercises      

Capstone Exercise        

Mini Cases

 

Chapter 3 - Microsoft Excel: Charts

 

Section 1: A Picture is the Message

    Choosing A Chart Type

    Creating a Chart

        Hands-on Exercise 1: The First Chart

 

Section 2: Chart Enhancements

    Modifying a Chart

    Enhancing Charts with Graphic Shapes

        Hands-on Exercise 2: Multiple Data Series

 

Section 3: Chart Distribution

    Embedding Charts

    Printing Charts

        Hands-on Exercise 3: Embedding, Printing, And Saving Chart as a Web Page

 

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

 

Chapter 4: Microsoft Excel: Working with Large Worksheets and Tables

 

Section 1: Large Worksheet Preparation

    Freezing Rows and Columns

    Hiding and Unhiding Rows, Columns, and Worksheets

    Protecting a Cell, a Worksheet and a Workbook

    Controlling Calculation

    Printing Large Worksheets

        Hands-On Exercise #1: Marching Band Roster

 

Section 2: Excel Data Tables

    Exploring Basic Table Management

    Sorting Data

    Filtering and Totaling Data

        Hands-On Exercise #2: Marching Band Roster Revisited

 

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases