Excel & Financial Modelling Practical Skills Workshop(Postponed)

Loading Events
« Events
  • This event has passed.

April 16 @ 8:00 am - April 17 @ 2:00 pm

THE INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS OF KENYA

(Established under the Accountant Act, Laws of Kenya)

Excel & Financial Modelling Practical Skills Workshop – Advanced

Date: (Postponed)

Venue: TBC, Mombasa

Introduction

Beyond being a data collection and storage tool, Excel’s functionalities make it an excellent data analysis and presentation tool. Numerous formulas embedded in the application allow users to crunch data and develop solutions to complex challenges. Advanced Excel and Financial Modelling skills particularly set apart professions in the finance and accounting fields as they are able to provide insight from multifaceted data using exceptional presentations.

Having previously practiced basic Excel skills, this workshop will delve into more advances Excel and Financial Modelling practical skills. Specific areas to be covered are:

  • Excel Power Query Review: Power Query & Excel, Power BI & Concepts
  • Data Sources: Querying Relational Databases, Extracting Data From Files
  • Transforming Data With Power Query: Query Steps, Working with Columns, Filtering Rows & Un-pivoting.
  • Working with Multiple Queries: Working with Data From Different External Data Sources, Merging two queries & Explicit Calculated Field
  • Data Modelling: Key Fields, creating & Managing Relationships, Linked tables & Hierarchies

NB: To practically follow the sessions, delegates are requested to carry laptops with Microsoft Excel 2016 pre-installed

Target Audience

Accountants, Auditors, Management Accountants, 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 8,000
Members 10,000
Non Members 12,000

Continuous Professional Development (CPD) Units

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

Details

Start:
April 16 @ 8:00 am
End:
April 17 @ 2:00 pm
Event Category:

Venue

Mombasa, TBC
Mombasa,
+ Google Map
Phone:
+254 727 531006

Other

CPD Hours
14
Associates Member Cost
Ksh 8,000
Full Member Cost
Ksh 10,000
Non Member Cost
Ksh 12,000
Event Type
Seminar
Status
Open
Aug 11

Anti-Money Laundering Video

Book Now!
Aug 11
Aug 11

FINANCIAL REPORTING: IFRS 9 Impairment and Credit Losses Video

Book Now!
Aug 11

Bribery and Corruption

Book Now!
Aug 11
Aug 11

Tax and Economics

Book Now!
Aug 11

Internal Audit Reporting Test

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
Mobile: +254 719 074 000, (+254) 733 856262
Email: icpak@icpak.com
[wps_visitor_counter]

TOP