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 17th Feb'18 9:00am - 5:00pm
Sat 24th Feb'18 9:00am - 5:00pm

Fee

Payment before 15th Feb'18 ₦40,000
Payment on 24th Feb'18 ₦50,000

Training Venue

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