PART 1 - Advanced MS-Excel

Topic-1    Logical Function (If, And, OR), Conditional Sums using single & multiple criteria, Conditional Average , The Trim Function
Topic -2    Flash Fill, Advance Number Formatting, Advance Conditional Formatting, Data Validation with Adv. Application
Topic -3    Sorting & Subtotal, Adv. Filter, Consolidate of Sheets Data, Goal Seek, Formula Auditing, Track Change, Scenario
Topic -4    Quick Analysis, Lookup Functions, Match & Index, Vlookup from Multiple Table, Dynamic Vlookup, SUMPRODUCT Function
Topic -5    Data Table, Data Form, Solver, Depreciation Functions
Topic -6    Financial Function(PMT, PPMT,IPMT, Rate, NPER, PV, FV, NPV, IRR, MIRR)
Topic -7    Create Charts in details with use of all Functions related to Charts, Insert,Edit & Delete Comment, Change Comment Box Shape
Topic -8    PowerPivot, Creating DashBoard, Power View, Power Map, Power Query
Topic -9    Common Error Messages in Excel, Advance uses of Macro, Array Functions, Apps for Office, Other Functions
Topic -10    Introduction to ASAP Utilities
Topic -11    Spell/Write out numbers or amounts, Some useful formulae of ASAP,  Mail Merge through Google Drive
Topic -12     Protect  & Unprotect Sheet, Workbook, Hide Formula, Allow Users to Edit Ranges with password & without password

PART 2 - VBA Programming with Macros

Topic-1    The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects - Workbook Included
Topic -2    Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls
Topic -3    Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors
Topic -4    User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties
Topic -5    UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control
Topic -6    Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, When to apply Validation
Topic -7    Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons
Topic -8    Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime