Advanced Excel course is designed for those aspiring to become successful Data Analysts or aspiring to start their careers in the field of Analytics. This Courses aid students in becoming world-class financial analysts in firms such as private equity, investment banking, equity research, corporate development, and Financial Planning and Analysis sectors.

Advanced Excel courses offer an in-depth tutorial of all the formulas and functions a student must master to become well equipped.

• Create personalized templates
• effectively work with sparklines
• Create and manage scenarios
• Use Goal Seek and Solver
• Create, manage, and format pivot tables and pivot charts
• Excel mathematical functions
• Perform data lookups
• Create and use IF statements
• Use Excel’s data functions
• Create and use data validation rules
• Create and use of macros
• Troubleshoot and audit formulas
• Import and clean data
• Create pivot tables and pivot charts
• Use queries to import external data
• link and consolidate worksheets and workbooks
• Troubleshoot errors

2 hours / Session
3 Session / Week for 8 Weeks

On-site: N100,000
Online Classes:

1. A Student is expected to have a stable Computer laptop of minimum RAM (random access memory) of 4gb and an operating system of 32bit/ 64bit (windows 7,8 or 10).

2. Digital Literacy or Computer Appreciation is a Pre-requisite.

3. A Student should be able to read and understand English Language.