MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel VBA and Macros with MrExcel

Course Summary

Excel VBA/macro visual training on demand! 60+ lessons: users can learn what they want when they want it.


  • +

    Course Syllabus

      • Introduction
    • Recording Macros
      • Introduction to Recording Macros
      • Lesson 1: Enable Developer Tab
      • Lesson 2: Recording your First Macro
      • Lesson 3: Running a Macro
      • Lesson 4: Keys to Successful Recording
      • Lesson 5: Variable Number of Rows
      • Lesson 6: Adding Tools
      • Lesson 7: Opening a Workbook with Macros
    • The VBA Editor
      • Introduction to The VBA Editor
      • Lesson 8: Introducing the VBA Editor
      • Lesson 9: VBA Help
      • Lesson 10: Object Browser
      • Lesson 11: Stepping Through Code
      • Lesson 12: Immediate Pane
      • Lesson 13: Watch Window
      • Lesson 14: Breakpoints
    • VBA Syntax
      • Introduction to VBA Syntax
      • Lesson 15: VBA Parts of Speech
      • Lesson 16: Using Regular Variables
      • Lesson 17: Using Object Variables
      • Lesson 18: Referring to Cells
      • Lesson 19: Declaring Variables or Not
    • Making Decisions
      • Introduction to Making Decisions
      • Lesson 20: If Then
      • Lesson 21: If Then Else
      • Lesson 22: Select Case
    • Looping
      • Introduction to Looping
      • Lesson 23: Finding the Final Row
      • Lesson 24: Basic Looping
      • Lesson 25: Loop Example
      • Lesson 26: Deleting While Looping
      • Lesson 27: Every Other Row Loops
      • Lesson 28: Other Legacy Loops
      • Lesson 29: For Each Loops
    • Worksheets & Workbooks
      • Introduction to Worksheets & Workbooks
      • Lesson 30: Creating Worksheets
      • Lesson 31: Creating Workbooks
      • Lesson 32: Listing Files in a Folder
      • Lesson 33: Combining Workbooks
    • Formulas
      • Introduction to Formulas
      • Lesson 34: A1-Style Formulas
      • Lesson 35: R1C1-Style Formulas
      • Lesson 36: Using Excel Functions in Code
      • Lesson 37: Adding Functions to Excel
    • Power Tools
      • Introduction to Power Tools
      • Lesson 38: Advanced Filter
      • Lesson 39: Filter Instead of Looping
      • Lesson 40: Pivot Tables
      • Lesson 41: Charts
      • Lesson 42: Event Handler Macros
    • Interacting
      • Introduction to Interacting
      • Lesson 43: Interacting
      • Lesson 44: Getting File Names
      • Lesson 45: Userforms
      • Lesson 46: Error Handling
      • Lesson 47: Suppressing Alerts
      • Lesson 48: Faster Code
    • Best Practices
      • Introduction to Best Practices
      • Lesson 49: Separating Code and Data
      • Lesson 50: Cleaning Recorded Code
    • Code Examples
      • Code Examples


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

VBA

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top