- Gain a high level of skill
in a short space of time
- Enhance your career prospects and maximise your efficiency at work
- Learning is made easy as the training is computer based with hands
on exercises and supported by high quality workbooks
- The workbook is yours to keep thus providing a source of reference
after the course has finished
- Learn at your own pace with flexible study times (including evenings
and weekends)
- Training in a comfortable and relaxed environment
- The opportunity to be awarded a BEST Training Diploma
|
-
Introduction
-
Introducing Functions - statistical, maximum, minimum, AutoCalculate, date functions
-
Conditional Functions - the IF function, comparison operators, embedded or nested IF's, conditional formats
-
Goal Seek
-
Data Tables & What If? Analysis - PMT function, one variable and two variable examples
-
Scenarios - adding, editing, deleting, summary report
-
Subtotals - creating, expanding, AutoComplete, \charting
-
Pivot Tables - analysing, changing, wizards
-
Data Mapping
-
Working with Maps
-
Workbook Security
-
Data Forms & Filters
-
An Introduction to Macros
-
Audit - precedents and dependants
|
