Infinite Grace Plaza, Plot 4 Oyetubo Street, off Obafemi Awolowo Way Ikeja Lagos

Advanced Excel Training

Be the master in your field, use MS Excel like a pro and be more productive Phone: 08034265103

Register NOW

About the Training

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

Date & Time

Time 9:00am - 5:00pm
Date 23rd Apr'22 - 30th Apr'22


Payment before 23rd Apr'22 ₦55000.00
Payment on 23rd Apr'22 ₦60,000.00

Training Venue

Alabian Solutions Limited
Infinite Grace Plaza,
Plot 4 Oyetubo Street,
off Obafemi Awolowo Way
Ikeja Lagos


Certificate of Attendance to be issued by Alabian Solutions Limited


Saidi is presently the Chief Strategic Officer at SaiSoy Solutions and also one of her founding directors, he is responsible for Corporate Training, Research and Planning. He has also worked at A. J. Silicon (Financial IT Consultants) where he was in charge of Advanced Ms-Excel Training ActiveData for Excel usage and Audit Command Language

Hardware Requirement

All students are expected to come to the training with their laptop and with Microsoft Excel installed on it

What Will Be Learnt

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