Microsoft Excel
- MS Excel – An Introduction
VBA – an Introduction
- What are VBA Macros
- Need of VBA Macros
- Benefit & Limitations of VBA Macro
- Display of Developers Tab & VB Editor
- Macro Recordings
- Introduction to the Writing of Basic VBA codes
- Working in the Visual Basic Editor
- Saving Off Your Macro
VBA Macro Programming
- Use of Decision Making Statements in Macro by using: If & Else Conditions, And /OR Conditions, Select-Case & Not Statements
- Working with Loops & Range Objects: Introduction of Programming Concepts to write Excel Formulas in Programs
Types of Errors & How to Debug Errors VBA Macro Programming: Form Vs. Active X Controls & Advanced User Forms
- Data Analysis
- Charts from Multiple Data Sheets
- Dashboard Reporting
- MIS Reporting