MICROSOFT EXCEL (INTERMEDIATE)

Course Objective:
This training is meant to provide necessary steps and coaching to enhance on the job productivity. This is achieved by increasing participants’ knowledge of application of Microsoft Excel in their current job role.

Course Outline:
• Using logical functions ‒ Creating nested IF functions, and OR functions, Combining logical functions,
• Working with lookups ‒ The VLOOKUP function, The HLOOKUP function,
• Advanced list management - Setting criteria for entry of text, values and dates,
• Using database functions - Setting up criteria - DSUM - DAVERAGE – DCOUNT
• PivotTables and PivotCharts ‒ Using the PivotTable Wizard, Creating PivotCharts, Using Slicers to manipulate PivotTables
• Macros ‒ Creating macros, Using the macro recorder, Viewing and editing macro VBA code

Target Attendees:
Staff, Engineers, Technicians and Admins that use Microsoft Office and computer day to day and would like to improve their proficiency in general computing

Training Locations:
Nigeria, Kigali, Dubai, etc.

Course Fee:
N300,000/per attendee
Group discount is available.

Duration:
4 DAYS