training programme “kutc financial continuous professional development (cpd) workshop” - advance...

7/30/2019 Training Programme KUTC Financial Continuous Professional Development (CPD) Workshop - Advance Excel 2010

1/4

Thursday, December 13, 2012

KUTC/F&A/2012-13/XX

Subject: Training Programme KUTC Financial Continuous Professional Development (CPD)Workshop - Advance Excel 2010

We feel pleased to inform you that we are holding a 1-day Training Programme for the functionaries ofFinance & Accounts Department of Karachi Urban Transport Corporation Limited, a subsidiary of Pakistan

Railways on Saturday, January 05, 2013 at 10:00a.m. to 06:00p.m. The content, address of the venue of

the programme is annexed.

This one day short CPD Workshop is part of the Continuous Professional Development Program of the In-

house Financial Human Resource Development Notions that introduces concepts, tools, and mechanisms

to help design and implement the Corporation based In-house Professional Development programs.

The CPD Workshop presents examples of partnership programs among the financial functionaries of

Pakistan Railways, and formal and informal cross educational approaches that aim at developing a culture

continuous professional development. Further, it underscores the need for greater engagement with peopleand a better understanding of their financial models and resources.

In this regard, we are writing to encourage members of Finance & Accounts Department of your

organization to enroll and take advantage of this Professional Development workshop. The attached

brochure provides the detailed information regarding the workshop.

Registration should be made online through the link below not later than December 28, 2012.

http://www.kutckcr.com/form1.pdf

If you need further information, do not hesitate to contact the undersign or _______________, Manager HR

at [email protected].

We look forward to your participation which will improve the valued professional expertise sharing culture

among the organizations.

Thank you and kind regards,

(Shabbir Ahmed Pasha)Chief Financial Officer

KUTC, KarachiTo

i) Project Director, RAILCOP

Pakistan Railways Loco RoadKarachi Cantt., Karachi.

ii) Project Director, PRACS

E.O.B.I HouseShahrah-e-Faisal, Karachi.

iii) Divisional Audit Officer, AGP(R)City Station, Pakistan RailwaysKarachi.

Encl: Workshop Contents

CC: Administration Department, KUTC

Human Resource Department, KUTC


2/4

KUTC FINANCIAL CONTINUOUS PROFESSIONAL DEVELOPMENT (CPD) WORKSHOP

Advance Excel 2010

Financial & Non-Financial Tools and Techniques

In todays challenging environment business decisions are widely based on numbers besides ideas.Any decision on company policy has to be backed by detailed and accurate data that can stand the

scrutiny of both management and stakeholders. This is especially true for financial planning where

consistent and correct application of tools and techniques can help you accurately forecast what if

scenarios and design realistic forecasts which in turn lead to successful business decisions. Your

ability to construct a better and more comprehensive financial model will determine the success or

failure of your organizations growth and development.

WHO SHOULD ATTEND

Finance and Accounts Personnel and students of professional bodies.

Mandatory for the KUTC F&A Personnel.

SKILLS YOU WOULD LEARN

This practical course will help to take your analytical skills to the next level of accuracy. Intensive and

hands-on, the course is designed to equip you with step-by-step guides for effectively structuring and

managing an accurate financial model.

METHODOLOGY

Instructor-led, group-paced, learning models with structured hands-on activities.

COURSE LEADERMr. Shabbir Ahmed Pasha, ACMA, ACFA, APFA, ACSP, FITM, FICS, M.Phil. Associate. has more than 10

years diversified industry exposure. He is a Professional Trainer of HERITAGE Financial Management

Pakistan and its Associated Technical Assistance Firms.

He has been involved in corporate trainings, Workshops, Seminars & in Regulars classes for Data Analysis,

Dashboard Reporting, Excel Spreadsheets techniques, advance charting techniques and Advanced Reports

Development. Mr. Shabbir A. Pasha possesses special skills in MS Office 2003, 2007 & 2010.

Schedule

Date: Saturday, January 05, 2013 Timings: 10:00 a.m. to 06:00 p.m.

HR Investment: Finance & Accounts Staff of RAILCOP, AGP and PRACS Rs.2,000/- per person.Students of ICMAP/ICAP/PIPFA: 3,000/-

(Payable via Cross Banking Instrument in favor of Karachi Urban Transport

Corporation Limited along with the annexed form).

CPD Hours: 06 Hours

Venue: Registered office of KUTC, 53-B, Rest Camp Road, Karachi Cantt., Karachi.


3/4

Summarizing Data Using Formulas:

Defining Names to Cell & Ranges for Better & Quick Calculations

Understanding Single & Multiple Conditional Summing & Counting

Unhide the Power of Excel Array Formulas

Build formulas containing relative, absolute, and mixed references working with various financial

functions

Advanced Sorting Techniques & Subtotaling:

Complex Horizontal & Vertical Sorting

Excel Subtotal Formula -Nesting Subtotaling & Grouping

Consolidate and Process Multidimensional Worksheets:

Data Consolidation by Range & By Category

Data Consolidation Using 3D Formulas

Excel Database Operations & Management:

Working with Tables & Understanding Table Nomenclature

Data Extracting Using Advanced Filter Techniques

Complex Calculation Using Database Formulas

Data Integrity Using Data Validation

Working With Form

Scrutinizing Data Anomalies with Conditional Tests:

Highlight Data Using Conditional Logic

Understanding New Conditional Formatting Features

Using Form Control with Conditional Formatting

Condensing and Refining Data with Pivot Tables and Pivot Charts:

Analyzing Data by Creating Dynamic Pivot Reports

Consolidate Multiple Data Ranges & Analysis Using Pivot Consolidation

Turn Bad Data into Good Data through Pivot Table Integrating Macros with Pivot Table

Understanding Pivot Charts

Creating Interactive Data Reports with Excel Charts (Dashboard Reports):

Understanding Charts Fundamentals

Working with Excel Built in Charts

How to Create Excel Non


4/4

Native Charts for Data Analysis

Creating Eye Catching Dynamic & Interactive Charts

Optimizing Solutions with "What-If" Analysis:

Building Investment Models Using Data Table

Determining Profits with Goal Seek

Comparing and Contrasting Data Sets with Scenario Manager

Building Scenario Reports

Automating Your Work Using Macros:

Understanding VBA Environment

Absolute & Relative Recording

Creating UDF (User Defined Functions)

Using the Auditing tools for eliminating errors:

Use the auditing tools to avoid errors in financial models.

Trace formula dependents and precedents.

Trace errors, Circular reference and evaluate formulas.

training programme “kutc financial continuous professional development (cpd) workshop” - advance...

Documents