Master Advance Excel Formulas and 10X your Excel Speed. Want to calculate your KPI’s based on changing criteria and conditions we will teach you how to do it and learn the art of structuring your unstructured data by using text based formulas and many more to learn.
What If Analysis
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
- If Function
- How to Fix Errors – if error
- Nested If
- Complex if and or functions
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Dropdown List Creation using Data Validation – Dependency List
- Vlookup / HLookup
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nested VLookup
- Reverse Lookup using Choose Function
- Worksheet linking using Indirect
- Vlookup with Helper Column
- Creating Simple Pivot Tables
- Basic and Advanced Value Field Setting
- Classic Pivot table
- Choosing Field
- Filtering PivotTables
- Modifying PivotTable Data
- Grouping based on numbers and Dates
- Calculated Field & Calculated Items
- Arrays Functions
- What are the Array Formulas, Use of the Array Formulas?
- Basic Examples of Arrays (Using ctrl+shift+enter).
- Array with if, len and mid functions formulas.
- Array with Lookup functions.
- Advanced Use of formulas with Array.
Charts and slicers
- Various Charts i.e. Bar Charts / Pie Charts / Line Charts
- Using SLICERS, Filter data with Slicers
- Manage Primary and Secondary Axis
- Dr. K. Pradeep Reddy
Course Fees -
- 06/06/22 to 17/06/22
- Monday to Friday
- Week 2
1. For the candidates who are registering for the first time: Register yourself by the ensuing form.
2. For the candidates who are already registered: Sign in by the already registered information by the ensuing form.
3. Your registered e-mail ID is your USERNAME whereas; Your registered mobile number is your PASSWORD.
4. Apply for any course of your choice by selecting from dashboard, make online payment from the Pay Now button and you are through.
5. You will receive a confirmation mail on your registered email ID.