Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
In this course, you will develop and deploy VBA modules to solve business problems. You will:
Topic A: Use Macros to Automate Tasks in Excel
Topic B: Identify Components of Macro-Enabled Workbooks
Topic C: Configure the Excel VBA Environment
Topic A: Use the Macro Recorder to Create a VBA Macro
Topic B: Record a Macro with Relative Addressing
Topic C: Delete Macros and Modules
Topic D: Identify Strategies for Using the Macro Recorder
Topic A: Use VBA Help
Topic B: Use the Object Browser to Discover Objects You Can Use in VBA
Topic C: Use the Immediate Window to Explore Object Properties and Methods
Topic A: Create a Custom Function
Topic B: Make Decisions in Code
Topic C: Work with Variables
Topic D: Perform Repetitive Tasks
Topic A: Debug VBA Errors
Topic B: Deal with Errors
Topic C: Improve Macro Performance
Topic A: Prompt the User for Information
Topic B: Configure Macros to Run Automatically
Topic A: Display a Custom Dialog Box
Topic B: Program Form Events
Topic A: Use VBA to Get File and Directory Structure
Topic B: Use VBA to Read Text Files
Topic C: Use VBA to Write Text Files
Topic A: Automate Power Query
Topic B: Transform Data Using VBA and Workbook Functions
Topic C: Use Regular Expressions
Topic D: Manage Errors in Data
Topic A: Run Other Programs and Commands
Topic B: Share Your VBA Projects