Excel For Financial Professionals Course

Excel For Financial Professionals Course

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

COURSE OBJECTIVES

At the end of the training , you will learn to:

• 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 pieces of training are delivered using a combined learning approach and comprise of presentations, practical sessions, and online tutorials. Our facilitators are seasoned industry experts with years of experience, working as professionals 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 Profound Research Services (PRC) certificate.

TRAINING VENUE

The training will be held at PRC Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch.

All participants will additionally cater for travel expenses, visa application (where applicable), insurance among other personal expenses.

MEALS, ACCOMMODATION AND AIRPORT PICKUP

Breakfast, lunch, bottled water and evening refreshments/tea are provided at the venue during the training. Supper/dinner is catered for by the participant

Accommodation and airport pickup are 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..  

Mobile: +254 74040112

TAILOR-MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our PRC Training Centre or at a convenient location.

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

PAYMENT

Payment should be transferred to PRC account through the bank details provided on the invoice.

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

 

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.