Microsoft Excel Advance Training

Microsoft Excel Advanced training aims to provide skills and knowledge from Microsoft Excel software which will allow the participant to increase the efficiency and also simplify your daily task.

In this training the participants will learn extensive knowledge on how to create lookup functions, set Microsoft Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking and Solver, and macros.

Training Content

Module 1. Using Conditional and Custom Formats-Custom formula in Conditional Formatting

Module 2. Using Templates

Module 3. Working with Databases-Maintain and create Database

Module 4. Working with Advanced Filters

Module 5. Revising and enhance Charting Features

Module 6. Creating/Revising PivotTables and maximizing powerpivot

Module 7. Using Auditing Tools and Range Names

Module 8. Exporting and Importing Data from another file

Module 9. Using Advanced Functions

Module 10. Using Scenarios

Module 11. Using Worksheet Protection

Module 12. Tracking and Merging Workbooks

Module 13. Recording Macros

Module 14. Comments

Microsoft Excel Training Preview

Conditional Formatting


Graph & Advance Chart


Upcoming Events

Training Packages

Quick Enquiry

Februari, 2017

No Events

In-House Training

Training at your place
  • Fees according to the number of days
  • Maximum 40 pax
  • Training Kit and material will be provided
  • Manual Booklet provided
  • Technical assistance after training end
1 Step 1
Namefull name
0 /
No of participants