Financial Modelling Workshop – Coast Branch

Loading Events
« Events
  • This event has passed.

October 18 @ 8:00 am - October 19 @ 2:00 pm

THE INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS OF KENYA

(Established under the Accountant Act, Laws of Kenya)

 

Financial Modelling Workshop – Coast Branch

Date: 18th – 19th October, 2018

Venue: Royal Court Hotel, CBD, Mombasa

 Brief

Financial modelling is the process by which an organization combines finance, accounting and business metrics to create a summary representation of some or all aspects of its operations.  Microsoft Excel is undoubtedly one of the most versatile and widely used financial modelling tools worldwide. Most accounting systems extract data to Microsoft Excel Reports which are then used for performance analysis and projections. Excel functionalities are therefore crucial in enabling finance and accounting professionals to play their role of aiding management decision making processes.

While it is important that professionals across the board be conversant with Microsoft Excel, for professionals in reporting-related roles, financial modelling skills make the difference between standard performance and excellence. For example, knowledge of pivot table functionalities would enable the summarization and hence analysis of bulk data in a matter of seconds.

This two day financial modelling workshop will provide delegates with an overview of Excel’s functionalities through interactive sessions and examples of spreadsheet techniques.  These will equip delegates to use pivot tables, audit and analyse worksheet data, utilize data tools, collaborate with others, and create and manage macros.

NOTE: Participants will be required to bring laptops as part of the learning tools for this seminar

Specific areas to be covered include:

  • Financial Modelling Basics – What is best practice, Layout tips
  • Getting and Transforming Data – Sourcing your data, Source data best practice, Preparing Source data
  • Key Functions and Formulas – Logic, Text and Temporal Functions; Conditional Math, VLookups, Sorting and Filtering
  • Range Names, Data Validation and Error Checks – Contiguous data, Excel tables and data validation.
  • Viewing, Linking and Protection – External links, worksheet protection and hiding formula
  • Data Analysis – Creating and formatting PivotTable; Using calculated fields in PivotTable
  • Data Visualization – Building Column, Bar, Pie and Line charts; Creating Pivot charts

Target Audience

Accountants, Auditors, Associate members, practicing members, Academia, Financial Advisors,  Consultants

Event Booking

Kindly note that booking is available either online at www.icpak.com/events  or on the ICPAK Live – A smart phone based application that is available from Google store. Delegates are advised to book early for planning purposes.

Charges

Charges for this forum are as provided below:

 Category Charges (Ksh)
Associate Members 6,950
Members 8,950
Non Members 10,950

 Continuous Professional Development (CPD) Units

Members of ICPAK will earn 14 CPD points upon successful attendance. Enquiries may be directed to us via email through memberservices@icpak.com.

Details

Start:
October 18 @ 8:00 am
End:
October 19 @ 2:00 pm
Event Category:

Organizer

ICPAK
Website:
icpak.com

Other

Target
Public and Private Sector
CPD Hours
14
Associates Member Cost
Ksh 6,950
Full Member Cost
Ksh 8,950
Non Member Cost
Ksh 10,950
Event Type
Seminar
Status
Open

Venue

Royal Court Hotel, CBD
Mombasa,
+ Google Map
Phone:
+254 727 531006
Jan 09
Jan 10
Jan 22

Trainers of Trainers – Beginners Workshop

Book Now
Jan 23

Trainer of Trainers Workshop – Intermediate Level

Book Now
Jan 23

1st Professional Forum – Mombasa

Book Now
Mar 27

The Annual Governance & Ethics Conference

Book Now
Dec 31
Dec 31

Tax and Economics

Book Now
Dec 31
Dec 31

RISK MANAGEMENT

Book Now
Dec 31

HANDLING TAX CONTROVERSY

Book Now

There are no upcoming events at this time.

Download

About ICPAK

ICPAK is an Institution
mandated to protect and uphold public interest
as well as develop and regulate the accountancy profession in Kenya.

Member Of:

Contact Information:

P.O BOX 59963-00200,
CPA Center, Ruaraka, Thika road.
Nairobi, Kenya.

Telephone Line (Main) : +254 719 074 000

Mobile: +254 719 074 000, +254 (0) 727 531006 / 733 856262 / 721 469796/ 721469169

Email: icpak@icpak.com

TOP