All exams are online now due to COVID related precautions read more

Advanced Excel, Macros and VBA Table of Contents

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 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


  • 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

Apply for certification

 For Support