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:-
- Marketing and sale professionals
- 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
- 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
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