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 8th Jun'24 9:00am - 5:00pm
Date 8th Jun'24 - 15th Jun'24

Fee

Payment before 8th Jun'24 ₦110000.00
Payment on 8th Jun'24 ₦110,000.00

Training Venue

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

Certificate

Certificate of Attendance to be issued by Alabian Solutions Limited

Saidi SOYOYE

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