default-logo

+234-817-745-0870

Location

Ikeja, Lagos

Date

26 - 28 June 2019

Time

9:00am - 5:00pm Daily

Fees ₦100,000

(For 3 days training, course material, lunch, refreshment and participation certificate) Discount rates applies!!!

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Microsoft Excel is an essential skill, whether you are working with data in an office or simply need to keep check on your finances our Microsoft Excel courses will help you get to grips with Excel’s functions and formulas. We have a variety of Microsoft Excel courses, from beginner to advanced, so whether you want to learn the Excel basics or fancy yourself as an Excel pro we have a course for you.
This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables.

This course will be very practical. Therefore the pattern of delivery will include tutorials, hands – on exercises and case studies. It is expected that at the end of each course, participants would have acquired immense skills useful to their personal growth, efficiency and workplace productivity.

    • Use Scenarios & Goal Seek
    • Use templates, data tables & solve problems
    • Use automatic formatting & styles
    • Work with views, consolidate worksheets
    • Create & revise PivotTables
    • Use, record & edit macros
    • Perform basic statistical validity calculations
    • Use Excel’s financial functions to calculate the amounts, rates, and time necessary to achieve financial goals or meet financial requirements
    • Calculate the financial value of a project or proposal and select among alternatives using basic measures such as Net Benefit (NB), Present Value (PV), Net Present Value (NPV), and the Internal Rate of Return (IRR)
    • Calculate breakeven points and/or required volumes via graphical analysis, algebra, and Excel’s Goal Seek tool to achieve financial goals
    • Utilize Excel’s Data Table and Scenario Manager tools to display the results of various financial scenarios by altering variables
    • Utilize Excel’s Solver tool to create optimal job and supply or supplier assignments, given constraints

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.