Formulae and Functions
Understanding syntax in formulae
Using the formula palette to edit formulae
Nested functions
AND and OR and their use with IF
SUMIF
Manipulating data
Goal Seek
Scenarios
Data Consolidation
Error correction
Error types and correcting common mistakes
Use of the Auditing toolbar
Use of the ISERROR function
Advanced formatting
Creating custom formats
Conditional formatting
Use of Edit, Go To, Special
Validation
Validating data input
Text manipulation
Text functions, CONCATENATE, RIGHT, LEFT, MID, PROPER, LOWER, UPPER
Excel forms
Creating forms using the Forms toolbar (NB this topic does not require
VB knowledge)
Macros
Recording and using macros
Assigning macros to buttons
|
