Microsoft Excel Certification with Hands On Training

 * 135000 Jobs listed on Indeed.com when searching for “Microsoft Office.” It’s one of the most demanded skills.

* 90% of the hiring managers consider certification as part of their hiring criteria.

*89% of supervisors say that certified employees are more proficient users of Microsoft Office Programs.

Become certified in excel as a specialist today. This event offers 2 days of crash course on excel along with the certification. Learn the ins and outs of excel and be a specialist in handling and analysing data. Take Microsoft Certification from our premises. We are a Certiport authorised testing center handling Microsoft Certifications.

In this 2 days of power packed excel training you will learn from the basics like copy-paste to the more advanced features in excel like the vlookups, sumifs, dashboards...

About the Trainer:

Arsalan has over 10 years of experience in corporate training and has taught over 1000 students till now. He is an expert in teaching vba macros, excel and Ms-Access. He also has experience in completing automation projects for various companies. Also has exposure in various MNCs he has all the skills to answer all your queries in real time.

Contents:

• Working  with Excel Filter and Sort
• Data Analysis using Pivot Tables
• Using Formulas Sum-IF, Count-IF, Sum-IFS, Sum-Product, MultipleIF
• Using Vlookup, Hlookup, Indirect and Match
• Validating and Securing data with validaiton and protection of cells.
• Analyzing data with subtotals, goal seek and scenario manager.
• Working with and Editing Excel Ribbon and Quick Access Toolbar.
• Creating and Organizing workbooks by inserting,deleting, renaming....
• Working with excel templates, creating dynamic lists, autofill, tables..
• Exploring Formatting options to create stunning reports and dashboards.
• Understanding the basics of Formulas and writing simple functions.
• Creating sample reports  with basic formulas and formatting options.
• Creating and customizing various types of Charts.
• Defining Names and creating dynamic charts and formulas