We are in the process of updating the site, so some pages still have the older design.

Start Here to Automate Excel

Download Project Files
Author: | Edits: don

Automate Excel Here

In this tutorial, I'll show you the foundation of building macros and automation for Microsoft Excel. This includes the 3 pillars of automation in Excel, which serves as the foundation of building your automated systems. Those pillars include: learning how to tell Excel what to do; where to put or install the instructions for Excel; and how to run those instructions by hand, by the click of a button, and automatically.

This tutorial does not teach programming in Excel, it is meant, instead, to help beginners understand how the automation system works. After this tutorial, you will have a good foundation from which to start your learning journey and improve your skills in automating Excel.

If you'd like to learn more about automating Excel, check our Excel Automation Courses (linked below).

I hope you enjoy the video! :)

Don

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
What is a UserForm in Excel?
Tutorial: A UserForm is basically a pop-up window that you can use to create a custom interface for ...
Use Excel Copilot AI to Automate Your Spreadsheet with the New Edit/Plan Feature
Tutorial: In this tutorial, I'll show you how to use the new Plan and Edit modes in Microsoft Excel...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
What is a Macro in Excel?
Tutorial: This is the first step to learning about Macros for Excel and how to use them.  What is a...
Excel Can Send Emails?! (5 Methods + AI Automation)
Tutorial: In this video, you'll learn 5 powerful ways to send emails directly from Excel, starting ...
Work FASTER in Excel (5 Simple Tricks)
Tutorial: Automate Excel Here In this video, I'll show you 5 Excel productivity tricks that I use e...
Tutorial Details
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course