Microsoft Training

Excel VBA Macro

(0 review)
Free
excel_vba

ADVANCED EXCEL WITH VBA MACRO TRAINING

 

Overview

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.

 

VBA stands for Visual Basic for Applications an event driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS-Excel, MS-Word and MS-Access.

 

Pre-Requisties:

 

The delegates must have a good knowledge of Excel.

Duration:   30 to 40 Hours

 

Advanced Excel with VBA Course Content:

Basic & Advanced Excel:

Creating Basic Excel worksheet

  • Creating a basic excel sheet and entering data in it
  • Work with cells
  • Formatting data or table
  • Formatting Excel worksheet
  • Search data in excel sheet manually or by filter
  • Sorting and custom sorting data
  • Removing duplicates
  • Alignment of data
  • Merging the cells
  • Boarders
  • Formatting worksheet tabs
  • Conditional formatting
  • Apply Number formatting
  • Hide/Unhide Sheets
  • Protect sheets
  • Lock cells
  • Data Validation
  • Insert Pitures
  • Insert shapes
  • Hyperlinks
  • Add Comments
  • Excel Short cuts
  • Create basic formulas(Sum,min,max,len,left,right,concatenate)
  • Copy formulas and functions
  • Advanced formulas/Function
    • Lookup, Vlookup, Hlookup
    • Today(),now()
    • Index ,match
    • Left,right,mid,find,mid
    • Concatenate
    • Logical functions(And,Or,Not)
    • If function
    • Iserror,ifna,iferror
    • Count if, Count ifs, Sumif, Sumifs, CountA,Sub total
    • Sum product

Dashboards

  • Inserting pivot tables
  • Inserting pivot charts
  • Inserting charts
  • Inserting slicers
  • Creating dashboards with interlinking
  • Grouping the charts

Excel VBA Course Content

  • Introduction to VBA
  • Recording macro and giving short cut name
  • Running the macros
  • Editing macro in Visual Basic editor
  • Understanding the development environment
  • Closing the visual basic editor
  • Macro security& password protection

Working with Procedures and functions

  • Modules
  • Creating a standard module
  • Understanding procedures
  • Creating a sub procedure
  • Calling procedures
  • Using the immediate window to calling the procedures
  • Creating a functions
  • Naming procedures
  • Working with the code editor

Understanding Objects

  • About objects
  • Excel object hierarchy
  • Understanding collections
  • Using the object browser
  • Working with properties
  • Working with methods
  • Creating an events

Using expressions, variables, functions

  • Declaring variables
  • Understanding data types
  • Working with variable scope
  • Using the if conditions
  • For loop through columns, rows
  • Do loop, do until
  • Select case… end
  • Project

Userforms

  • Understanding userform buttons
  • Creating sample form
  • Userform project

Working with PivotTable Object

  • Understanding pivot tables
  • Creating a PivotTable using worksheet data
  • Working with a pivot table objects

Debugging Code

  • Understanding errors
  • Setting Breakpoints
  • Stepping through code

Error Handlings

  • Types of errors
  • On error Goto 0
  • On error Resume Next
  • On error Goto [label]

 

Course Features

  • Students 0 student
  • Max Students1000
  • Duration10 week
  • Skill levelall
  • LanguageEnglish
  • Re-take courseN/A
Curriculum is empty

Instructor

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Related Courses