Microsoft Excel Level Two
1 or 2 day course depending on experiece and requirements
This
course is designed for delegates who already have a thorough understanding
of the subjects covered in Level one. They should have a good
understanding of formulas, charts and spreadsheet layout. During the
course the learner will practice their skills with skill reviews and
exercises. An evidence of learning form will be completed during the
course and verified by the trainer. This can be used to prove competency
in the areas covered by the learner. A certificate of completion will also
be issued.
· Filters and Advanced Filters
· Lookup and Match
Functions
· Lookup and Hookup
· Custom Lists
· Absolute
and Relative Cell References
· Sort, Find and Replace
·
Workbook Protection
· Date and Time Functions
· The Concatenate
Function
· Financial and What If? Functions
· Conditional
Formatting
· PivotTables and Pivot Charts
· Scenarios
·
Subtotals
· Macros
· What is Visual Basic?
· Formula
Auditing and Validation
· Goal Seek
· Data Maps
