Training Programme “KUTC Financial Continuous Professional Development (CPD) Workshop” - Advance Excel 2010

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 of Finance & 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 people and 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 info@kutckcr.com.

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, Karachi

To

i)     Project Director, RAILCOP Pakistan Railways Loco Road Karachi Cantt., Karachi.	ii)    Project Director, PRACS E.O.B.I House Shahrah-e-Faisal, Karachi.
iii)   Divisional Audit Officer, AGP(R) City Station, Pakistan Railways Karachi.

Encl:     Workshop Contents

CC:       Administration Department, KUTC

            Human Resource Department, KUTC

KUTC FINANCIAL CONTINUOUS PROFESSIONAL DEVELOPMENT (CPD) WORKSHOP

EXCELLENCE IN EXCEL

Advance Excel 2010

Financial & Non-Financial Tools and Techniques

In today’s 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 organization’s 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 LEADER

Mr. 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.

WORKSHOP CONTENTS

CPD HOUR-1

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 

CPD HOUR -2

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 

CPD HOUR -3

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 

CPD HOUR -4

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

• Understanding Chart’s Fundamentals
• Working with Excel Built in Charts
• How to Create Excel Non
• Native Charts for Data Analysis
• Creating Eye Catching Dynamic & Interactive Charts 

CPD HOUR -5

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 

CPD HOUR -6

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.