Advanced excel training - Lagos
Friday, 2 June 2017
Item details
City:
Lagos » Ikeja
Offer type:
Offer
Price:
₦35,000
Item description
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
ABOUT THE TRAINER - 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
VENUE
Alabian Solutions Limited
12 Olu Akerele Street,
off Kofoworola Crescent,
off Obafemi Awolowo Way
Ikeja, Lagos
Date & Time
9th June 2017 9:00am - 5:00pm
10th June 2017 9:00am - 5:00pm
FEE
Payment before 9th June'17 ₦35,000
Payment on 9th April'17 ₦45,000
CERTIFICATE
Certificate of Attendance to be issued
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
ABOUT THE TRAINER - 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
VENUE
Alabian Solutions Limited
12 Olu Akerele Street,
off Kofoworola Crescent,
off Obafemi Awolowo Way
Ikeja, Lagos
Date & Time
9th June 2017 9:00am - 5:00pm
10th June 2017 9:00am - 5:00pm
FEE
Payment before 9th June'17 ₦35,000
Payment on 9th April'17 ₦45,000
CERTIFICATE
Certificate of Attendance to be issued
Related ads
EMPLOYMENT AND BUSINESS PROGRAMS Objective: Growth Advice Training for Excellence (The GATE) by…
Excel Automation Solutions, Chennai (Its own by group of Control & Automation Experts, Working in…
This is a practical-oriented training on satellite based Vehicle tracking and fleet management…
Prince2 Training in Abuja (Wuse, Federal Capital Territory)
DETAILS Ecoways Trainings - We are an accredited PRINCE2 Training provider in Abuja. Since…
2 days workshop seminar on 10 power-packed modules on ip & cctv video installati (Lagos)
2 DAYS WORKSHOP SEMINAR ON 10 POWER-PACKED MODULES ON IP & CCTV VIDEO SURVEILLANCE CAMERA…
Advance photography and multimedia training (Iba, Lagos)
Boost Your Productivity and Skill; a.) BASIC & ADVANCE PHOTOGRAPHY b.) Multimedia Post Production…
WIRELESS TRAINING CENTER | A STAFF CANADA GROUP COMPANY | LEARN PROFESSIONALLY. Smartphone Repair…
Dear friend, You've been specially invited to participate in our one day F R E E PROFESSIONAL…
Deslog Energy Services Limited (The International Oil & Gas Training Organization) in partnership…
TRAINING SCHEDULE: General HSE Level – 1 & 2 (Basic & Proficiency Course): DATE: FEBRUARY…
