Course curriculum
-
1
INTRO TO VBA - Overview
-
2
INTRO TO VBA - Worksheet Object
-
3
INTRO TO VBA - Range Object
-
4
INTRO TO VBA - Relative References
-
5
INTRO TO VBA - Modules & Procedures
-
6
INTRO TO VBA - Variables & Data Types
-
7
INTRO TO VBA - Conditional Statements & Loops
-
8
INTRO TO VBA - Message & Input Box
-
9
USERFORMS - Build a User Interface With a VBA UserForm
-
10
USERFORMS - Connecting the UserForm to a Worksheet for Data Entry
-
11
USERFORMS - Create a Print Report UserForm
-
12
USERFORMS - Build a Statistical UserForm
-
13
CREATE A VBA DASHBOARD - INTRODUCTION
-
14
CREATE A VBA DASHBOARD - CLEAN YOUR DATA WITH EXCEL FORMULAS
-
15
CREATE A VBA DASHBOARD - LOOK UP DATA
-
16
CREATE A VBA DASHBOARD - FILTERING DATA
-
17
CREATE A VBA DASHBOARD - SUBTOTALS
-
18
CREATE A VBA DASHBOARD - PIVOT TABLES & PIVOT CHARTS
-
19
CREATE A VBA DASHBOARD - INTERACTIVE BUTTONS
-
20
CREATE A VBA DASHBOARD - FINAL TOUCHES
-
Intro to VBA Exercise Files Downloadable Workbook What Is VBA? Object Structure Developer Tab Intro To VBA Window Immediate Window Object Ref Shorthand Object Ref Object Props Methods -
Download Workbook Worksheet References Worksheet Select Method Worksheets Name Property Worksheets Count Property Worksheets Add Method Worksheets Print Method Worksheets Delete Method -
Download Workbook Range Object Intro Selecting a Range Range Value Property Copy Paste Methods Reference Other Worksheet Cell -
Download Workbook Differences between Relative & Absolute References Active Sheet Object Active Cell Ref Current Region Property Offset Command -
What is a Module Creating a Procedure Adding VBA Code to your Procedure Running a Procedure Procedure Button Calling Procedures VBA Comments Saving VBA Code -
Download Workbooks What are Variables Declaring Variables Using a Variable Common Data Types String Data Type Integer & Long Data Type Boolean Type -
Download Workbooks IF Statements ElseIf and Else Statements Understanding Loops Do While Loop For Each Loop & Debug -
Download Workbook Message Box Intro Adding Buttons To Message Box Handle Button Presses Input Box -
Downloadable Workbook PROJECT #1: Intro PROJECT #1: Create a VBA User Form PROJECT #1: Adding Controls PROJECT #1: Control Properties PROJECT #1: Project Type Combo Box PROJECT #1: Employee Combo Box PROJECT #1: Date Default PROJECT #1: Start Time Button PROJECT #1: Show User Form with a Button -
Downloadable Workbook PROJECT #2: Intro PROJECT #2: Submit Button Employee Sheet PROJECT #2: Transfer Data to a Worksheet PROJECT #2: Calculate Call Duration Formula PROJECT #2: Generate Unique Call ID Procedure PROJECT #2: Call Procedure From User Form PROJECT #2: Validate User Form Data with a Message Box PROJECT #2: Clear Data Button with a Loop -
Downloadable Workbook PROJECT #3: Intro PROJECT #3: Creating Print Report Form PROJECT #3: Opening a New Workbook Template PROJECT #3: Looping Controls Worksheets PROJECT #3: Copy & Paste Data to a New Workbook PROJECT #3: Clean Up Your VBA Code (Screen Updating) -
Downloadable Workbook PROJECT #4: Intro PROJECT #4: Create Temp Sheet - 01 PROJECT #4: Create Temp Sheet - 02 PROJECT #4: Create Call Stats PROJECT #4: Call Stats Initialize PROJECT #4: Create Send Email -
Downloadable Workbooks Course Introduction Dealing With Raw Data Excel Dashboard Magic Get Started -
Using Excels PROPER() Function on Text Create Consistency with Excels UPPER() Function Paste Special Values Replace Meaningless Data with Excels CHOOSE() Function Extract Date Values Using Excels TEXT() Function -
Downloadable Workbook Dashboard Overview Preparing the Data Using Format As An Excel Table Creating a Drop Down Menu with Data Validation Looking Up Data with Excels VLOOKUP() Function Cleaning Up Data with Excels IF() Function INDEX() and MATCH() an Alternative to VLOOKUP() -
Adding the Order History Table Formatting Orders as a Table Using Excels Advanced Filter Feature Record a Macro for Advanced Filter Filter Order Records On Change of Customer with VBA Modify the VBA Filter Code -
Why Use Excels SUBTOTAL() Function Implementing the SUBTOTAL() Function -
Downloadable Workbooks Why Use Pivot Tables Summarizing Order Info with Pivot Tables Prepare Pivot Table for Customer Filter Creating a VBA Procedure for your Pivot Table Declaring VBA Variables for your Pivot Table Assigning VBA Variables to your Pivot Table Connecting the Filter to the Pivot Table with VBA Update Pivot Chart Based on Customer Selected with VBA Fix Customers with No Orders Error with VBA -
Creating Interactive Charts with Slicers Modifying the Chart Slicer -
Hiding Extra Worksheets and Columns Cleaning Up the Excel Default Settings Hiding the Chart & Slicer with VBA Protecting Your Dashboard
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
Get started now
Free
Regular price