Course Contents for Corporate Interventions
Advance Excel-Two Working Days
Introduction and Basic Brush-up of MS Excel:
- Introduction of Excel shortcut keys: Chart will be provided by Advanced Excel.
- Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
- Introduction to the Paste Special all Option. (Formulas, Values, Formats, Comments, Validation, All using source themes, All except Borders, Column Widths, Formula and Number formats, Values and Number Formats, None, Add, Subtract, Multiply, Divide, Skip Blanks and Transpose)
Start-up WithFormulas: Part-I AND Working With Name Ranges:
- Text Functions: Concatenate, Left, Mid, Right, Lower, Upper, Proper, Replace, Find, Search, Substitute.
- Logical Functions:If, Nested If (For Multiple Conditions), OR, And, Not, True, False.
- Introduction to Name Manager:Discussion on Name Ranges and Apply the Name Ranges on Cell and the combination of Cells.
- Use of Name Manager: Creating, Editing, and Deleting of Names.
- Create Name Ranges Automatically.
Start-up With Formulas: Part-II And Use of Tool Find &Select, (Go To Special):
- Math & Trig Functions: Sumif, Sumifs, Sumproduct, Use of Sumproduct as lookup and in various activities.
- Statistical Functions:Average, AverageA, Averageif, Averageifs, Count, CountA, Countblack, Countif, Countifs, MAX, MAXA, MIN, MINA, Small, Large.
- Use of Tool Find & Select: Discussion on Excel’s very important tool “Find & Select” (Go To Special) including all options: (Comments, Constants, Formulas, Blanks, Current region, Current array, Objects, Row differences, Column differences, Precedents, Dependents, Last cell, Visible cells only, Conditional formats, Data validation).
Start-up With Formulas: Part-III: Lookup Functions:
- Lookup Functions: Discussion on Lookup Functions, Use of Lookup, Vlookup, Hlookup, Index, Indirect Match, Offset.
- Vlookup with Match, Vlookup with offset, Vlookup with Indirect, Hlookup with Match, Hlookup with offset, Hlookup with Indirect. Vlookup with If condition.
- Vlookup and Hlookup with Name Manager. Detail Discussion on use Of Name Manager InVlookup and Hlookup functions.
Structuring Of The Data & What If Analysis:
- Use of Advance Filter to fulfil the multiple desired conditions.
- Import the data from the multiple applications to Excel.
- Use of Text to Columns for Rearrangement of Data.
- Remove Duplicates from Data.
- Use of Data Validation and Consolidation.
- Data of Grouping, Ungrouping and Subtotal.
- What if Analysis: Detailed Discussion On What if Analysis. Analysis of Data by using Scenario Manager and Data Table and Goad Seek.
Working With Charts:
- Working With Charts:Detailed discussion on graphically presentation of Data by using Charts.
- Presentation with different kind to charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts
- Preparation of Gnatt Chart, Bubble Chart, Speedo Meter Chart.
- How To Use Switches to Offset function effectively in Charts.
- Working with 2axis and 3axis charts.
Pivot Table and Pivot Charts with Slicer:
- Start With Pivot Table, Do the Multiple Field Setting in Pivot Table.
- Do the Juggling of Data in Pivot Table and Work on layout of Pivot Table.
- Creating Groups, Insert additional Calculated Field in Pivot Table.
- Perform the % calculation on the basis of multiple fields.
- Start-up with Pivot charts.
- Insert slicer in Pivot Table and Pivot charts.
Tags: Advanced Excel and VBA macros institute in Gurgaon, Excel Macros Corporate Training in Gurgaon, Advance Excel Institute In Gurgaon, Advance Excel classes In Gurgaon, VBA Macros Institute in Gurgaon, VBA Macros Classes in Gurgaon, Advanced Excel and VBA macros institute in Delhi, Advance Excel Institute In Delhi, Advance Excel classes In Delhi, VBA Macros Institute in Delhi, VBA Macros Classes in Delhi, Excel Macros Corporate Training in Delhi, Advance Excel training In Delhi, Advance Excel training In Gurgaon, Excel training In Delhi, Advance Excel training In Gurgaon, Macros training In Delhi, Macros training In Gurgaon, VBA Macros training In Delhi,VBA Macros training In Gurgaon