English | MP4 | AVC 1820×1080 | AAC 44KHz 2ch | 22 Lessons (2h 44m) | 353 MB
Learn to wield the power of Excel Macros and VBA to automate, streamline, and master data in Excel. All from scratch!
Learn to wield the power of Excel Macros and VBA programming to automate, streamline, and master data in Excel. All from scratch!
What you’ll learn
- Understand the fundamentals of Excel Macros and how to automate repetitive task.
- Learn the basics of Visual Basic for Applications (VBA) programming to create custom solutions in Excel
- Develop practical skills to write, edit, and debug Excel Macros and VBA code effectively
- Master the ability to build dynamic and interactive Excel applications to enhance productivity
Table of Contents
1 Introduction
2 A Note to Mac Users
3 Opening Macro-Enabled Files
4 Editing Macros
5 Subroutine Structure
6 Buttons and Shapes
7 The Personal Workbook
8 Introducing Variables
9 Using Variables in Expressions
10 Option Explicit
11 Gathering User Input
12 Gathering User Input
13 Comments
14 Error Handling With IF Statements
15 Branching Logic With Else and ElseIf
16 Formatting Code
17 Naming Conventions
18 Using Worksheet Functions in VBA
19 User Defined Functions
20 User Defined Functions
21 Converting UDFs to Add-Ins
22 Objects, Properties and Methods
Resolve the captcha to access the links!