Microsoft Excel Training

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)

 

Course features

 

Comprehensive Course Coverage by Expert trainers

Individual attention by co-trainer

Flexible Schedule

Post Training Support for 90 days

Excellent Course material (Soft Copy)

 

If you are interested then please drop an email with the following details:

 

1. Name:

2. Organization:

3. Designation:

4. Email ID:

5. Contact No:

6. Will you recommend us for a corporate training?

Seeing believing! We are ready to provide a demo in a moment’s notice.

 

We provide corporate it training on advanced excel, advanced powerpoint, excel vba and macros, finance modeling  in New Delhi / NCR, Mumbai, Pune, Kolkata ,Chennai, Bangalore, Hyderabad, Vishakhapatnam & Cochin.