Business Certification, Management and Leadership Training Academy in Nigeria Management, Leadership and Business Certification Courses in Nigeria Certified Institute of Business, Leadership and Management Courses in Nigeria Management Courses in Nigeria Professional Management Courses in Nigeria Certified Business Professional Certification Business Management Courses and Training School in Lagos Business Process Outsourcing Certification

ADVANCE EXCEL TRAINING 2019

This training is for professionals who want to develop advanced skills in data analysis using Microsoft Excel. The training is intensive and hands-on programme

Business Certification, Management and Leadership Training Academy in Nigeria Management, Leadership and Business Certification Courses in Nigeria Certified Institute of Business, Leadership and Management Courses in Nigeria Management Courses in Nigeria Professional Management Courses in Nigeria Certified Business Professional Certification Business Management Courses and Training School in Lagos Business Process Outsourcing Certification

What Will Be Learnt

1. Introduction to Excel 2. Spreadsheet 3. Understanding Cell 4. Referencing 5. Data Extraction: Advanced Sorting & Filtering, 6. Creating Data Extraction 7. Using Vlookup, Lookup, Index and Match Functions 8. Data Validation 9. Conditional logical statements for business analysis (If, SumIf, CountIf, And, Or, Not etc) 10. Consolidating Multiple Sheets: Methods for automatically consolidating data from different sheets Building Financial Functions into Ms-Excel (PMT, FV, PV, PPMT, IPMT etc) 11. Importing & Exporting Data in Ms-Excel 12. Loan Amortization Schedule Sensitivity Analysis Testing Using Data Table 13. Pivot Table: Introduction to Pivot Tables and Pivot Charts 14. What-If Analysis (Goal Seek, Scenario Manager) Excel Macros - The Power of Automation.

Attend our next Advance Excel Class and get certified as a Data Analyst.

Training Fee: NGN30,000

Learn from the very best

Join our training class and start building the most wanted career available today. We make sure every class is easily understood, and that all students reach the same level of expertise needed for today’s hi-tech industry.

Date

6th, 13th, 20th, 27th April 2019
9:00am - 4:00pm

We are here

6, Olusoji Idowu Street, Ilupeju, Lagos State
Phone :08090202323

X