WyzGuys Computer Tutors

WyzGuys Computer Tutors

Computer Instruction. Web Design Instruction, and Web Hosting

Learning Microsoft Excel

Site Navigation

Creating Spreadsheets with Microsoft Excel

In this class, students will learn how to set up and format simple to moderately complex spreadsheets. We will focus on using simple formulae to automatically total columns and rows and perform various calculations. We will earn how to format your spreadsheet so it prints properly. We will also learn how to turn information in a table into a chart using Excel’s built in wizards and tools.

Curriculum Outline

The Microsoft Excel Window
Toolbars
Create a new workbook
Save a Workbook
Save and Save As: What’s the difference?
Open an Existing Workbook
The Active Cell
Cell Addresses
Entering Data
Formula Bar
Editing Data
Undo/Redo
Delete
Selection Methods
Formatting Cells
Format Menu
Insert Columns and Rows

Changing Column Width
Merge and Center
Insert Worksheets
Move Worksheets
Name Worksheets

Moving and Copying
Drag and Drop
Fill a Range of Cells
Extend a Series
Cell Comments
Formulas
Order of Operations
AutoSum
Copying Formulas
Copy Worksheets with Formulas
Print Preview
Page Setup: Page Orientation

Page Setup: Margins
Page Setup: Headers and Footers
Page Setup: Print Titles and Gridlines
Print the Worksheet
Manage Small Databases (Lists) with Excel
Sort a List
Filter a List
Charts
Modifying the Chart
Chart Components
Delete the Chart

A special thanks to Ray Hunder, who developed the original materials for this tutorial.

Used with permission

Curriculum developed by WyzGuys Computer Tutors

All Rights Reserved - updated 12/07/2006

Hosted by WyzHost.com

contact support@wyzhost.com