"VBA is quite a powerful procedural programming language in-built into Microsoft's Office Products since the mid 1990s. Best known for its macros, VBA can do so much more. You can build complete applications using any of MS Office's office products"....

- Overview of the Focus Areas; Scope and Deliverables of the Program; Frontiers of MS Excel and VBA; Setting the Environment; 

Including the following:

IF, Nested IF and their Variants; strings & Concatenation; NPV and IRR; Conditional Formatting; Using range names in formulas; V/H lookup, Match, Index

Data Table / Data Validation and MANY MORE

- Distinguishing functionality; Building Blocks; VBA Architecture

Referencing Types; Creation; Naming & Saving Locations; Understanding Taxonomy and Terminology; - Assigning a Macro to a Button / Quick Access Tool Bar; Getting Clues to VBA Programing; Identifying Roadblock; Knowing the scope of Excel macros

- Excel Objects; Object Properties; Object Methods; - VBA Procedure - Sub / Function / Property; Memory Variables; Programing Techniques; Syntax; 

- Creating a Procedure (Public vs Private); Command Button and Properties; Intermediate Results and Debugging.

- Illustrations

OBJECTS FOCUSED

   -Workbook (Open, Activate, Delete); Worksheets (Select, Insert, Delete, Count, move through, Manipulate); Data Area (Range, Row, Column, Cell - Select, Insert, Delete, Manipulate); Chart (Create, Insert, Select, Activate, Delete)

INPUT FOCUSED

-Input Box; Validation; Storage in Memory Variables; Passing through a VBA Function

PROCESSING FOCUSED

- Looping; iteration; scenarios, conditions; syntax and semantics; 

OUTPUT FOCUSED

-Output Box; Location; alerts, data, charts

Including the following:

- Whether Assets / Liabilities or Debits / Credits match; Automated Financial Performance / Financial Position / Cash Flow Analysis / Automated Budgeting and MIS; Power Pivot / Slicer / Pivot Chart / Snapshots of Key Controls and Parameters

Preparation of Financial / Operational Models including the following:

(a) Frequency Table (b) Forecasting (c) Trendline and Estimation (d) Random Number Generation; Validation including EICP Based Validation; Alerts; Monte Carlo Simulation (Modeling); Scenario Analysis; Integrated Financial Models; Specific Objective based Financial Models (such as Capital Budgeting Model, Valuation Model, Cash Flow Forecasting Models, Sales Forecasting; Break Even Analysis and Cost Analysis Models)    

Including the following (VBA) (Dealing with 1000s of Rows >100000):

Categorization based on Sector / Industry; Changing Worksheet names; Adding and Naming Worksheets; Creation of Links (100s of Scrips >1000); Automatic Definition of ranges based on ISIN; Statistical Measures; Identification of Buy / Sell Points; MACD; Analysis of BenchMarks Vs Actuals; Technical Analysis;

Proprietary Application Development Jewel FinSys | Dr Nala FinSys Consulting, Training and Academia (dr4kfinsys.com); Preparation of Schedules; Inventory Reports; Integrated Operational and Financial Models for Hotel Industry

Variety of VBA Codes (numbering around 20 different types) for reverse practice

You can also view our other services and Publications

Other Services

Jewel FinSys | Dr Nala FinSys Consulting, Training and Academia (dr4kfinsys.com) 

 Bank Audit Management | Dr Nala FinSys Consulting, Training and Academia (dr4kfinsys.com) 

 Automated Budgeting / Financial Modeling in Hotel Industry Financial Modeling | Dr Nala FinSys Consulting, Training and Academia (dr4kfinsys.com) 

 Our Professional Academic Enrichment Programs: Home | Dr4ks (dr4kfinsys.com)  

Click here for Our Publications