Untitled Document

Microsoft Excel for Beginners

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.

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 use Microsoft Excel to create a final project, using what they have learned in class.

Book

Microsoft Office Excel 2007 Step by Step

Author: Curtis D. Frye
Publisher: Microsoft Press
ISBN: 073562304X

If you are using an earlier version of Office, please let us know.

Microsoft Office Excel 2003 Step by Step

Author: Curtis D. Frye
Publisher: Microsoft Press
ISBN: 978-0735615182

Microsoft Office Excel 2002 Step by Step

Author: Curtis D. Frye
Publisher: Microsoft Press
ISBN: 978-0735612969

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".