Master Microsoft Excel Macros and Excel VBA (Udemy.com)

Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros

Created by: Kyle Pew

Produced in 2018

icon
What you will learn

  • Learn how to automate daily routine tasks within Excel
  • Learn best practices when creating macros and streamline your VBA code
  • Determine when it's best to use the Macro Recorder versus VBA
  • Learn how to write custom VBA Macros to create more robust automation
  • Learn VBA programming concepts to create dynamic, re-usable code
  • Complete real world Macro/VBA projects from beginning to end

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course Description

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016
Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.
During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.
As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.
Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.
Below are a few samples of the projects you will complete by enrolling and participating in this course.
  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel Worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
  • Automate the creation of Excel Formulas to SUM data up in your Report
  • Working with Excel VBA User Forms
  • Importing Data from External Text Files
Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.
So, don't lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.Who this course is for:
  • This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Kyle Pew

Qualifications:
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;
Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe SuitePhotoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports
Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.
Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.
Some of the clients Kyle has provided training for include:
Brocade
Chevron
Genentech
Facebook
Levi Strauss
PMI Mortgage Insurance
State Fund
Bank of the West
VISA
Walmart
and many more...


What Students have said about Kyle:
"Kyle was off the chart "GOOD""
<

icon
Students also recommend

Free

Free

$14.53

icon
Reviews

4.5

100 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Dixon Alfred on a week ago

kyle is amazing!!This course has been so very interactive just like the VBA Magic is!!To be frank I used to think Excel was not fun, but after this its really been a great experience.After all, knowledge is power!

By Rachel Hall on 2 weeks ago

I really enjoyed this class and found it very helpful. I wish it had a section on creating charts through VBA. Kyle is a great instructor and his descriptions and details are very easy to follow along with. Thanks!

By Kilian Morrissey on a month ago

Great introduction to using VBA code, managed to dive right in to the code in a short space of time. Will need lots of further practice to fully understand and use all the data structures.

By James Sherwin Credo on 2 months ago

What he taught, he taught well. There are very few inaccuracies and will allow students to apply the actions taught on the course on similar projects. However, it's not enough for someone to be called a master. Still, it's a very good course for students to get their feet wet on the topic and allow them to automate a lot of the work that goes into the day-to-day of a typical office worker. I highly recommend it.

By Isaac Rakobang Mokhobo on 2 months ago

Great course, covered a wide range of topics and the instructor was brilliant. I would recommend this course to anyone who is interested in VBA programming great experience all-round.

By JYOTIRMOY SHARMA on 3 months ago

YOU EXPLAIN THINGS IN BEST POSSIBLE WAYDELIVER AND CONTENT ARE GOODPLEASE INCLUDE MORE REAL LIFE EXAMPLES

By Lee M Cohen on 6 days ago

Excellent overall, a little chatty, so increased speed to 1.5. In some cases, PDF lesson does not match video, in one instance, name of marco was different in video than in course workbook. "FormatData" as opposed to "FormatHeaders" but sometimes finding errors yourself is a good thing.

By Ahmed Ali on 3 months ago

Great introduction to VBA and very helpful to understand other peoples code when googling for VBA solutions to tasks that I needed to complete

By Lysys Automation Team on a month ago

Going through the course was a great experience in terms of advancing office skills.

By Brian Sullivan on a month ago

This course is very clear, it is a perfect starter course to get into macros. Look forward to ramping up this knowledge to the expert level. Thank you for teaching this course!

By Parikshit Srivastava on a week ago

All the sessions are very interactive. The course has been presented in such a manner that it is highly interesting and enjoyable.

By Pratikkumar Kothari on 2 months ago

It was indeed a great course to learn Excel-VBA macros. The instructor was really awesome. He had selected some really good projects to learn the practical use of VBA macros. I would highly recommend this course to anyone looking to learn VBA coding.