Excel in Microsoft Excel 4: VBA macros for Excel – an intro

37

Lessons

All

Skill Level

3:37h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

Welcome to Excel VBA – An Introduction. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products).

Microsoft Excel is an extremely powerful tool – and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features – yet most people don’t even know it’s there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school – or in other words, Visual Basic for Applications (VBA).

In this course, I’ll assume that you have some fair knowledge of Excel – able to do basic formulas and colour cells and the like – but you don’t need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. I’ll take things nice and slowly. Each video will center around one new aspect, or we’ll consolidate what you already know with coding exercises. 

Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems. And you’ll be able to take your new-found knowledge for use in Word and PowerPoint as well.

Completing this course will help you:

Who is the course for?

This Excel VBA course is for you if you want to learn how to automate Excel and provide a better user interaction.

No prior programming language is required – although, it would always help!

This course is not for you if you are confident using VBA, and are looking for more advanced techniques.

Learning Path

  • The Developer Tab
  • My First Macro
  • Use Relative References
  • The editing environment
  • Hello World!
  • Saving and opening our spreadsheet
  • Security
  • Self certification
  • Introducing variables
  • Scope
  • Breakpoints, the Immediate Window and Watches
  • String operators
  • Declaring types of variables
  • Avoiding typos
  • Interacting with the Excel spreadsheet
  • Introducing Objects
  • Introducing the Object Model
  • Default Objects, and Default Properties
  • For…Next Loops
  • InputBox
  • IsNumeric and If…Then
  • If…Else…End If
  • Val()
  • Do While…Loop
  • Other types of loops
  • Selection
  • Set
  • For Each…Next Loop

What people are saying

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course