|
Microsoft Excel Level 3
|
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
|
|
Course
Outline
|
Link Worksheets and Workbooks
Functions
VLookup and HLookup
Name a Cell or Range
Pivot Tables
Conditional Formatting
Record Macros |
Customise Toolbars and Menus
Goal Seek
Paste Special
Auditing
Validation
The Euro
How to Use what You’ve Learnt
|
| |
|
|
After the Course |
|
You will be able to create formulas to model
financial data, record macros, quickly enter large amounts of data,
format your work neatly, create templates to be used for future
calculations, summarise information with pivot tables and use
passwords to protect your work. |
|
|
If you would like to have a course customised for
your organisation, please contact us.
|
|
Back to Software
Training Course List |
|
|
