Advanced - Macros & VBA

Banner

Your banner contains a hero image with text overlay. You can also add call to action buttons.

Interested in this course? Email us at [email protected]

Icons & text

Icon & text

Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?
Icon & text

Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?
Icon & text

Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

Course curriculum

1. Getting Started With Macros & VBA
2. Common VBA Programming Concepts You Can Use Today
3. 5 Awesome Worksheet Macros
1. Intro to VBA
2. Exercise Files
3. Downloadable Workbook
4. What Is VBA?
5. Object Structure
6. Developer Tab
7. Intro To VBA Window
8. Immediate Window Object Ref
9. Shorthand Object Ref
10. Object Props Methods
1. Download Workbook
2. Worksheet References
3. Worksheet Select Method
4. Worksheets Name Property
5. Worksheets Count Property
6. Worksheets Add Method
7. Worksheets Print Method
8. Worksheets Delete Method
1. Download Workbook
2. Range Object Intro
3. Selecting a Range
4. Range Value Property
5. Copy Paste Methods
6. Reference Other Worksheet Cell
1. Download Workbook
2. Differences between Relative & Absolute References
3. Active Sheet Object
4. Active Cell Ref
5. Current Region Property
6. Offset Command
1. What is a Module
2. Creating a Procedure
3. Adding VBA Code to your Procedure
4. Running a Procedure
5. Procedure Button
6. Calling Procedures
7. VBA Comments
8. Saving VBA Code
1. Download Workbooks
2. What are Variables
3. Declaring Variables
4. Using a Variable
5. Common Data Types
6. String Data Type
7. Integer & Long Data Type
8. Boolean Type
1. Download Workbooks
2. IF Statements
3. ElseIf and Else Statements
4. Understanding Loops
5. Do While Loop
6. For Each Loop & Debug
1. Download Workbook
2. Message Box Intro
3. Adding Buttons To Message Box
4. Handle Button Presses
5. Input Box
1. Downloadable Workbook
2. PROJECT #1: Intro
3. PROJECT #1: Create a VBA User Form
4. PROJECT #1: Adding Controls
5. PROJECT #1: Control Properties
6. PROJECT #1: Project Type Combo Box
7. PROJECT #1: Employee Combo Box
8. PROJECT #1: Date Default
9. PROJECT #1: Start Time Button
10. PROJECT #1: Show User Form with a Button
1. Downloadable Workbook
2. PROJECT #2: Intro
3. PROJECT #2: Submit Button Employee Sheet
4. PROJECT #2: Transfer Data to a Worksheet
5. PROJECT #2: Calculate Call Duration Formula
6. PROJECT #2: Generate Unique Call ID Procedure
7. PROJECT #2: Call Procedure From User Form
8. PROJECT #2: Validate User Form Data with a Message Box
9. PROJECT #2: Clear Data Button with a Loop
1. Downloadable Workbook
2. PROJECT #3: Intro
3. PROJECT #3: Creating Print Report Form
4. PROJECT #3: Opening a New Workbook Template
5. PROJECT #3: Looping Controls Worksheets
6. PROJECT #3: Copy & Paste Data to a New Workbook
7. PROJECT #3: Clean Up Your VBA Code (Screen Updating)
1. Downloadable Workbook
2. PROJECT #4: Intro
3. PROJECT #4: Create Temp Sheet - 01
4. PROJECT #4: Create Temp Sheet - 02
5. PROJECT #4: Create Call Stats
6. PROJECT #4: Call Stats Initialize
7. PROJECT #4: Create Send Email
1. Downloadable Workbooks
2. Course Introduction
3. Dealing With Raw Data
4. Excel Dashboard Magic
5. Get Started
1. Using Excels PROPER() Function on Text
2. Create Consistency with Excels UPPER() Function
3. Paste Special Values
4. Replace Meaningless Data with Excels CHOOSE() Function
5. Extract Date Values Using Excels TEXT() Function
1. Downloadable Workbook
2. Dashboard Overview
3. Preparing the Data Using Format As An Excel Table
4. Creating a Drop Down Menu with Data Validation
5. Looking Up Data with Excels VLOOKUP() Function
6. Cleaning Up Data with Excels IF() Function
7. INDEX() and MATCH() an Alternative to VLOOKUP()
1. Adding the Order History Table
2. Formatting Orders as a Table
3. Using Excels Advanced Filter Feature
4. Record a Macro for Advanced Filter
5. Filter Order Records On Change of Customer with VBA
6. Modify the VBA Filter Code
1. Why Use Excels SUBTOTAL() Function
2. Implementing the SUBTOTAL() Function
1. Downloadable Workbooks
2. Why Use Pivot Tables
3. Summarizing Order Info with Pivot Tables
4. Prepare Pivot Table for Customer Filter
5. Creating a VBA Procedure for your Pivot Table
6. Declaring VBA Variables for your Pivot Table
7. Assigning VBA Variables to your Pivot Table
8. Connecting the Filter to the Pivot Table with VBA
9. Update Pivot Chart Based on Customer Selected with VBA
10. Fix Customers with No Orders Error with VBA
1. Creating Interactive Charts with Slicers
2. Modifying the Chart Slicer
1. Hiding Extra Worksheets and Columns
2. Cleaning Up the Excel Default Settings
3. Hiding the Chart & Slicer with VBA
4. Protecting Your Dashboard
1. [Quiz] - Advanced - Macros & VBA
1. Unlock your Certificate of Completion

About this course

Free
136 lessons
11 hours of video content

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Free

Regular price

Get started now

Call to action

This is where you seal the deal. Sprinkle this section throughout you page to push prospects to purchase!

Get started now

Banner

Icons & text

Icon & text

Icon & text

Icon & text

Course curriculum

Cheat Sheets

INTRO TO VBA - Overview

INTRO TO VBA - Worksheet Object

INTRO TO VBA - Range Object

INTRO TO VBA - Relative References

INTRO TO VBA - Modules & Procedures

INTRO TO VBA - Variables & Data Types

INTRO TO VBA - Conditional Statements & Loops

INTRO TO VBA - Message & Input Box

USERFORMS - Build a User Interface With a VBA UserForm

USERFORMS - Connecting the UserForm to a Worksheet for Data Entry

USERFORMS - Create a Print Report UserForm

USERFORMS - Build a Statistical UserForm

CREATE A VBA DASHBOARD - INTRODUCTION

CREATE A VBA DASHBOARD - CLEAN YOUR DATA WITH EXCEL FORMULAS

CREATE A VBA DASHBOARD - LOOK UP DATA

CREATE A VBA DASHBOARD - FILTERING DATA

CREATE A VBA DASHBOARD - SUBTOTALS

CREATE A VBA DASHBOARD - PIVOT TABLES & PIVOT CHARTS

CREATE A VBA DASHBOARD - INTERACTIVE BUTTONS

CREATE A VBA DASHBOARD - FINAL TOUCHES

Quiz Test

Certificate of Completion

About this course

Pricing options

Free

Call to action