Excel Macros/VBA: Create 4 Real World Projects from Scratch

Name: Excel Macros/VBA: Create 4 Real World Projects from Scratch
Rating: 3.6 (220 reviews)

Learn to solve any problem with Excel by watching me do it in real time. Experience full and uncut problem solving!

Created byThink Forward Online Training

Last updated 10/2017

English

What you'll learn

Tackle any Excel problem that is thrown at you (and many other problems too!)
Use Excel Macros to reduce your Excel workload to almost nothing
Increase your productivity (and those around you, if you're nice)
Put a portfolio of 5+ complex Excel problems you have solved on your resume

Course content

6 sections • 12 lectures • 2h 14m total length

Introduction3:04
Explore VBA basics and Excel macros, including if blocks, while loops, switch statements, and functions, through five hands-on projects from fun macros to real-world data tasks.
The VBA Editor3:01
Explore the VBA editor, naming modules and using intellisense to speed coding. Debug with compile checks, breakpoints, and step-by-step execution to start building real-world Excel macros.

Introduction to "Compose Customer Emails from Your Customer List"1:53
Create a macro in Excel VBA to send personalized emails to every customer from your list, using if blocks, loops, and variables to tailor each message.
Programming of "Compose Customer Emails from Your Customer List"22:45
Automate sending customer emails from an Excel VBA macro by composing subject and message, selecting a data range, looping through rows, and sending via the external mail application.
Challenge for "Compose Customer Emails from Your Customer List"1:11
Develop real world email projects by composing professional customer emails from your list using Excel macros and VBA, including adding a logo and proper greeting and signature spacing.

Introduction to "Prepping Unstructured Data for Data Analytics"1:56
Use Excel macros to prep unstructured Excel data for data analytics by transforming thousands of transactions into a relational database-friendly format for Microsoft Access.
Programming of "Prepping Unstructured Data for Data Analytics"27:11
Learn to prep unstructured data in Excel using macros/VBA by mapping thousands of transactions into two relational tables—customer and order—and import into Access.
Challenge for "Prepping Unstructured Data for Data Analytics"2:12
Prep unstructured data for analytics by assigning unique customer IDs, using lookups to replace auto increment IDs, and deriving insights like top customers and popular products.

Introduction to "Format and Create a CSV Export from Client Data"1:42
Create an Excel macro to format client data into a precise CSV export for mass upload to accounting software, enabling a one-click, automated data transformation for debits and credits.
Programming of "Format and Create a CSV Export from Client Data"48:31
Format messy client data in Excel using VBA to produce a CSV export, leveraging a lookup table, debit/credit logic, and an output sheet for final formatting.

Requirements

You should know the basics of Excel or another spreadsheet program
We will cover basic programming, but previous basic knowledge of programming is a plus

Description

Imagine if everything you had to do in Excel could be reduced to a click of a button. How much time would that save you in your workday? How much stress would disappear because now you don’t have to dread completing your tedious Excel work? If you’re reading this course description, I bet the answer is quite a bit.

The entire purpose of my day job is to automate tedious work that people don’t want to do. This increases the productivity of my company, which is very valuable. It allows us to continue growing without adding many more employees, which increases our profits. I use many tools to achieve automation, but Excel is one of the best because it’s simple to learn yet very powerful in application. My goal with this course is to enable you to increase your own productivity, just like I do for many people at my day job.

I will use real world projects, some that I have had to deal with myself. You will see the process that I go through to figure out how to automate these tasks. It may be surprising, but I usually don’t know how to accomplish an automation project from the get-go. It takes some planning and critical thinking for every project you take on. That’s why you should think of this course more as providing the tools for you to solve any problem, rather than an encyclopedia-like course that will give you a bunch of information. For those of you still reading, I hope you enjoy the course. I put a lot of work into creating the most useful course I could!

Who this course is for:

Anyone who wants to take their Excel problem solving skills to the next level
Anyone who wants to eliminate their Excel workload

Excel Macros/VBA: Create 4 Real World Projects from Scratch

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

Project 1 - Easy: "My First Macro" or "The Fun Macro"1 lecture • 20min

Project 2 - Intermediate: "Compose Customer Emails from Your Customer List"3 lectures • 26min

Project 3 - Intermediate: "Prepping Unstructured Data for Data Analytics"3 lectures • 31min

Project 4 - Advanced: "Format and Create a CSV Export from Client Data"2 lectures • 50min

Project 5 - Advanced: Create Your Own Project1 lecture • 1min

Requirements

Description

Who this course is for: