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)