Microsoft Visual Basic Excel Fundamentals

Microsoft Visual Basic Excel Fundamentals

Module 1: Getting Started

• Introduction

• Enable the Developer Tab

• Macro Security

• Macro Recorder Intro

Module 2: Recording Excel Commands using Macro

• Record Excel Subtotal Function to automate criteria-based reports

• Create Dynamic Filters Using Advanced Filter with Macro

Module 3: The Visual Basic Editor

• Introducing VBA Interface

• Introducing Macro related objects

• Creating Simple Commands

• Running Basic VBA Codes

Module 4: Defining Code and Data Structure

• Declaring Variables and Data Types

• Arithmetic and Logical operators

• Defining Visual Basic Operators

Module 5: Programming Basic and Best Practices

• Sequential Programming (Top to Bottom coding)

• Selection Programming (Create Decision)

• Iteration Programming (Create Loop)

Module 6: Creating Excel Based formulas in VBA Interface

• Cell Reference and Name Manager in VBA Interface

• Displaying output of VBA Excel Code to Spreadsheet

• Using CountIf, SumIf , AverageIf in VBA Interface

• Using CountIfs, SumIfs , AverageIfs in VBA Interface

• Creating Vlookup Function

Module 7: The UserForm Interface

• Define and aaply objects in Excel VBA Userforms

• Create basic codes inside VBA Objects

• Create automated reports with VBA Userforms

Module 8: Generate Reports and Data Security

• Creating Data Validation in VBA Objects

• Applying Protect Sheet in VBA Code

• Adding Password to Excel VBA Code