Country dropdown

Excel For Financial Professionals

INTRODUCTION

MS Excel is used in many financial departments, but most people only know a fraction of the myriad of ways that Excel can be used to effortlessly perform complex financial analysis. This intensive course has been developed by an experienced financial manager and IT consultant, to introduce financial people to advanced ways that MS Excel can be used as a support tool for the financial function. The course focuses on the practical financial applications of MS Excel, and even the most advanced Excel user will be amazed at the extra functionality that they will get out of Excel with the least additional effort. This course has been developed by an experienced Financial Manager and IT Consultant, and focuses purely on the practical applications of Excel that can be used in everyday work. Each delegate will have the opportunity to set up advanced spread sheets during the course, and experiment with conducting a wide range of financial analysis under controlled conditions.

DURATION

5 Days

WHO SHOULD ATTEND?

  • Debt and Credit Managers
  • Financial Managers and Directors
  • Credit Controllers
  • Accounts Officers
  • Bookkeepers
  • Accountants
  • Admin Assistants
  • Credit Supervisors
  • Debtors and Creditors Clerks
  • Internal Auditors
  • Accounts Support Staff

 LEARNING OBJECTIVES

At the end of this IRES training course, you will learn:

  • Using Excel to take control of financial data and put it into a format that can be used for effective decision making
  • Taking advantage of Excel’s many specialized features to produce management reports, quickly and easily
  • Using Excel’s advanced features to import data directly from other systems, sources and applications
  • Methods for implementing profit/cost tracking to help identify possible problems before they occur
  • Developing projections and trend analysis spread sheets to assist with management decision making
  • Automatic creation of graphs and charts to help illustrate key financial issues and trends
  • Writing and using Excel Macro’s and formulate to save time by automatically doing repetitive work

TOPICS TO BE COVERED                  

Module 1

Introduction - Using Excel for the Financial Function

  • Using Excel for Financial Analysis
  • Shortcuts and Time Saving devices when using Excel
  • Developing Multiple and Linked Spreadsheets
  • Ways that Excel can make your job easier
  • Customizing Controls

Getting it Right the First Time - Getting the Design

Logic Correct

  • Formatting worksheets correctly
  • Defining databases and calling them up
  • Utilizing Pivot tables
  • Setting up sub-forms and user interfaces

Module 2

Writing Macros to Perform Multi-stepped Tasks

  • Macro driven refresh and iteration functions
  • Macro driven report updating and printing
  • Macro driven pivot table analysis and update

Working and Setting up different Databases

  • Using filters and auto filters
  • Comparing current year to previous year
  • Calling up and linking databases

 

Module 3

Saving Time by Importing Financial Data Directly

Into Excel

  • How to import into Excel from Pastel and other
  • Financial packages
  • Importing data from Main Frames / Mid-Range sources
  • Relational Database Queries: SQL
  • Moving data between Windows programmes using QLE and DDE
  • Utilising the Universal User Interface in Windows

 

Using Excel to work with Costs and Costings

  • Ways of identifying, highlighting and eliminating unnecessary costs
  • Estimating Processing costs
  • Problems with Mark-up calculations
  • Monitoring Production Variations
  • Conducting Empirical Analysis

Bringing Estimation into Table Calculations

  • Constructing simple formulae
  • Relative, absolute and mixed references
  • Using the Function Wizard
  • 3D cell references

Module 4

Using Excel to Conduct Financial Trend Analysis

  • Profit Margin and Sensitivity Analysis
  • Running “what-if” scenario calculations
  • Using Excel’s built in statistical tools
  • Determination measures and regression formulae
  • Utilising Trend functions

Using Excel’s Graphical Function to Highlight Information

  • Simple ways of presenting graphical data
  • Shortcuts for generating charts and graphs
  • Quantifying the probability of certain risks

 

Module 5

Using Excel for Risk Management

  • Determining the effect of a number of variable factors on a process
  • Using Excel to identify key risks at an early stage
  • Calculating Contribution Margins
  • Monitoring Contribution Margins effect on total results
  • Using Excel’s Advanced Financial Functions
  • Utilizing the Solver function
  • Maximizing and Minimizing
  • Sensitivity Reports, Answer Reports and Margin Reports

Using Excel for Investment Decision Making

  • Conducting Contribution Margin analysis
  • Undertaking payback calculations
  • Determining the ROI levels
  • Checking cash flow analysis

• Considering loan risk management

 

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE

The training is residential and will be held at IRES training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email:  This email address is being protected from spambots. You need JavaScript enabled to view it.   

Mob: +254 715 077 817

Tel: 020 211 3814

TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training centre or at a convenient location.

For further inquiries, please contact us on Tel: +254715077817,+254 (020) 211 3814 or mail This email address is being protected from spambots. You need JavaScript enabled to view it.

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B 2nd September 2019.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

CANCELLATION POLICY

Payment for all courses includes a registration fee, which is non-refundable and equals 15% of the total sum of the course fee.

1.    Participants may cancel attendance 14 days or more prior to the training commencement date.

2.    No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met.

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

Event Properties

Event Duration 5 Days
Event Date 09-09-2019
Event End Date 13-09-2019
Cut off date 02-09-2019
Individual Price(Kenyan) KES 69,000
Individual Price (International) EUR 790
Individual Price(International in Dollars) USD 920
Location Nairobi, Kenya
We are no longer accepting registration for this event
Share this event:

Search