RAI | Events

RAIEvent

A Two-Day Training Workshop on Excellence in Advance Excel Level 5: Financial and Non-Financial Tools And Techniques

A Two-Day Training Workshop on

Excellence in Advance Excel Level 5: Financial and Non-Financial Tools And Techniques

Introduction

Advance Excel 5 is name of course designed and delivered at Research Analytics International. This number â€œ5â€ means that this is the last advance level of Excel being designed and delivered. This course is designed both for accounting and non-accounting professionals. It is best for people engaged in Program Management, Research and Development, Data Analysis and related tasks, M&E, Finance and Accounts, Market Research, Students, Customer Care, Record Keeping and Decision Makers based on data. It is open for corporate as well as non-profit sector. The training will cover Excel versions from 2007 to 2013. The contents of the course are given below:

Advance Excel 5

Financial and Non Financial Tools and Techniques (Contents)

Summarizing Data Using Formulas:

v Defining Names to Cell & Ranges for Better & Quick Calculations

v Understanding Single & Multiple Conditional Summing & Counting

v Unhide the Power of Excel Array Formulas

v Build formulas containing relative, absolute, and mixed references

v Working with various financial functions

Advanced Sorting Techniques & Subtotalling:

v Complex Horizontal & Vertical Sorting

v Excel Subtotal Formula -Nesting Subtotalling & Grouping

Consolidate and Process Multidimensional Worksheets:

v Data Consolidation by Range & By Category

v Data Consolidation Using 3D Formulas

Excel Database Operations & Management:

v Working with Tables & Understanding Table Nomenclature

v Data Extracting Using Advanced Filter Techniques

v Complex Calculation Using Database Formulas

v Data Integrity Using Data Validation

v Working With Form

Scrutinizing Data Anomalies with Conditional Tests:

v Highlight Data Using Conditional Logic

v Understanding New Conditional Formatting Features

v Using Form Control with Conditional Formatting

Condensing and Refining Data with Pivot Tables and Pivot Charts:

v Analysing Data by Creating Dynamic Pivot Reports

v Consolidate Multiple Data Ranges & Analysis Using Pivot Consolidation

v Turn Bad Data into Good Data through Pivot Table

v Integrating Macros with Pivot Table

v Understanding Pivot Charts

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

v Understanding Chartâ€™s Fundamentals

v Working with Excel Built in Charts

v How to Create Excel Non Native Charts for Data Analysis

v Creating Eye Catching Dynamic & Interactive Charts

Optimizing Solutions with "What-If" Analysis:

v Building Investment Models Using Data Table

v Determining Profits with Goal Seek

v Comparing And Contrasting Data Sets with Scenario Manager

v Building Scenario Reports

Automating Your Work Using Macros:

v Understanding VBA Environment

v Absolute & Relative Recording

v Creating UDF (User Defined Functions)

Using the Auditing tools for eliminating errors:

v Use the auditing tools to avoid errors in financial models.

v Trace formula dependents and precedents.

v And trace errors, Circular reference and evaluate formulas.

Dashboard and Reporting Functions:

v Advance Charts and Techniques

v Dashboard and Advance Reporting/Modelling

How to register: Registering with us is quite simple. You either have to send us an email, give us a call or simply write some words on â€˜Contact Usâ€™ page at our website. We will be sending you the registration form along with other details. For final confirmation letter, please ensure that you have submitted fee before the last date of registration. Registration can also be done online at www.researchanalyticsintl.org/course_register.php.

Important Dates: Training on â€œExcellence in Advance Excel 5â€ will be held on February 10-11, 2015 (Last date 6 February 2015).The final agenda and venue details will be shared with all registered participants (who paid their fees).

Training fee and discounts: Training fee for one participant for two days attendance is

Rs. 13,300/= The Fee include trainer fee, material, certificates, venue cost, tea and lunch for participants. Discount is available in the following form:

1. 5% discount for two to four participants from same organization

2. 10% discount for five or more participants from same organizations

3. Local organizations, women and students are entitled for 10% discount

The fee can be paid by the following methods:

1. Online Deposits at UBL (1155)â€”School Road, Islamabad Branch: Acc # 000203686098

2. Cross Cheque: Account Title: â€œResearch Analytics Internationalâ€

3. Pay order/demand draft for â€œResearch Analytics Internationalâ€

For more upcoming trainings, please visit www.researchanalyticsintl.org/trainings.php.

We also provide in-house trainings to development and corporate sector.

Contact details and inquiries

Research Analytics International

Suite 407, 4^th Floor, Royal Centre, 106-West, Fazl ul Haq Road,

Blue Area, Islamabad, Pakistan

Tel: +92 51 4311633 / 2806093, 03455956885

Web: www.researchanalyticsintl.org, www.facebook.com/raipvt

Emails: info@researchanalyticsintl.org, trainings@researchanalyticsintl.org