Microsoft Excel 2007 - Popular Functions
This course manual is for the basic user to continue to enhance their knowledge and learn to apply more commonly used functions when creating spreadsheets.

Table of Contents
Inserting Rows
Borders
Format Cells
Lines and Borders
Drawing Borders
Erasing Borders
Border Colours
Copy & Paste
Average Formula
Maximum Formula
Minimum Formula
Number Formatting
Multiple Select
Create New Folder
Save As
Display Multiple Sheets
Switching between Sheets
Select Entire Sheet
Gridlines & Headings
Excel Options
Inserting Multiple Rows
Inserting Columns
Deleting Rows
Text Orientation
Sorting
Add 1 Formula
Replace
Cut / Move
AutoFit Multiple Column Widths
Print Preview
Page Setup - Print Row Titles
Gridlines
Row and Column Headings
Margins
Landscape
Headers and Footers
Printing
Absolute Referencing
Print Areas
Hide Columns
Selecting Multiple Areas
Password Protection
Normal View
Today Formula
Date Formats
Selecting Multiple Columns
Percentage Formats
Freeze Panes
Show Formulas
Inserting Sheets
Inserting Comments
Editing Comments
Customise Sort
Sort Levels
Filters
Filter Expressions
Clear Filters