Advanced Excel & Financial Modelling

Course Description

Microsoft Excel is an essential skill, whether you are working with data in an office or simply need to keep a 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.

Key concepts covered include:
  • 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

Subscribe to our newsletter

Sign up to receive latest news, updates, promotions, and special offers delivered directly to your inbox.
No, thanks