Microsoft Excel XP - Popular Functions
This course 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 and columns
Borders and Line editing
Formatting Cells
Copy and paste
Average, Maximum and Minimum formulas
Numerical formats
Font and Border colour
Background colours
Save file to another name
Displaying multiple files, switching between files
Deleting Rows
Clearing Formats
Text Aligning
Changing Multiple Column Widths, AutoFit
Sorting in Ascending and Descending order
Addition Formula
Selecting Entire Sheet
Replace
Cut and Paste
Format Painter
Print Preview
Printing and Print settings
- Print Row Titles
Gridlines, Row and Column Headings
Margins
Zooming in and out
Landscape
Headers, footers, page numbering and dates
Print Area
Absolute cells references
Selecting multiple areas
Today formula, calculating with dates
System time and date settings
Adding, removing and moving Toolbars
Freezing Panes
Sorting Data
Text Wrapping
Equal Formula
Comments
Assignments