Excel Training
Programme Overview
This course is designed to give users more intermediate commands and functions and how to apply these in their own working environments.
Learning Outcome
- Learn Range Names
- Conditional Functions, if, nested if, countif, sumif, averageif
- Conditional formatting
- Formula Auditing Tools
- List management – custom sort/freeze panes/data validation
- Worksheet management & linking – linking content/protecting worksheets and workbooks
Who is this course for
- Everyone
Modules
Modules to include;
- Range Names
- Conditional Functions, if, nested if, countif, sumif, averageif
- Vlookup/Hlookup
- Conditional formatting
- Formula Auditing Tools
- List management – custom sort/freeze panes/data validation
- Worksheet management & linking – linking content/protecting worksheets and workbooks
- Macros – introductio
Trainer Profile
Applications Closing on 28th March 2022