Power Excel Using  for Office  Automation 2010/13/16 version

As the industry standard for spreadsheet software, Microsoft Excel comes with many advantages to the new user. This awesome Advance Excel 2010/2013/2016 for Users of MS Excel deals with the tools, techniques and functions of Excel 2010. This course will introduce you to different powerful tools of excel 2010/2013/2016.

The “Advance Excel 2010/2013/2016  ZERO to HERO in just 1 day“ course content is developed based on feedback from students and professionals with a blend of our 21 years of experience in providing excel training . Being a Certified Microsoft Office Specialist We can Provide Ultimate Advance Learning.

 

This program is suitable for the following:-

  • Housewives
  • Entrepreneurs
  • Marketing and sale professionals
  • Students
  • Consultants
  • Accountants and finance & Insurance People
  • Non-finance professionals and anyone looking to learn excel 2010/2013/2016.
  • HR consultant and HR Management
  • MBA Students

The objective of the course is to increase the productivity and efficiency by introducing participants to numerous tools and techniques available in Excel.

 

This Advance Excel 2010/2013/2016 course is hands on practical course. While instructing, the Certified trainer actually performs the operations over an excel sheet for a better learning. Completion of this course, a participant will be capable of working on an excel sheet using different tools and techniques.

In this course, you will learn the following:

 

What You will Learn

  • Making Master Business Contacts / Clients  Database – Maintenance – Filtering Sorting – Security
  • Account Day book in excel

Formula for Daily office Uses :

  • Dynamic Percentage Formula

            Functions :

  • Sum , Auto sum , Bifurcated Sum,  Sum if , Sum Ifs,  Average , Average If , Average Ifs, count , countif, Maximum, Minimum , Conditional Formula Calculation Use of IF , Audit Tools for Formula , lookup , vlookup , Index , Search , Forecast and Forecast Analysis with Graph

Text()

Database Management :

  • Custom List, Purify Data, Data Validation Use of Upper, Proper, Lower, Concatenate
  • Sort , Filter , Sub total , Pivot Table , Pivot Chart , Duplicate Data removing
  • Manipulation of Data sheet Like

        Add Sheet , Delete Sheet , Protect Sheet , Link data , Consolidation

        Link Multiple sheets, Link Multiple Books

  • Cutting , Copy , Paste Data, Paste Special, Go To special
  • Insert / Delete Row , Cell , Colum
  • Hide/ Unhide   Row/Colum /Sheet
  • Password Protection for Security
  • Time Saving Short Cuts