Macros & VBA Training Series Part 1:

Writing Your First Macro & The Excel Object Model

Double-click video to view in Full Screen HD.

Download the file used in this video:

My First Macro.xslm (93.0 KB)

Macros & VBA Training Series
Enroll for FREE

The video above is the first in a 3-part training series. Can I send you the next two videos?

Please click the link below to enroll in the free training. I will send you video #2 in just a few days.​

Video 1

Intro to VBA:
Writing Your First Macro

Video 2

Automating Tasks:
The Summary Report

Video 3

Userforms:
The Exports Sheets App

Please click the big green button above to register for the free training series.

About Me

Welcome to Excel Campus!  I am excited you are here!

My name is Jon Acampora and my goal is to help you learn Excel to save time with your job and advance in your career.  I've been an avid Excel user and VBA developer for 10+ years.  I am also a Microsoft MVP.  When I'm not looking at spreadsheets, I get outdoors and surf. 🙂

What Process Do You Want To Automate in Excel?

Please leave a comment below with your answer, and any questions.  Thanks!​

Click Here to Leave a Comment Below 1280 comments
Ossie - October 19, 2017

I wish to gain skills to build from,scratch, a robust and usable Excel based Desktop application to be used by others without any excel skills

Reply
sriram - October 19, 2017

Hi jon,
As a finance professional, i would like to automate few tasks like hide gridlines, copy the company name as heading to every sheet etc.. these are repetitive in nature and consumes lot of time.

Reply
Sherly - October 18, 2017

I really interested in learning more about excel all about excel, and I’m so glad to fine your website, I’ve been struggling in learning some about excel that I can’t understand. I’m creating some tamplate and I want it to automatically synchronize with other Excel n work sheet but I still lack in knowledge of excel program. Hope you can advise me to solve my problems.
Thank you

Reply
Ginny - October 10, 2017

I would like to add columns to a spreadsheet that is updated monthly. Currently I hide the oldest, copy and insert the newest, delete contents of the copied column and paste in the new information. There are 16 metrics side by side and the same task must be done for each.

Reply
keshav - October 9, 2017

i want to upload the contents of my excel sheet into a website, one cell at a time.

Reply
mohd basir bin suleiman - October 8, 2017

As a teacher I have say 60 students and I need to list :-

1. Each student as to Grade (eg 50 should return the alphabet C in the neighboring cell.(A, B,C etc)
2. A summary as to how many students gets A, and how many got B etc.
3. And a column graph as to how many students got A, B, C etc.

TQ

Reply
Leanna - October 6, 2017

I am responsible for maintaining budgets at home and at work. I’d love an easier way to do that.

Reply
Mike - October 3, 2017

New to VBA & Macros. I have data in several cells on a work sheet that move based on the =Today() function and I want to be able to move that same cells info to another area of the same sheet so as it disappears via the today date function the data is still there.

Reply
Andrea - September 29, 2017

I want to automate matching lines to combine them. for example, on a bank reconciliation, I want my macro to look at two particular data columns for a match, then consolidate the lines. Love Andy!

Reply
Lou - September 27, 2017

Easy to follow. Looking forward to next video. Would like to automate hiding/unhiding blank rows and columns. Would like to automate monthly report printing.

Reply

Leave a Reply: