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

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
“Exam scheduling to be done through user account” / “Exam once scheduled cannot be cancelled”
Date of Examination
01-Jun-2019
02-Jun-2019
15-Jun-2019
16-Jun-2019
06-Jul-2019
07-Jul-2019
20-Jul-2019
21-Jul-2019
03-Aug-2019
04-Aug-2019
17-Aug-2019
18-Aug-2019
07-Sep-2019
08-Sep-2019
21-Sep-2019
22-Sep-2019
Examination Time
01:00 PM - 02:00 PM
02:30 PM - 03:30 PM
04:00 PM - 05:00 PM
05:30 PM - 06:30 PM
10:00 AM - 11:00 AM
11:30 AM - 12:30 PM

Write a review


Your Name


Your Review Note: HTML is not translated!

Rating Bad           Good

Captcha

Write a review

Note: HTML is not translated!
    Bad           Good


Captcha

Tags: Advanced Excel, Macros, Vba, Excel