Advanced Excel Training

Advance Excel VBA Training Overview

• Overview of Analytics - Whats is Data Analytics, Data Modeling and Data Mining
• Overview of excel basics, worksheet optimization, and data cleaning in excel
• How to make your report effective (Data visualization) using Custom and Conditional formatting
• Aggregate functions (Sum, 3-D functions, average, count, countifs, sumifs etc)
• Date and time functions( EOMonth, DateDiff, NetworkDays, Workdays, Weeknum, Today, Month, Year etc)
• Summarize data using Pivot table and charts
• Data cleaning and validations in Excel
• Basic and Advanced Filters on various scenarios

• Lookups - VLookup, Reverse Lookup, Index Match, Indirect and dependency list
• Logical Functions - Super logical If, nested if, and, or functions, how to combine logical functions
• Various Text Functions - How to use find, substitute, len, trim,exact, left, right, mid, Upper and Lower functions
• What if Analysis (Goal Seek, Data Tables, EMI Calculation, Solver Tool)
• Dashboard Designing in Excel
• Arrays Functions (CSE Functions in Excel)
• Data Validations tools
• Data forecasting tools
• VBA Macros - (How to record macros, UDF, Variable, control flow, etc)
• VBA Macros - If else Statements
• VBA Macros - With statements
• VBA Macros - For, Foreach and Do until Loop
• VBA Macros - Fiters and Reporting
• VBA Macros - How to automate mail functions in VBA
• VBA Macros - How to create mergers