Udemy

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

Enroll Now
  • 23,143 Students
  • Updated 10/2017
3.6
(220 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 14 Minute(s)
Language
English
Taught by
Think Forward Online Training
Rating
3.6
(220 Ratings)

Course Overview

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

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

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!

Course Content

  • 6 section(s)
  • 12 lecture(s)
  • Section 1 Introduction
  • Section 2 Project 1 - Easy: "My First Macro" or "The Fun Macro"
  • Section 3 Project 2 - Intermediate: "Compose Customer Emails from Your Customer List"
  • Section 4 Project 3 - Intermediate: "Prepping Unstructured Data for Data Analytics"
  • Section 5 Project 4 - Advanced: "Format and Create a CSV Export from Client Data"
  • Section 6 Project 5 - Advanced: Create Your Own Project

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


Reviews

  • G
    Gaizka Galvez
    5.0

    Perfect to learn while practicing, which makes this course more entertaining than the ones based on pure theory

  • A
    Aybars Topcu
    3.0

    Lots of things are just given but not explained... He writes some codes by himself and explains the half of it.... and you watch him writing codes by himself and talking to himself...

  • M
    MEHAK CHOPRA
    5.0

    yes it is a good match but next time please zoom out the window show we can see clear

  • J
    John Zschoche
    2.5

    Other then having a micro font that can't be read without bugging your eyes out of your head The course would teach people more of the use of IF or When statements

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed