|
Advanced Excel Training
NGN 60,000 |
Venue: No. 4 Kaltungo Street, Off Egbedi Close, Garki 2, Abuja
Other Dates
Venue | Date | Fee | |
---|---|---|---|
Boat House, Isheri Road, Aguda, Ogba Lagos, Lagos State, Nigeria | 15 - 22 Feb, 2020 | NGN40000 |
About the Training
This training is for professionals who want to develop advanced skills in data analysis using Microsoft Excel. The training is an intensive and hands-on programme
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
- 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
No. 4 Kaltungo Street, Off Egbedi Close, Garki 2, Abuja | Feb 26 - 27 Feb, 2020 |
Boat House, Isheri Road, Aguda, Ogba Lagos, Lagos State, Nigeria | 15 - 22 Feb, 2020 |
NGN 60,000.00 | (Abuja) |
NGN 40,000.00 | (Lagos) |
Joseph 08025059997