Visual Basics for Applications: Excel VBA Beginner

https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=50115&expertiselevel=50116 https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=50115&expertiselevel=50117 https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=50115&expertiselevel=50118
  • 1 Course | 2h 39s
  • 5 Books | 51h 55m
  • 1 Course | 1h 26m 16s
  • 4 Books | 39h 25m
  • 1 Course | 2h 3m 23s
  • 4 Books | 52h 8m
Likes 19 Likes 19
 
Explore Visual Basics for Applications (VBA), an event-driven programming language created by Microsoft that is mostly used in Microsoft Office applications.

GETTING STARTED

VBA: Getting Started with VBA in Excel

  • Playable
    1. 
    Course Overview
    2m 36s
    NOW PLAYING
  • Playable
    2. 
    Getting Started with VBA
    11m 51s
    UP NEXT

GETTING STARTED

VBA: Building User Interfaces with Forms in VBA & Excel

  • Playable
    1. 
    Course Overview
    2m 8s
    NOW PLAYING
  • Playable
    2. 
    Adding a User Form to an Excel Workbook
    10m 28s
    UP NEXT

GETTING STARTED

VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access

  • Playable
    1. 
    Course Overview
    2m 56s
    NOW PLAYING
  • Playable
    2. 
    Working with Excel Pivot Tables from VBA
    12m 28s
    UP NEXT

COURSES INCLUDED

VBA: Getting Started with VBA in Excel
Excel's VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you'll begin by using subroutines in VBA to perform operations. You'll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you'll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You'll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you'll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.
13 videos | 2h