Course Synopsis:
VBA stands for Visual Basic For Applications. It’s a software programming language to automate and customise repetitive and complex Data Analysis and Visualisation tasks in Microsoft Excel and other office applications. It’s a blessing for whose who need to manage their business data in Excel and need to frequently edit, format, perform calculations using formulas & functions, analyse & summarise Excel database by generating Pivot Table and chart reports. VBA helps to automate all these tasks quickly and with consistency. Thus it helps to increase efficiency and productivity in managing excel spreadsheet data. It also helps to create custom forms and dialog boxes to provide interface to interact with user.
SSDN Innovations provide all its Courses in an interactive and fun way with lots of Hands on practice.
Course Pre-requisite:
Basic knowledge of Microsoft Excel is preferred.
Educational Background:
O or N level (and its equivalent)
Course Duration:
21 Hours (Three days)
Course Contents:
Excel Macros and VBA Connection
Working with Object
Variables and Intrinsic Functions
Decision Making and Loops
Working with User Forms
Creating Pivot Table Report using VBA Code
Code Debugging
Error Handling