Microsoft Excel for Professional Users

Description

Students will advance their Microsoft Excel skills by exploring more advanced topics in Excel. Students will learn to create three-dimensional workbooks, and to link workbooks. Students will create financial forecast spreadsheets using the Excel financial functions. Students will learn to work with the workgroup features of Excel. Students will learn to import data into an Excel spreadsheet and will work with the data using the data management functions of Excel. Students will create Excel macros and will learn the basics of VBA. Students will need a basic understanding of Excel to complete this class. Students will need a copy of Office. A 60-day trial version is available.

Objectives

• Students will demonstrate what they have done with Excel
• 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: Reviewing the Basics

Review Chapters 1 - 4

Lesson 2: 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 3: 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 4: 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 5: 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 6: 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.