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
Oct 24
Oct 26

Professional Forum – Nyanza Branch

Book Now
Oct 31

Video Session – Coast Branch

Book Now
Nov 01

Financial Reporting Workshop – Eastern Branch

Book Now
Oct 23

THE 5th C-SUITE SEMINAR – DUBAI

Book Now
Oct 24

THE ANNUAL FORENSIC AUDIT CONFERENCE

Event Closed
Nov 07

THE ANNUAL NPO FINANCIAL MANAGEMENT CONFERENCE

Book Now
Nov 14

THE FINANCIAL MANAGEMENT SEMINAR FOR MARITIME & LOGISTICS SECTOR

Book Now
Nov 20

THE 23rd ANNUAL EXECUTIVE SEMINAR – SEYCHELLES

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
Nov 15

FiRe Award 2018 (Conference, Award & Dinner)

Book Now
Nov 15

FiRe Award 2018 (Conference)

Book Now
Nov 15
Nov 16

FiRe Award 2018 (Gala Dinner)

Book Now
Nov 20

THE PREMIER TAX AND PUBLIC FINANCE CONFERENCE 2018

Book Now

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

Alternative Lines
Tel: +254 (0) 20 2304226, 2304227

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

Email: icpak@icpak.com

TOP