Advance Excels

Table of Content

Module-I

Extend Your Insight Office Excel

Benefits of office open XML

Finding Formulas

The Choose Function

Column Chart

Pivot Tables

VLookup Function

Excel Scenario Manager

Formulas

Conditional Functions

The Functions IF & OR

Percentage Formulas

Assignments

Module-II

Building macrosin Excel

Visual Basic Editor (VBE) in Excel

Creating Macro

Practice a Simple VBA Program

Programming Structure in Excel VBA

The Concept of Variables

Numeric data types

Message Boxes (MsgBox) in VBA for Excel

Creating & Managing Array Declaring

Manage Dynamic Array

Create Multi-Dimensional Array

Loop Structures

Font & Background Color

Excel VBA Procedures – Functions

Examples

Objects & Collections

Project Assignment

Excel VBA Controls’ Properties and VBA Code

Advance Excel

Creating and Using Form

Tab order

Managing Controls

List Boxes

Combo Boxes

Option Button, Check Boxes and Frames

Image Control

Event Handling

Debugging and Dealing with Errors

VBA Macros Security and Protection in Excel

Formatting Controls

Project Assignments

Table of Content

Module-I

Extend Your Insight Office Excel

Benefits of office open XML

Finding Formulas

The Choose Function

Column Chart

Pivot Tables

VLookup Function

Excel Scenario Manager

Formulas

Conditional Functions

The Functions IF & OR

Percentage Formulas

Assignments

Module-II

Building macrosin Excel

Visual Basic Editor (VBE) in Excel

Creating Macro

Practice a Simple VBA Program

Programming Structure in Excel VBA

The Concept of Variables

Numeric data types

Message Boxes (MsgBox) in VBA for Excel

Creating & Managing Array Declaring

Manage Dynamic Array

Create Multi-Dimensional Array

Loop Structures

Font & Background Color

Excel VBA Procedures – Functions

Examples

Objects & Collections

Project Assignment

Excel VBA Controls’ Properties and VBA Code

Advance Excel

Creating and Using Form

Tab order

Managing Controls

List Boxes

Combo Boxes

Option Button, Check Boxes and Frames

Image Control

Event Handling

Debugging and Dealing with Errors

VBA Macros Security and Protection in Excel

Formatting Controls

Project Assignments