Excel VBA Programming - The Complete Guide
4.5 /5- Offered byUDEMY
Excel VBA Programming - The Complete Guide at UDEMY Overview
Duration | 18 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Excel VBA Programming - The Complete Guide at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 1 downloadable resources & 4 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Excel VBA Programming - The Complete Guide at UDEMY Course details
- For Spreadsheet users who want to automate their daily workflow
- For Business analysts who want to remove redundancy from their common tasks
- For Excel users who are curious about exploring programming in a familiar work environment
- Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
- Utilize the objects in the Excel Object Model to emulate user actions in Excel
- React dynamically to user events like entering a cell value or opening a workbook
- Feel comfortable with the fundamentals of computer programming
- Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook
- It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA
- In addition to the video content, the course is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress
Excel VBA Programming - The Complete Guide at UDEMY Curriculum
Getting Started
Introduction
About Me
Enable the Developer Tab
Excel File Types
Macro Security
The Macro Recorder
Record Macro to Change Worksheet Orientation
Absolute vs. Relative References I
Absolute vs. Relative References II
The Visual Basic Editor
The Fundamentals of the Excel Object Model
Object-Oriented Programming in Real Life
Collection Objects in Real Life
Objects As Properties
The Excel Object Model
Access Object from Collection by Name
Default Properties
The Name Property on Workbook and Worksheet Objects
The Visual Basic Editor
Visual Basic Editor Options
Create and Delete a Procedure
Procedures
The Immediate Window and Debug.Print Method
The MsgBox Method
Objects and Methods
Methods without Arguments
Methods with Arguments
Methods with Multiple Arguments
The Object Browser
Ways to Invoke A Procedure
The TypeName Method
Variables and Data types
Syntax Tips
Variable Declarations and Assignments
Multiple Variable Declarations
The Option Explicit Setting
The Byte, Integer and Long Data Types
Mathematical Operations
The Single and Double Data Types
The String Data Type
The Boolean Data Type
The Date Data Type
The Variant Data Type
The Object Data Type
Default Values for Declared Variables
Procedures
Variable Scope
Call A Procedure from Another one
Procedures with Arguments
Procedure Scope (Public vs. Private)
The Exit Sub Keywords
Constants
Predefined Constants
Excel VBA Programming - The Complete Guide at UDEMY Faculty details
Excel VBA Programming - The Complete Guide at UDEMY Entry Requirements
- Prerequisite: Basic knowledge of data types (numbers, strings, Booleans, dates)
- Intermediate knowledge of popular Excel features (functions, PivotTables, charts, etc.)
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?