Financial Modeling Using Advanced Excel

In today's fast-paced business climate, it is vital that decisions are made quickly and accurately. With our short program in Advanced Excel, we train our participants on how to analyses business problems, identify solutions and make sound decisions to achieve a competitive advantage. It is well known that many users of Excel working with financial data do not make optimal use of what the Excel package offers.

The emphasis of this program is to transfer key knowledge areas in analyzing data, develop reporting dashboards, build workable Excel models, and the use of the Advanced Excel functionality; to enable delegates develop financial models and demand models for decision making.

PROGRAM OBJECTIVES

• Construct and use financial models.
• Carry out scenario tests and sensitivity analyses.
• Carry out business valuation.

MODULES

Module 1: Referencing in Excel

• Absolute referencing.
• Relative referencing.
• Structured reference.

Module 2: Working with Structured tables

• Why you should use tables.
• Elements of an Excel table.
• Managing data in an Excel table.
• Using structured references with Excel tables.

Module 3: Formulas and Functions

• Function Overview.
• Math and Trig Functions.
• Financial Functions.
• Logical Functions.
• The AND Function.
• The OR Function.
• Nesting Functions.
• The VLOOKUP Function.
• The HLOOKUP Function.
• Concatenating Functions.
• Index, offset and Match Functions.
• Using Help for Functions.

CERTIFICATION

• Upon successful completion of the training, participants will be awarded Cynet East Africa Consultancy certificate.

N/B

• Training will be facilitated by Cynet East Africa Consultancy seasoned trainers.