Corporate Level Training on Advanced Excel with VBA Programming

Visual Basic for Applications, Excel’s powerful built-in programming language, permits you to easily incorporate any functions into a spreadsheet. You can easily calculate or Automate any Function on your worksheet VBA is something omnipresent and esoteric. VBA is now the core macro language for all Microsoft’s office products it spontaneously and universally uses in USA even in India in many industries instead of other hard and complicated programming Language.

Basic Microsoft Excel, MIS – Reporting , Lookup, H- Lookup, V-Lookup, Reverse Lookup, INDEX, Match, Offset, ADDRESS, INDIRECT, Data Analysis, What If Analysis, Advance Sorting, Advance Filter, Array Formula, Nested IF, Advance Chart, Advance Validation, Advance Formula, Conditional Formula, Macro Recording, Pivot Table & Data Analysis, Calendar Creation, Other Tools & Reports


Contents
  1. Introduction
  2. Calculations without VBA
  3. How to Learn VBA
  4. Storing and Retrieving Variables in a Worksheet
  5. Using Excel Functions
  6. Checking for Conditions
  7. Arrays
  8. Iterating
  9. Automation
  10. Reading and Writing Arrays
  11. A Simulation Example



Copyright © 2013 Omni Solutions