12, Olu Akerele Street Ikeja, Lagos

Advanced Excel Training

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

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

Sat 30th Nov'19 9:00am - 5:00pm
Sat 7th Dec'19 9:00am - 5:00pm


Payment before 28 Nov 2019 ₦40,000.00
Payment on 30th Nov'19 ₦50,000.00

Training Venue

Alabian Solutions Limited
12, Olu Akerele Street,
off Kofoworola Crescent,
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