Microsoft Excel 2007 Training Outline
Beginners
What is Excel?
Starting Excel
Basic Concepts of Spreadsheets
An introduction to Workbooks and Worksheets
Working with Rows and Columns
Cell References
Navigating within Excel
Using the Mouse
Using the Keyboard
Useful Keyboard ShortcutsData Entry
Entering Text, Numbers and Dates
Correcting Errors
File Management
Saving Files
Opening Files
Intermediate
Formatting Cells
Number Formats
Cell Formatting including Borders and Shading
AutoFormat
Format Painter
Printing and Page Setup
Scaling
Fitting to Page
Margins
Headers and Footers
Printing Options
Time Saving Techniques
Cut, Copy and Paste
Freeze Panes
Comments
Replicating Data
More Keyboard Shortcuts
Basic Calculations within Excel
Addition, Subtraction, Multiplication and Division
An Introduction to Functions
Functions, including SUM, MIN, MAX and AVERAGE
Gigo
|