You are on MyJobMag Nigeria. Go to MyJobMag Nigeria instead.

Advanced Excel Training

The Advanced Excel Training will help you master Data analysis and learn how to use intermediate and advanced Excel functionality to get your work done faster.

N60000 N40,000Enrol Now

Program duration is 3 Days   Training start date: 26 February, 2019
  • Course Description

    The Advanced Excel Training will help you master Data analysis and learn how to use intermediate and advanced Excel functionality to get your work done faster.

    This training is for professionals who want to learn how to use Excel for data analysis and work more efficiently. The class is hand-on and offer practical worksheets and examples.

    Why Learn Advanced Excel Training

    Here are some of the reasons why mastering Excel is good for you:

     

    1. Microsoft Excel is used by lots of companies and business. Therefore understanding how to use it is important.
    2. Microsoft Excel is used for financial related activities
    3. It offers a great interfact that allow user to organize any type of information

     

    With these Advanced Excel training,you will learn how to:

     

    • Perform data analysis
    • Use formaula
    • Create Charts
    • Create Pivot table

    What are the requirements?

    Students are required to have basic knowledge of how to use a computer. Students are also encouraged to come with their own laptop for the training

    Course Content

    What you will learn:

     

    • Introduction to spreadsheet
    • Understanding the basis of 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

    Venue & Enrolment Process

    At the end of the training, participates will be awarded a Diploma Certificate in Microsoft Excel

    N60000 N40,000Enrol Now

  • Have questions? Get in touch

  • Other Courses

Have a Question?

 08121633133
Advertise your training programs and courses on MyJobMag