|
| |
| Target Audience: |
|
Users who need to be able to create, edit and format Excel spreadsheets, including creating basic calculations and formulae. |
|
| |
|
| Objectives: |
|
By the end of the course users will be able to produce a variety of spreadsheets, use formatting tools and page setup techniques to display and print spreadsheets effectively. Users will also be able to create simple calculations and use basic Excel functions. |
|
| |
|
| Prerequisites: |
|
Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. |
|
| |
|
 |
 |
 |
|
| |
|
|
|
|
| |
|
|
| |
Duration: |
1 Day |
| |
Cost: |
£125 + VAT |
| |
|
|
|
| |
| |
Course Date |
Location |
| |
10/02/2012 |
Liverpool |
| |
13/02/2012 |
Bradford |
| |
12/04/2012 |
Bradford |
| |
01/05/2012 |
Liverpool |
| |
18/05/2012 |
Bradford |
| |
28/06/2012 |
Bradford |
| |
10/08/2012 |
Liverpool |
| |
31/08/2012 |
Bradford |
| |
04/10/2012 |
Bradford |
| |
22/10/2012 |
Liverpool |
| |
04/12/2012 |
Bradford |
| |
13/12/2012 |
Liverpool |
|
|
|
| |
Spreadsheet Basics |
- Spreadsheet Concepts
- Exploring the Excel Window
- Working with the Ribbon & Commands
- Accessing & using the Help Facility
|
| |
Navigating, Selecting & Entering Data |
- Creating, Saving & Closing Spreadsheets
- Opening an Existing Spreadsheet
- Moving Around a Spreadsheet
- Entering, Editing & Deleting Data
- Using AutoFill & creating Custom Lists
|
| |
Editing Data, Columns & Rows |
- Inserting & Deleting Rows & Columns
- Adjusting Column Widths & Row Heights
- Using Cut, Copy & Paste
|
| |
|
|
|
|
| |
Page Setup & Printing |
- Using Print Preview
- Changing & Applying Print Options
|
| |
Basic Formulae & Functions |
- Using Formulas to Add, Subtract, Divide & Multiply Numbers
- Using the AutoSum Function
- Using the Average, Minimum & Maximum Functions
- Working with Relative & Absolute Cell References
|
| |
Formatting |
- Formatting Text & Sizes
- Changing Cell Alignment
- Changing Number & Date Formats
- Adding Shading & Borders
|
| |
|
| |
|
|
|
| |
| |
