Advanced Excel Training


We have conducted 200 plus corporate training and trained more than 5000 working professionals on Advanced Excel, Professional PowerPoint, MS Excel VBA and Macro, MS-Project, MS-Access Financial Modeling with Excel in Chennai, Bengaluru, Pune, Mumbai, Kolkata, Hyderabad, Cochin,Trivendrum,New Delhi, Nagpur, Raipur and Bhubaneswar.

We have also delivered In-house Training to MNCs and few Fortune 500 Companies.


Table of Contents

  • Advanced Ribbon Feature of Excel.
  • Capabilities of Pivot Table and Pivot Chart.
  • Charts and Graphs Including Smart Art Features.
  • Creation of Custom and Dynamic List.
  • Condition based formatting , Finding and removing duplicate values.
  • Prevention of data Errors and User defined Restrictions.
  • Worksheet Consolidation using Shell Command.
  • Multi-criteria V-Look up and H-Look up and other important Functions.
  • Functions (Financial, Text, logical, if and nested ifs, etc.)
  • Create bar chart and organization chart using function and Text Box.
  • Sorting , Filter and Advanced Filter (Creation of a search engine).
  • Grouping , Outlining along with Subtotals.
  • Creation of Hyperlink (Sheet , work book, email).
  • Protection techniques with multi levels.
  • To work with Multiple workbooks in a single Window.
  • Extensive Keyboard Shortcuts.
  • Hidden Features and Functions in Excel.
  • Print techniques and management.
  • Importing and exporting data from and to various file formats.
  • Workbook sharing and merging various to a single work book.
  • Working with back stage view and Creation of Own Ribbon Tab.
  • ExTreme Tips and Tricks.
  • How to create macro and usage of them. (In Brief)

We also Provide Domain Specific MS Excel training suitable to the budget and flexibility of the corporate.