Advanced Excel Training

Mastering advanced formulae’s like

1. 1. Look up functions,
   2. IF conditions and nested IF’s,
   3. Date and Time Functions,
   4. SUMIF and COUNTIF,
   5. Text functions,
   6. Creating references,
   7. INDEX,
   8. MATCH,
   9. ADDRESS,
   10. OFFSET, etc.

Mastering lookup functions

1. 1. Nested IF’s conditions
   2. Creating cell references
   3. Create complex nested formulae’s
   4. Advanced Date Functions
   5. Statistical Functions
   6. OFFSET
   7. INDEX
   8. ADDRESS
   9. SUMIF S
   10. MATCH, etc

Hands on exercises for applicability of complex formulae’s

Creating Dynamic excel workbooks:

1. Working on humungous data sets and Creating robust data and making it user friendly
2. Creating Dynamic dropdowns and linking data basis different criteria’s

Mastering Pivot Tables:

1. Creating complex Pivot tables
2. Creating summaries in Pivots
3. Adding and Removing Subtotals
4. Using Slicers in Pivot Table
5. Creating graphical representations through pivots
6. Inserting formulae’s in Pivots
7. Customizing pivot data
8. Using advanced filters
9. Managing rows and columns to achieve required results
10. Creating reports out of pivot tables
11. Introduction to Power Pivots

Participants to work on multiple examples to master creating complex reporting solutions through pivot tables.

Forecasting data and graphs

Expertise in graphical representation through Charts

1. 1. Summarizing data visually through charts like pie charts, bar graphs, line charts,area charts and many more
   2. Mastering the art of depicting information graphically by working on multiple 2D and 3D charts.
   3. Creating combination charts and customized version of different charts to show the information as per the problem statement
   4. Developing 3 dimensional charts with practical examples
   5. Use of waterfall charts for professionals
   6. Uses and applicability of Bubble charts
   7. Use of combination charts
   8. Plotting and Highlighting geographical presence
   9. Analysing different business solutions diagrammatically and mastering the art of creating charts
      

Learning about Macros for efficient effectiveness and automating the regular reporting of KPIs

1. What is VBA
2. Uses and applicability of Macros
3. Identifying power of Excel
4. Recording and Testing of Macros
5. Mastering the developer tab
6. Relative and Absolute Recording
7. Running and deleting macros
8. Examining the MACRO codes
9. Altering and Modifying macros
10. Creating your own macros