Email a Friend
Print
Add to Outlook
Event Information
Date
10/6/2008 - 10/8/2008
Time
6:00 PM - 8:30 PM
Venue
Carmichael Hall
Cost
85.00
Audience
General Audience
Additional Information
An introduction to core skills to become familiar with the Excel environment. You’ll learn the basics of data entry, formulas, and formatting.
Target Audience Individuals who are new to computers or inexperienced with using Excel.
Getting Started
Define Excel capabilities and uses
Excel 2007 environment
Open and save workbooks
Enter text, data and numbers
Preview and print a worksheet
Create workbooks from templates
Building and Editing Worksheets
Plan and design a worksheet
Edit cell entries
Create basic formulas
Create multi-operation formulas
Use Excel functions
Copy and paste cell data
Use absolute and relative cell references
Use AutoFill
Create Custom AutoFill Lists
Insert, delete, move and rename worksheets
Formatting Worksheets
Format worksheets for optimum readability
Format values in cells
Use Format Painter
Merge cells and modify alignment
Use AutoFormat
Insert, delete and adjust rows and columns
Use conditional formatting
Use Spell Check
Managing the Excel Environment
Freeze and unfreeze panes
Split Excel into multiple panes
Set up headers and footers
Work with page breaks
