CODE: LCL A302

Pre-requisites/ Input Criterion: The candidate should:
Have completed the LAQSH Computer Literacy Skills- LCLI301 Program
OR
Fulfil the Exit Criterion Assessment for the LAQSH Computer Literacy Skills- LCLI301 Program

Duration: 24 hours

Course Description: This course is offered to those individuals for whom Excel is their bed of creating financial information and functioning. This is the advanced section where the more complicated aspects of Excel are dealt with to ensure that security and dealing with multiple worksheets are easier. MS Word and MS PowerPoint are areas that have been dealt with in entirety.

• Advanced Formulas and Functions
• Record Macros
• Link Workbooks
• Data Validation and Analysis
• Pivot tables
• V and H lookup
• Tracking, merging of workbooks
• Creating Custom user forms

Subsequent to course completion: You will be able to:

• Perform the most advanced calculations and functions
• Manipulate data using pivot tables and ‘advanced’ analysis
• Record macros and integrate with other office applications.