Certified Advanced Excel, Macros and VBA Professional

How It Works

  1. 1. Select Certification & Register
  2. 2. Receive Online e-Learning Access (LMS)
  3. 3. Take exam online anywhere, anytime
  4. 4. Get certified & Increase Employability

Test Details

  • Duration: 60 minutes
  • No. of questions: 50
  • Maximum marks: 50, Passing marks: 25 (50%).
  • There is NO negative marking in this module.
  • Online exam.

Benefits of Certification


$49.00 /-
Download Brochure

Excel is the de-facto software used for data collection, analysis and reporting across organizations. It has wide spread usage due to programmatic and automation features like Macros and VBA.

Vskills certification on Advanced Excel, Macros and VBA focuses on developing and certifying your skills in Microsoft Excel, VBA and Macros. The certification helps professionals to not only increase their understanding of advanced concepts of Excel but also on Macros and VBA.

Why should I take Advanced Excel, Macros and VBA certification?

This Course is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression. The certification helps build your CV and acts as an additional qualification that significantly improves your chances of getting the desired role.

Study & Learn

  • Excel Basics
  • Advanced Excel
  • Macros
  • VBA

Who will benefit from taking this certification?

The certification benefits managers, supervisors, executives and those responsible for using Excel for data collection, analysis and reporting activities and looking for a better role by proving their employers the value of their skills through this certification. It also benefits students wanting to improve their skill set and make their CV stronger.

Advanced Excel, Macros and VBA Table of Contents

https://www.vskills.in/certification/advanced-excel-macros-and-vba-table-of-contents

Advanced Excel, Macros and VBA Practice Questions

https://www.vskills.in/practice/excel-macros-and-vba

Advanced Excel, Macros and VBA Interview Questions

https://www.vskills.in/interview-questions/management-interview-questions/advanced-excel-macros-and-vba-interview-questions

Companies that hire Excel, Macros and VBA Professional

Vskills Advanced Excel, Macros and VBA Professionals will find job opportunities in top tier companies like Capgemini, JPMorgan, IBM, HCL, TCS, Tech Mahindra, Wipro, Zensar, Accenture, GlobalLogic etc.

Excel, Macros and VBA Blogs

Checkout the latest online blogs on Excel, Macros and VBA.

Excel, Macros and VBA Jobs

Checkout the various job openings for Excel, Macros and VBA Professionals, click here..

Excel, Macros and VBA Internships

Vskills runs its flagship internship programme where bright interns work with academic council, click to know more details..

Apply for  Advanced Excel, Macros and VBA Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.

Please click buy now to proceed for online payments.

  • Visa Card
  • Master Card
  • American Express

TABLE OF CONTENT


MS-Excel Basics

  • Workbook and Worksheet
  • Manipulating Data
  • Worksheet Formatting
  • Page Properties and Printing
  • Excel Formulas
  • Sort and Filter
  • Charts

Advanced Excel

  • Excel Cell Referencing
  • Excel Functions
  • Excel Formulas
  • Working with Ranges
  • The VLOOKUP function
  • Pivot Table
  • Advanced Excel Filter

VBA

  • VBA Basics
  • Variables, Comments, Constants and Data Types
  • Visual Basic Arrays
  • VBA Conditional Statements
  • VBA Loops
  • VBA objects
  • Subroutines
  • Functions
  • Labels and the On Error statement
  • VBA and Excel functions
  • Excel Objects
  • Excel Events

Macros

  • Recording a Macro
  • Perform the Macro
  • Running a Macro
  • Change macro security settings
  • Copy a macro module to another workbook
  • Copying a module from one workbook to another
  • Assign a macro to a Form or a Control button
  • Macro Virus Protection

Write a review

Please login or register to review

 For Support