|
| |
| 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 |
| |
|
|
| Demand led |
| Call to request dates |
| |
|
|
| |
|
|
|
|
|
| |
Spreadsheet Basics |
- Spreadsheet Concepts
- Exploring the Excel Window
- Working with Menus & 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
|
|
| |
|
|
|
| |
Formatting |
- Formatting Text & Sizes
- Changing Cell Alignment
- Changing Number & Date Formats
- Adding Shading & Borders
|
| |
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
|
| |
Page Setup & Printing |
- Using Print Preview
- Changing & Applying Print Options
|
|
| |
|
|
|
| |
| |
