Course Overview
This course introduces the
essential concepts of spreadsheets and covers how to set up and format a
spreadsheet. It also includes how to create formulas including Sum,
Average, minimum and maximum and how to present data in different formats
including professional graphs and charts.
This outline is based on
Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are
using a different version, please give us a call on 020 7359 9855.
Course
content
Introduction
Essential features
· The
new Excel interface
· The Office button
· Quick Access tool bar
·
The Ribbon
· Tabs and Context Tabs
· Page views
· Using
worksheets
· Readability
· Understanding file formats
Setting
up a spreadsheet
· Entering numbers and text
· Inserting rows
and columns
· Changing column widths
· Freezing/splitting panes
·
Formatting cells
· Using Autofill
· Alignment over columns
·
Creating borders
Creating calculations
· Entering simple
calculations
· Using the AutoSum tool
· Using the Function
Wizard
· Using absolute cell references
· Spearing information
·
Linking formulas
Working with multiple sheets
· Naming worksheets
·
Grouping worksheets
· Using Autoformats
· Using the Format
Painter
· Creating and using custom lists
· Sorting data
Creating
graphs
· Building a graph
· Editing a graph
· Grouping
graphs
· Adding keys and titles
· Changing the axis scale
Printing
worksheets
· Previewing techniques
· Changing orientation
·
Printing all or part of a worksheet
· Adjusting the print size to fit
the paper
· Creating headers and footers
Questions and
answers
