Microsoft Excel Comprehensive

Description

This class will give you a working knowledge of electronic spreadsheets, what they are and how to use them. You will be able to create and format Excel spreadsheets that include charts and multiple worksheets. You will be able to create and execute formulas and use the Excel functions. Data sorting and manipulation are also covered. You will learn to create three-dimensional workbooks, and to link workbooks. You will create financial forecast spreadsheets using the Excel financial functions. You will learn to work with the workgroup features of Excel. You will learn to import data into an Excel spreadsheet and will work with the data using the data management functions of Excel. You will create Excel macros and will learn the basics of VBA.

Objectives

• Students will learn the purpose of using spreadsheets for business as well as personal use.
• Students will create and modify workbooks and customize the program window.
• Students will learn to quickly enter, edit and move data as well as proof it and organize it using tables.
• Students will learn to use formulas and functionas as well as dress up the appearance of their spreadsheets.
• Students will learn to filter, manipulate, sort, subtotal and look up list data.
• Students will link data in other workbooks, define and summarize multiple data sets and group them.  Students will also use tools to summarize and find solutions to problems as well as analyze statistical data.
• Students will learn to create PivotTables, Charts and Graphs.
• Students will learn to create macros and to use special printing tools.
• Students will learn to share information across other programs and to use tools to collaborate with others.
• Students will use Microsoft Excel to build a final project using what they have learned in this class.

Book

Lesson 1: Getting Started

Version 2007:  Review online materials and read chapter 1 in your book titled "What's New in Excel 2007."

Versions 2003 and 2002:  Review online materials and read chapter 1 in your book.

Lesson 2: Introduction to Microsoft Excel

Read and work through chapter 2 in your book called " Setting up a workbook."

Lesson 3: Working with Data and Data Tables

2007 version:  Read and work through chapter 3 in your book titled "Working with Data and Data Tables."

2002 and 2003 versions:  Read and work through chapter 3 in your book titled "Performing Calculations on Data."

Lesson 4: Calculations and Document Appearance

2007 version:  Read and work through chapter 4 titled "Performing Calculations on Data," and chapter 5 titled "Changing Document Appearance."

2002 and 2003 versions:  Read and work through chapter 4 titled "Changing Document Appearance."  Due to differences in book versions, you may need to refer back to the previous chapter if needed for some topics in this unit.

Lesson 5: Lists and Data Management

2007 version:  Read and work through chapter 6 titled "Focusing on Specific Data Using Filters," and chapter 7 titled "Reordering and Summarizing Data."

2002 and 2003 versions:  Read and work through chapters 5 titled "Focusing on Specific Data Using Filters," and 7 titled "Reordering and Summarizing Data".  

Lesson 6: Consolidating Data and Data Sets

2007 version:  Read and work through chapter 8 in your book titled "Combining Data from Multiple Sources" and chapter 9 titled "Analyzing Alternative Data Sets."

2002 and 2003 versions:  Read and work through chapter 6 in your book titled "Combining Data from Multiple Sources" and chapter 8 titled "Analyzing Alternative Data Sets."

Lesson 7: PivotTables, Charts and Graphics

2007 version:  Read and work through chapter 10 titled "Creating Dynamic Lists with PivotTables" and chapter 11 titled "Creating Charts and Graphics."

2002 and 2003 versions:  Read and work through chapter 9 titled "Creating Dynamic Lists with PivotTables" and chapter 10 titled "Creating Charts."

Lesson 8: Automating Repetitive Tasks. Printing

Version 2007:  Read and work through chapter 12 titled "Printing" and chapter 13 titled "Automating Repetitive Tasks with Macros."

Versions 2002 and 2003:  Read and work through chapter 11 titled "Printing" and chapter 12 titled "Automating Repetitive Tasks with Macros."

Lesson 9: Integration and Collaboration

2007 version:  Read and work through chapter 14 titled "Working with Other Microsoft Office System Programs" and chapter 15 titled "Collaborating with Colleagues."

2002 and 2003 versions:  Read and work through chapter 13 titled "Working with Other Microsoft Office System Programs," chapter 14 titled "Working with Database Data," and chapter 16 titled "Collaborating with Colleagues."

Lesson 10: Putting it all together

Review the previous lessons.

All content of this document is copyrighted by IDEA Solutions and the author. All rights reserved. Content may not be used without permission.