Advanced Excel & IT Skills

Microsoft Excel and the Office Package is heavily used at almost all workplaces. However the knowledge and skill level among the users are at a very low level. By equipping the employees with these skills, we ensure a productivity growth of at least 40%!

Advanced Excel Training Program

Participants of “Advanced Excel Training” program will gain a thorough understanding on advanced data handling techniques and also be able to; effectively use logical statements for faster decision making, make effective presentations and reporting using Pivot Tables.

  • Managing workbooks with Sorting, Filtering & Organizing Data
  • Using Conditional & Logic Functions for Decision Making, Data Management & Representation
  • Referencing & Lookup for Data Management and Handling (VLOOKUP, HLOOKUP, MATCH, INDEX etc.)
  • Data Validation
  • Conditional Formatting
  • Pivot Tables & Pivot Charts
  • Text Functions
  • Date and time functions
  • Report Preparation

Training on Automating Work with Microsoft Excel Macro

This is a project based training implemented on a weekly model in order to guide and coach through the knowledge acquisition as well as problem solving within the work environment. This will include skill development sessions, project identification, project implementation, coaching, feedback and evaluation.
The objective is not only to equip with skills but also to implant the attitude to continuously think about possible improvements using Excel tools in order to increase the productivity at work.

Contact Us to Get a Customized Quotation

    Open chat
    Contact us on Whatsapp
    Hi, Welcome to Cognito Asia Training & Development!

    Please let us know your requirement.

    One of our experienced consultants will contact you shortly.