|
Microsoft Excel Level 4
|
A spreadsheet programme which allows you to store lists
of text and numerical information, and make calculations and projections |
|
1 Day Intensive |
 |
|
|
Customisable |
|
|
|
Private Course |
|
|
|
Public Course |
|
|
|
Training Rooms |
|
|
|
Onsite |
|
|
|
Post-Course Support |
|
|
|
Consultancy Available |
|
|
Printable
Version
|
|
|
Suggested
Uses
|
-
Financial Management
-
Store,
sort and filter lists such as names and addresses
-
Create
financial templates
such as invoices or expenses sheets
-
Display your data on a chart
-
Summarise
large volumes of
information in pivot tables
-
Create
sophisticated
formulas to calculate information
-
Link to external databases
|
|
Course
Outline
|
Left, Mid & Find
Date-Based Functions
More Functions
Conditional Formatting
Print Options
Customise Toolbars & Menus
Templates
Custom Views
Validation
Macros |
VLookup & HLookup
Solver
Scenarios
Consolidate Data
Name a Cell or Range
Array Formulas
Spreadsheet Security
How to Use what You’ve Learnt
|
| |
|
|
After the Course |
|
You will be able to record macros, create templates to be used for
future calculations, summarise information with pivot tables and use
passwords to protect your work. You will also be able to combine
powerful mathematical functions to automate tasks and use array
formulas. |
|
|
If you would like to have a course customised for
your organisation, please contact us.
|
|
Back to Software
Training Course List |
|
|
