Excel VBA Programming

Excel VBA Programming

Module: VBA-101

  • Spreadsheet automation, Steps for automation – user needs, file structure, data structure, Excel version, exception handling, Excel features, performance, level of security, test cases, protecting the workbook

Module: VBA-102

  • Data types, Variables: declaration, definition, scope, local, module, public, static, constants, predefined constants, Strings, Numbers, Dates, Assignment statements, Arrays – declaration, multidimensional arrays, dynamic arrays, Object variables

Module: VBA-103

  • Procedure declaration, scope – public, private
  • Execution – from macro dialogue box, short-cut key, from another procedure, calling procedure in different module
  • Arguments – passing, by reference, by value, error handling techniques

Module: VBA-104

  • Object Model, Working with ranges: copy (contiguous and non-contiguous), move, select or identify, resize, count cells, determine type, looping through, deleting empty rows, duplicating rows, check for range containment, determine cell data type, read and write range, array to range (one and multi-dimensional), sort

Module: VBA-105

  • Manage duplicate records, Remove format, undesirable characters, extra space, Select and treat all blank cells, Convert numbers stored as text into numbers, Remove duplicates, Highlight errors, Locate out of range values, Parse data – text to column

Module: VBA-106

  • Lists and tables, Sorting, Filtering, Conditional formatting, Working with pivot tables, Working with charts
  • VLOOKUP, HLOOKUP

Leave your comment; I love them!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s