Excel Training
| Starting Date | March 24, 2022 |
| Duration | One Day |
| Location | Donegal |
| Certificate | N/A |
| Cost | To Be Confirmed |
| Course code | 9018 |
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 21st March 2022