Excel Visual Basic (VBA) for Post-Beginners

If you know the basics of Excel Visual Basic (VBA), and have watched our Excel Visual Basic (VBA) for Beginners series, it is time to take the next step. In this series, We take an everyday task – creating reports from a database – and look at how to complete it using Excel VBA. The series consists of 6 videos, including the introduction.

The series comes with a download file, and we recommend that you work along with the video. Click to download the Excel spreadsheet files below:

File WITHOUT Excel Visual Basic
File WITH Excel Visual Basic

Video 1: Introduction

Video 2: Record Code to Duplicate Sheets

Video 3: Loops to Duplicate Sheets

Video 4: Loops and If to Delete Sheets

Video 5: Offset to Position Data

Video 6: Create Reports Using VBA – Full Demo

Have you completed the video series? How did you find it? If you develop confidence in these areas, it won’t just save you time, it will transform the way you work with Excel spreadsheets.

Now, learn about another advanced Excel technique.

Can you help us improve these resources? We would love to hear from you. Contact Us.

This entry was posted in Advanced Videos, Excel Guidance Articles, Excel Guidance Videos, Excel Guidance Videos & Articles, Intermediate Videos. Bookmark the permalink. Comments are closed, but you can leave a trackback: Trackback URL.