Excel VBA Macros is a programming language that enables you to control just about everything in Excel. You all learn how to create Macros that can be run from things like a button on a spreadsheet. Just like our Excel course, these lessons have lots of examples, and we have simplified them as much as possible so that it's easy to learn Excel VBA Macros. Using Excel Excel VBA Macros will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel Macros.
1: Introduction
Different File extensions
All Keyboard shortcuts
Data types and properties
Create, delete and update new templates
2: Basics of Advanced Excel additional Formatting
Define Name
Paste special
Conditional formatting
Basic functions
3: Advanced formulas and linking
Advanced formulas like Database, time, date, number, mathematical logical etc.
Creating links
Errors and error types
4: Sorting & Filtering
Multilevel sorting
Custom sorting
Filtering
5: Goal Seek, Scenarios, Grouping and Subtotals
Creating, using, and ,editing scenarios
Concept of Goal seek and using it
Grouping large data by different criteria
Adding subtotals to grouped data
6: Lists, Charts & Data validation
Creating menu and sub menus by using list
Advanced & Dynamic chart properties
Applying data validation and generating error message
7: Pivot & Data from other sources functions
Report generation and extraction
Applying logic and functions
Generating charts my using extracted results
Importing exporting data from other sources and extensions
8: Security & Macro Basics s of Macro and using it
Cell protections
Hiding Data and formulas
Sheet protection
Workbook protection and sharing
Basics of Macro and using it
Bit of automation by using macros
9: Practice Session 1
Working with more than 1 lacs of entries in one sheet
Extracting reports
Data analysis
10: Doubt clearing session
Overall revision 1
11: Practice Session 2
Working with more than 2 lacs of entries in many sheets but linked
Extracting reports
Data analysis
12: Doubt clearing session
Overall revision 2
13: Introduction
Introduction to VBA
Analogy to understand the concept
VBA in MS-Excel
Macro Recordings
Excel Object Model
14: Sub Functions & Data
Types Sub Functions and Procedures
Data types
Variable Declaration
Basic coding
15: Sub Functions & Data Types
Working with objects and properties
Using worksheet functions
Handling multiple workbooks
16: Practical implementation
Familiar with the explained properties
Real time coding scenarios
Small projects
17: Loops & Conditional statements
IF, If Else, Else if, Select, etc
For, while, etc
18: Array & Handling errors in Excel Vba
Declaring/assigning Arrays
Error handling techniques
19: Form & Active X Controls
Text Box, List, Checkbox, Radio button, combo-list, etc