Command Button | Total | VBA | Day 05
Why take VBA Training?
In Excel few tasks take more of effort and are time consuming, to overcome this we make use of VBA, mainly used for automating the manual tasks.
Brief about topic
In VBA course, you will be learning about how to automate the tasks by calling the related objects, altering their properties. Creating user defined functions, userforms and working with events.
Course Content
Introduction to VBA, Variable and Data types
VBA Logic & Loops
Case Study - Writing an excel macro to extract individual elements from a string
VBA Functions, Variables / Procedure Scope and Lifetime
Case Study - Using msgbox and functions in VBA to generate desired results
Worksheets & Arrays
Importing Data into Excel
Case Study - Writing SQL statements in VBA to manipulate data
GUIs and User Forms
Case Study - Creating user forms to make meaningful filtering of data
Form & Excel Controls
Case Study - Appending and creating new files before using form and ActiveX controls to call macros
Charts and Pivots
Case Study - Creating legends using checkboxes and pivot tables
Building Regression Tool
DevOps:http://www.analystera.com/course/azur...
Certification:http://www.analystera.com/course/azur...
Excel Reporting:http://www.analystera.com/course/exce...
Python Data Science:http://www.analystera.com/course/pyth...
#learning #onlinetraining #elearning #programing #freedemo #analystera #VBA