Advanced and intermediate Excel training
PREAMBLE: Tedious man-hours are spent daily in completing a task that can be easily automated to provide the efficiency we desire in our workplaces. Microsoft Excel is an office tool that can make work much easier and more accurate when we know our way around.
TARGET AUDIENCE: Corporate Individuals, Business People and Job seekers.
OBJECTIVE: The objective of this training is to improve the efficiency and effectiveness of participants in the workplace. Participants who undergo this training will be able to increase their productivity by as much as 70%.
1. Cell referencing
2. Vlookup and Hlookup calculations.
3. Data analysis using Countif and Counifs functions.
4. Excel inbuilt functions.
5. Applying conditional formatting
6. Making Excel reports cosmetically appealing
DELIVERY METHOD: Classroom/Facilitator led.
MAXIMUM TRAINEE – TRAINER RATIO: 15:1
DURATION: 6 Hours
TRAINING MATERIALS for PARTICIPANTS: Laptops/Desktops with Microsoft Office Excel (2007 upwards)
COURSE MATERIALS: Study Videos
TRAINING ASSESSMENT: Participants will be assessed as they are trained to ensure comprehension.
Date: May 27th 2017
Venue: EmployMe e-learning Centre
To locate EmployMe E-learning Centre via google maps click here
NOTE: Certificate of participation will be issued at the end of the training.
Registration deadline: 20th May 2017.
To pay online click here