VBA Macros : BIBA Module

4 out of 5
4
6 reviews

Visual Basic is a computer programming language that allows for the creation of user-defined functions and the automation of specific computer processes and calculations. In VBA, users type commands into an editing module to create a macro. Macros allow users to automatically generate customized charts, reports and perform other data processing functions. Macros automate tasks and merge program functions that enable developers to build custom solutions using Visual Basic. In the finance industry, VBA for Excel is frequently used to create and maintain complex financial spreadsheet models.

The program can be used to keep lists of customers’ names or other data, create invoices and forms, develop charts, analyze scientific data, and for budgeting and forecasting. It can also control several features of a host application such as Excel, including manipulating user interface features, such as toolbars and menus and working with dialog boxes or customized user forms.

Main Features

  • Master the Cells and Range objects in multiple scenarios
  • Breeze through IF THEN statements and conquer all the Logical Operators
  • Record, Modify or Write Macros from scratch
  • Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons
  • Construct the right Loop for each task
  • Make Custom Formulas/Functions on the fly
  • Batch out inter-active MessageBoxes, InputBoxes and give users choices
  • Manipulate Userforms for data entry, report generation, editing tables/databases
  • Restrict the flow of data or make the Userform(s) responsive, calculating, intuitive

Introduction to Microsoft Excel

1
Introduction to Excel
2
Conditional Formatting
3
Data Validation
4
Removing Duplicates, Getting unique values and Advanced Filter options
5
System defined Text Functions
6
System defined Numeric Functions
7
VLOOKUP, HLOOKUP, ADVANCED VLOOKUP
8
Concept of Pivot Table
9
Concept of dashboard

Introduction to VBA

1
Excel VBA programming environment
2
Project window, properties window and code window
3
Concept of Sub Routines
4
Types of Errors
5
Excel Macro Recording facility
6
Modifying the existing Macro in VB editor window
7
Understanding the Macro Security and saving a workbook with Macro contents
8
Adding new module, removing module, Importing and Exporting objects

Concept of Variables

1
Object as an element in programming
2
Examples of objects
3
Collection of objects
4
Object properties
5
Methods related to objects
6
Worksheet Object
7
Range Object
8
Row Object
9
Column Object
10
Cell Object
11
Structure of a function
12
Uses of writing a function
13
Difference between a macro and a function

Application on MIS data management using VBA Macro

1
Creating list of unique values
2
Automating the filtering process for each unique value
3
Copy the filtered data to individual separate sheets in a workbook
4
Copy each sheets to separate workbooks
5
Saving each workbook in a local directory

Application Creation of UserForm and applying VBA Macros

1
Working with user forms
2
Using active X controls like, text box, combo box, check box, command buttons
3
Checks in application
4
Creating Excel Database
5
Use of Offset Property
6
Using Active X controls on the worksheet
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 34 students
Duration: 20 hours
Lectures: 41
Video: 9 hours
Level: Advanced

Archive

Working hours

Monday 9:30 am - 7.00 pm
Tuesday 9:30 am - 7.00 pm
Wednesday 9:30 am - 7.00 pm
Thursday Closed
Friday 9:30 am - 7.00 pm
Saturday 9:30 am - 7.00 pm
Sunday 9:30 am - 7.00 pm
WhatsApp chat