English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 70 Lessons (11h 20m) | 1.58 GB
The only course you need to learn VBA Programming and master data analysis with Excel. Learn VBA Macros, Variables, Userforms, Loops, Arrays, Pivot Tables, and much more. This course will give you the skills you need to start a career in Data Analytics and get hired in 2022.
We guarantee you that this is the best and most up-to-date VBA Programming course that you can find. You will learn Excel VBA Programming from scratch including powerful tools like VBA Macros and Pivot Tables. You’ll automate tasks in Excel, build your own enterprise-level data management system, and have the skills to get hired as a Data Analyst in 2022!
WHAT YOU’LL LEARN
- Become a top 10% Data Analyst and Excel Power User to enhance your skillset and career opportunities
- Build an enterprise-level Data Management System that turns a manual, error-prone process into a sleek user experience that maintains the data integrity required in the business world
- Automate your day-to-day tasks through efficient VBA Macros
- Analyze large datasets with powerful Excel Pivot Tables
- Use Excel for rapid development of data-driven applications
- Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
- Learn how to work with external datasets
- Data entry tips and tricks
- Learn why Excel is one of the most popular pieces of software across all industries
- Start or supplement your programming journey by recording VBA Macros in Excel
Table of Contents
1 VBA Programming
2 A Note to Mac Users
3 Hello World – Introducing Macros
4 Opening Macro-Enabled Files
5 Editing Macros
6 Subroutine Structure
7 Buttons and Shapes
8 The Personal Workbook
9 Introducing Variables
10 Using Variables in Expressions
11 Option Explicit
12 Gathering User Input
13 Gathering User Input – A More Complex Example
14 Comments
15 Error Handling With IF Statements
16 Branching Logic With Else and ElseIf
17 Formatting Code
18 Naming Conventions
19 Using Worksheet Functions in VBA
20 User Defined Functions – A Simple Example
21 User Defined Functions – A More Complex Example
22 Converting UDFs to Add-Ins
23 Objects, Properties and Methods
24 Introducing Userforms
25 Adding Functionality to Userforms
26 Enhancing Userforms With Option Buttons
27 Enhancing Userforms With Combo Boxes
28 Combining Multiple Userforms
29 Introducing the InfoManager Project
30 InfoManager Part 1 – Intro
31 InfoManager Part 1 – Solution
32 Targeting Ranges With VBA
33 Advanced Methods For Targeting Ranges
34 Properties and Methods of Ranges
35 Exercise: Imposter Syndrome
36 Dynamic Methods For Targeting Ranges
37 Capturing Ranges As User Input
38 Writing Formulas With VBA
39 InfoManager Part 2 – Intro
40 InfoManager Part 2 – Solution
41 Do Loops
42 Debugging Tools
43 Validating User Input With Do Loops
44 For Next Loops
45 Nested Loops
46 For Each Loops
47 Loops – Example Subroutine
48 Loops – Example UDF
49 InfoManager Part 3 – Intro
50 InfoManager Part 3 – Solution
51 Introducing Arrays
52 Dynamic Arrays With ReDim Preserve
53 The SPLIT Function
54 InfoManager Part 4 – Intro
55 InfoManager Part 4 – Solution
56 Working With Worksheets
57 Iterating Through Worksheets
58 Consolidating Worksheets
59 Working with Workbooks
60 The Workbooks Collection
61 Opening Multiple Workbooks
62 Consolidating Workbooks
63 Worksheet and Workbook Events
64 InfoManager Part 5 – Intro
65 InfoManager Part 5 – Solution
66 External Data and VBA
67 Controlling Pivot Tables With VBA
68 InfoManager Part 6 – Intro
69 InfoManager Part 6 – Solution
70 Thank You!
Resolve the captcha to access the links!