Microsoft Excel Training - Foundation Course

Course Content

Getting Started

• Concepts
• Screen Layout
• Move Around Cells

Editing Speadsheet

• Enter/Edit
• Selection Techniques
• Cut/Copy/Paste
• Undo/Redo
• Fill by Example

Basic Formulae

• Enter/Edit Formulae
• Arithmetic Operators
• Autosum

Presentation

• Number Display
• Font Type/Size
• Align Data
• Patterns/Colours
• Adjust Col/Row
• Borders

File Procedures

• Save/Save As
• Open/Close

Printing

• Print Preview
• Define Print Area
• Printing Worksheet

Page Setup

• Orientation/Scaling
• Centring Horiz/Vert
• Headers/Footers
• Sheet Options

Managing Formulae

• Order of Precedence
  *The order Excel performs calculations in formulas
• Relative v. Absolute
  *Cell types
• Formula to Value
  *Pastes a value instead of a formula in a cell

Functions

• Min/Max
• Average/Count
• Sum
• IF
• Comparison Operators
  * Greater than, less than etc.

Range Names

• Create & Define
• Going to a Range
• Printing a Range
• Use in Basic Formula

Spreadsheet Efficiency

• Adding a Cell Note
• Page Breaks
• Freeze Titles
• Controlling Large Sheets

Charts

• Create
• Chart Types
• Autoformat
• Re-size/Move
• Legends & Titles

Basic Filtering

• Autofilter
• Selecting a filter
• Sort

Who Should Attend

The Microsoft Excel training course is designed for new user of Excel who have attended a Windows Foundation course or who have previos experience in the use of windows.

Venue & Duration

This is a two-day course held at Smart Learning Solutions' premises or on-site.