We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Advance Excel

ENDED
Inquire Now
In-Person / Training
Ended last Aug 31, 2019
NGN  50,000.00

Details

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

Outline

  • 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

Schedules

No. of Days: 2
Total Hours: 16
Reviews
Be the first to write a review about this course.
Write a Review
We are an integrated web solution provision firm based in Lagos with expertise in web design, web development; web hosting, digital marketing, and other value-added services. Owned and staffed by seasoned web professionals with proven experience at delivering high impact web sites that communicate corporate personality and message effectively.
Alabian Solution Ltd
12 Olu Akerele Street, Off Kofoworola Crescent, Off Obafemi Awolowo Way Ikeja Lagos, Ikeja, Nigeria 100271
+234 803 426 5103
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.