Fundamentals of Microsoft Excel 2007

Objectives

This course is designed for anyone who needs to understand the fundamental features and uses of Excel, and how to create simple spreadsheets, charts and databases. For a full introduction, it is suggested that this course is taken in conjunction with the Intermediate course.


Pre-requisites:

None other than a working knowledge of Windows or the Macintosh, or previous attendance on the Introduction to Windows or Introduction to Macintosh course.


Course Includes:

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.


Course Outline


File management and basics


· Launching Excel
· Starting a new workbook
· Opening an existing workbook
· Closing a workbook
· The size of a worksheet
· Entering data in cells
· Quick ways to navigate a document


Selecting and editing data


· Selecting single cells, whole rows and whole columns
· In-cell editing
· Overtyping the contents of cells
· Moving and copying data; cut and paste, drag and drop
· Collect & Paste


Formatting cells


· Using the standard and formatting toolbar
· Formatting fonts, borders and patterns
· Applying styles e.g. bold, italic etc.
· Changing column widths and row heights
· Number formatting (currency, percentages, dates etc).
· Using the Format Painter
· Using Conditional formatting
· The Formatting Smart Tag


Printing


· Using Print Preview
· Options in page setup, such as headers and footers, gridlines etc.






Structuring formulae


· Understanding spreadsheet cell references
· Using arithmetic and understanding the order in which Excel processes calculations (BODMAS)
· Copying formulae using AutoFill
· Use of simple functions eg. SUM(), AVERAGE(), MIN() & MAX()
· Understanding the difference between absolute and relative cell references


Data filtering and sorting


· The concept (and limitations) of a database or list in Excel
· Entering and editing data through a Data Form
· Sorting a list using one or more keys
· Using the AutoFilter Smart Tags
· Filtering values in a range
· Using the Sub-total command


Creating charts


· Selecting data in rows and columns correctly
· Using the Chart Wizard
· Choosing from bar, line, scatter, pie and other chart types
· Amending data on the fly
· Saving a chart by itself or attached to a worksheet
· Adding data series