|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
Microsoft Excel: Introduction
Business Skills Courses |
|
|
|
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.
|
|
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 |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
