A FIRST LOOK AT EXCEL

• Starting the Excel program
• What is the Active Cell?
• The Excel cell referencing system
• Entering numbers and text
• Default text and number alignment
• Adding a column of numbers
• Worksheets and Workbooks
• Saving a workbook
• Closing a workbook
• Creating a new workbook
• Opening a workbook
• Switching between workbooks
• Saving a workbook using another name
• Saving a workbook using a different file type

EXCEL 2007 - MANIPULATING ROWS AND COLUMNS

• Inserting rows into a worksheet
• Inserting columns into a worksheet
• Deleting rows within a worksheet
• Deleting columns within a worksheet
• Modifying column widths
• Modifying column widths using 'drag and drop'
• Automatically resizing the column width to fit contents
• Modifying row heights

EXCEL 2007 - COPYING, MOVING AND DELETING

• Copying the cell or range contents
• Deleting cell contents
• Moving the contents of a cell or range
• Editing cell content
• Undo and Redo
• AutoFill
• Sorting a cell range
• Searching and replacing data

EXCEL 2007 - MANIPULATING WORKSHEETS

• Switching between worksheets
• Renaming a worksheet
• Inserting a new worksheet
• Deleting a worksheet
• Copying a worksheet within a workbook
• Moving a worksheet within a workbook
• Copying or moving worksheets between workbooks

EXCEL 2007 - FONT FORMATTING

• Font type
• Font size
• Bold, italic, underline formatting
• Cell border formatting
• Formatting the background colour
• Formatting the font colour

EXCEL 2007 - ALIGNMENT FORMATTING

• Aligning contents in a cell range
• Centring a title over a cell range
• Cell orientation
• Text wrapping
• Format painter

EXCEL 2007 - NUMBER FORMATTING

• Number formatting
• Decimal point display
• Comma formatting
• Currency symbol
• Date styles
• Percentages

EXCEL 2007 - FREEZING ROW AND COLUMN TITLES

• Freezing row and column titles

EXCEL 2007 - FUNCTIONS

• What is a function?
• Common functions
• Sum function
• Average function
• Max function
• Min function
• Count function
• What are 'IF functions'?
• Using the IF function

CUSTOMIZING EXCEL 2007

• Modifying basic options
• Minimising the Ribbon
• AutoCorrect options

EXCEL 2007 - WORKSHEET SETUP

• Worksheet margins
• Worksheet orientation
• Worksheet page size
• Headers and Footers
• Header and footer fields
• Scaling your worksheet to fit a page(s)

EXCEL 2007 - PREPARING TO PRINT A WORKSHEET

• Visually check your calculations
• Gridline display when printing
• Printing titles on every page when printing
• Printing the Excel row and column headings
• Spell checking
• Previewing a worksheet
• Comparing Workbooks side by side
• Zooming the view
• Printing options