Microsoft Visual Basic for Excel Online Short Course

Overview

By automating tasks in Excel through the creation of macros using Visual Basic for Applications (VBA), you can write and run custom code to manipulate data, automate processes, and enhance spreadsheet functionality. Moreover, you’ll develop skills in creating user-defined functions (UDFs), designing interactive forms, and integrating VBA to execute complex operations, thereby solving specific business challenges in Excel.

Visual Basic is a programming language used within Excel. Although this course goes beyond standard formulas, it does require advanced knowledge of Excel. On the first day, you will become familiar with a variety of functions; then, on the second day, you will engage in practical exercises where you’ll apply your newly acquired knowledge to different scenarios, ultimately building confidence in practical application.

Course Content

  • Developer ribbonUnderstanding coding with macros
  • Referencing to sheets
  • Referencing to ranges
  • Declaring a variable
  • Inserting a basic user form
  • Opening up and closing user forms
  • Labels, text boxes and lists
  • Checkboxes, option boxes, and toggle boxes
  • IF formulas
  • Nested IF formulas
  • Other formulas
  • Loops
  • Using different modules for different macros and naming them
  • WITH statements
  • Testing and debugging
  • Protecting your code
  • Protecting sheets and unprotecting sheets with coding
  • Message boxes
  • Hiding and unhiding sheets, rows, and columns with coding
  • Inserting, deleting, and renaming sheets
  • Clean cells
  • Running a code when opening a workbook
  • Using the personal macro workbook to save different codes and how to add codes to the customised ribbon
  • Building a navigational sheet with buttons and userforms
  • Create a userform which updates a database every time you change the database
  • Opening multiple files and importing data
  • Unhiding all sheets in a file
  • Listing all the sheet names in a specific file
  • Non-accredited: Short course only  
  • Duration: 1h 30m
  • Delivery: Classroom/Online/Blended
  • Access Period: 12 Months 
Print Button
Scroll to Top