Trusted Training Partners

Quick Look Course Summary:Advanced Excel Course & Financial Modelling Course For Accountants
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 16,700.00 EX VAT 3 Person R 11,644.28 EX VAT 10 Person R 7,836.00 EX VAT

  • Certification Type:Non Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Advanced Excel Course for  Accountants

    Sensitivity Analysis in Excel (Financial Modelling) and Advanced Excel Formulas

    Learn to perform a sensitivity analysis in Excel with this module on advanced financial modelling. The material focuses on applications suited to professionals working in financial planning & analysis (FP&A) and other finance-related areas.

    ‘A formula to be reckoned with’

    This course first structures a simple balance sheet and income statement. The module then uses direct and indirect methods in measuring financial sensitivity in line with both operating and financial stresses and our sensitivity analysis. The idea is to provide a set of practical modelling skills that can be used in your workplace. Upon completion of this module, you will have gained an in-depth understanding of how to build a comprehensive sensitivity analysis system into your Excel financial model.

    It also starts to provide the relevant tools to sort and summarise large data sources to provide inputs to your financial models. Techniques are then taught as to how to audit/review your model.

    Financial Statements and Excel

    • Dynamic financial statements. Structuring:
      • Balance Sheet
      • Income Statement
      • Cash Flow Statement
    • Calculating key financial ratios

    Model Integration and Financial Sensitivity

      • Overview
      • Direct Method

    Auditing

      • Tracing Precedent cells
      • Tracing the Dependents of a Cell
      • Displaying Formulas Within the Sheet

    Solving Formula Errors

      • Using Named Ranges
      • Understanding Formula Errors
      • Using the Trace Errors Commands

    Analyzing and presenting results – Financial Data

      • Overview
      • Charts in Excel
      • Gravity Sort Overview

    Course description part 2 – Advanced Excel Formulas and Functions

    The next level of Excel spreadsheet formulas takes you to the next level of Excel where you will learn the most advanced functions and formulas as well as types of financial analysis that will enable you to rapidly advance your skills in becoming an Excel expert.

    New Skills

    Specifically designed for those who are already proficient in Excel, the material in this advanced course will give you financial analyst skills used in investment banking, corporate development, private equity, equity research, commerce, and FP&A.

    Content and Overview

    In this course, you will learn to perform dynamic analysis and learn the power of advanced Excel functions. You will rapidly advance to using combinations of functions and formulas that are easy to follow and that will help guide you through the process. We also cover a number of functions and formulas in detail, including:

    FINANCIAL SPECIFIC FORMULAS

      • XNPV and XIRR
      • PMT, IPMT and principal payment calculations

    OTHER ADVANCED FORMULA (USED IN FINANCIAL CONTEXT)

      • INDEX and MATCH
      • IF with AND/OR
      • OFFSET combined with other formulas

    Why Participants Should Learn:

      • Professionalism and Efficiency: Mastering Excel transforms work output, enhancing professionalism and efficiency.
      • Customization and Visualization: Learn to customize Excel environments for better data visualization and interpretation.

    Target Audience:

    An advanced Excel course is suitable for:

    • Business professionals handling complex data, reports, and analyses.
    • Data analysts and scientists wanting advanced data manipulation skills.
    • Project managers working on project plans and data analysis.
    • Accountants and auditors seeking efficiency in financial reporting.
    • Entrepreneurs managing financial data for their businesses.
    • Researchers and academics using Excel for data analysis and visualization.
    • HR professionals handling large employee datasets.
    • Marketing analysts analyzing campaign data and creating reports.
    • IT professionals working with databases and ETL processes.

    Contact Us Now!

    Please Phone Us Now To Speak to One of Our Friendly Consultants to Provide This Course around your schedule:

    Tel: 011-882-8853

    Please Fill in the Form – We Will Get Back to You Within 15 minutes

    Please Email Us Now – We Will Get Back to You Within 15 minutes

    [email protected]

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Administrative Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated