Training Contents 

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

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.

* 10% Discount for  group of two or more

Duration        =          02 weeks