Advanced Excel Training

Looking for the Advanced Excel training? Then you are at the right stop. we are the freelancers provide training in advanced excel to corporate and individuals as well.
Have a look over the course contents what we offer:
• 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
• Consolidation of 1000 text files using Shell Command, Worksheet and Workbook consolidation
• Multi-criteria V-Look up and H-lookup and other important Functions
• Functions( Financial, Text, logical, if and nested ifs, etc.)
• Create bar chart and organization chart using excel function and Text Box
• Sorting , Filter and Advanced Filter (Creation a search engine in excel)
• Grouping , Outlining along with Subtotals.
• Creation of Hyperlink(Sheet , work book, email)
• Protection techniques
• 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.
• Track changes
• Working with back stage view and Creation of Own Ribbon Tab
• How to create macro and usage of them. (In Brief)