Course Objective:

To equip participants with relevant tools and functions in Excel for the development of simple systems to replace certain manual and repetitive processes

Course Outline:

Inequalities & Operation Symbols
The MONTH, WEEK and YEAR Functions
The IF Function
Nesting Functions within Functions
QUARTERS
Working with Names
Data Validation
The VLOOKUP Function
Linking Cells and Range of Cells
The SUMIF Function
Array Formulae and how to Enter them
The TRANSPOSE Function
Embedding Charts in Worksheets
Adding Cell Protection
Macros