Course Outline as per Industry Standard

Advance Excel 

• Introduction to Advance Excel & Overview of Basic concept
• Writing conditional expressions (Using IF) & logical functions (AND, OR, NOT)
• Using Lookup & reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• Using advance functions & Lookups (ROW, COLUMN, TRANSPOSE, INDIRECT, CHOOSE, OFFSET),
• Array, Datedif
• Formatting, Customizing, Create & Editing scenarios
• Using advanced options of Pivot Tables, Power Pivot & Charts
• Formula Debugging Concept
• Discovering Excel reference Operators
• Validations, Sorting, Filtering, Group, Ungroup, Subtotals & Consolidates options
• Creating MIS Reports, Dashboards, Data visualization, Data Modeling, Analysis Models & Concepts
• Working & Designing the Structure of Temples
• Date, Time, Text & Database functions
• Creating, Editing define Name Range using Name Manger options and Automations
• Discovering Dynamic Range & reference  
• Protection features for Workbook, Worksheets & Cells
• Use full Shortcuts & Master Keys in Excel
• Use advance charts & Graphs (Bar Chart, Pie, Line, Column, Scatter, Rader, Bullet charts Gantt Charts)
• Handling data errors (IFERROR, ISERROR, ISNA, NA)
• Basic Concept of Macros & Recording Macros

Develop your Excel Skills in Corporate Level.
Add more powerful features & options of Excel to manage worksheet related tasks more efficiently and make more sophistication and automation.

Excel VBA Macros

• Overview & Introduction of VBA Macros
• Recordings Macro
• Working with VBA Editor Window
• Understand the excel object model & VBA concepts
• Working with Functions
• Working with Charts & Dynamic Charts
• Use a range of Common Programming Techniques
• Create procedures in VBA & Use of variables
• VBA Syntax and Semantics
• Sorting and Filter, PivotTables and Pivot charts with VBA Macros
• File Handling
• Working with Array
• Write a variety of error handling routines
• IF (ElseIf, Else), Select Case, For Next Loop,  For Each Loop, Do Until Loop and Do While Loop
• With, End With Nesting Code
• Customizing tasks and keep control on it
• About VBA Forms, Sub Procedures & Modules
• Creating Forms Using Controls and their Properties
• Command buttons, List and Combo boxes, Labels, Option buttons, Check boxes, Text boxes & Frames
• Running VBA Forms in Excel
• Communicating with Outlook, Mail & Different Applications using Excel VBA

Experienced Excel users looking to automate many repetitive tasks that are part of spreadsheet development by applying Visual Basic Applications, VBA (programming language). Students must complete Advance Excel on 2010 & 2013 prior to attending VBA 2013 (Excel Macros)

Course useful to :

• Investment Banking Analyst
• Business Intelligence Analyst
• Management Consultants
• Finance/Accounts/Taxation
• HR Professionals
• Marketing
• Back office staff
• Graduate Students