What our clients
are saying:

A very good course –
a lot of material
covered in just
the right level of detail.
MG, Residential Real Estate Portfolio Manager

more...

Courses

Introduction to Excel | Advanced Topics for Business Users | Excel Reports and Charts

Introduction to Excel (1 day)

Available in Excel 2010

This course is for beginners: it covers everything you need to know to build good spreadsheets. The course has 9 modules:

What’s in Excel?

• Starting the program
• A tour of the main Excel screen and a quick look at each of the icons
• Workbooks and Worksheets – opening, modifying, saving, finding, naming
• Workbook Properties – the settings which control access and track usage
• Viewing and working with more than one Workbook at a time
  Help

Workbook Building

• Navigating around a Worksheet
• How Excel recognizes data – numeric or text
• Entering data – text, numbers, dates and times, symbols
• Autofill – make Excel enter data based on data already entered
• Cut, Copy, Paste, Paste Transpose
• Office Clipboard – getting data from, or giving data to, other Office applications
• Data Tables – what are they, why does Excel like them so much?
  Find and Replace, Spell-Checking

Workbook Management

• Copying Worksheets within a Workbook, or to another Workbook
• Hiding Worksheets without deleting them
• Inserting, moving, hiding, resizing, and deleting in a Worksheet: Cells, Rows and Columns
• Freezing Worksheet panes
• Worksheet Views

Formulas and Functions

• Entering a formula – keying, getting Excel to help you, using parentheses
• Editing a formula – including edit mode (F2)
• Absolute and Relative References – and using the F4 key
• Ranges – why use them?
• Ranges – defining, modifying, deleting
• Formulas which refer to cells in other Worksheets, or in other Workbooks
• SUM, SUBTOTAL
• IF
• AND, OR
• Recognizing and dealing with Errors – inside a formula, and errors generated by formulas

Formatting

• Cell contents – font, background, borders, colors, decimal places, comma separators, other attributes
• Conditional formatting – making a cell font and background different depending upon the cell’s value
• Worksheet Tabs
• Protecting Cells, Worksheets, Workbooks

Printing

• Preview
• Printer selection
• Set or modify printing attributes – print area, margins, size, orientation, headers and footers, graphics

Sorting Data

• Single and multi-column sorts
• Custom lists
• Filters
• Data Validation

Charts and Graphs

• Creation
• Change a Chart’s appearance
• Legends and Titles – setting, modifying
• Chart Data – selecting, modifying
• Trend Lines

Next Steps: Where to enhance your skills

The course makes extensive use of realistic examples:
every participant receives a detailed course handbook.