Advenced Excel Training - Islamabad

Advance Excel 2010

Training Work Shop
2

Training Contents



DAY-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 & Subtotalling:

· Complex Horizontal & Vertical Sorting

· Excel Subtotal Formula -Nesting Subtotalling & 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

PROFILE PROFESSIONAL TRAINER

Mr. Tahir Mahmood Fazal had done ACFA (Associate Certified Financial Accountants), MBA
Finance & IT) and C.A (Inter) & Microsoft Specialist –EXCEL 2003, 2007 & 2010, possesses

intense Finance & IT background with 16-1/2 Years Professional Experience in diversified

Industry, INGO’s exposure, he has been involved in Corporate trainings, Workshops, Seminars
in Regulars classes for Data Analysis, Dashboard Reporting, Excel Spreadsheets techniques,

advance charting techniques. I am also associate member of as Advance Excel Trainer of the

Institute of Cost and Management Accountants of Pakistan [ICMAP-LAHORE)

In house Trainings and Professional Centers:

He has 200 employee(s) trained with 100% satisfaction results

DAY-2

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

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.
· And trace errors, Circular reference and evaluate formulas.

For Registration Please email us your .
Details at:
oaksnetwork49@gmail.com
No. of Seats
Center Name
Contact No.
E-mail:
Designation:
Last date of Registration June 17,2013

Workshop Fee
11,500/- only, per participant (including course materials, Lunch, tea, and certificates.
You can make payment on account No 141-20311-714-129220
Account title: OAK SolutionsNetwork

There will be a
Special Group discount

WHO SHOULD ATTEND
Government, semi-government employees, Students,
Engineers, Managers, Auditors, Consultants, Accountants,
Graduates how are seeking for better carrier.

Venue : Capital Lodge – Islamabad

2-Club Road, Islamabad
Pakistan
Date : June 25,26,2013

Contact for registration

Training Coordinator

03155103552