Microsoft Excel Certification with Hands On Training

Microsoft Excel Certification with Hands On Training

 

  • ExcelCert

    Excel Certification Training

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 27

About The Event

 * 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

 

Venue Map