Advanced Excel Training

Listing ID #3762624

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)