Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel
4.3 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,109 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel to your Wishlist.

Add to Wishlist

Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel

Excel VBA Mastery By Creating 9 Practical VBA Macros That Will Automate Your Excel & Teach You How To Code
4.3 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,109 students enrolled
Last updated 1/2017
English
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand how to make Excel work for them, rather than spending time on the same manual tasks
  • Master Excel programming through practice - there are 9 distinct code sequences that they will write
  • Build their first macro and run a macro using a button
  • Create user-friendly auto-filters by writing code
  • Manipulate Excel Comments with VBA
  • Build interactive charts with drop-down menus for a more user-friendly Excel experience
  • Automatically send emails via Excel and avoid the manual work of reporting
View Curriculum
Requirements
  • Must Have: Microsoft Excel Installed On Your Computer
  • Nice To Have: The Latest Version Of Excel (2013 is Preferable)
  • Nice To Have: Several Screens To Facilitate Better Action Taking (i.e. Extra Desktop Monitor or 2 Devices)
  • A Positive Attitude, Willingness To Take Action And Improve Your VBA Skills
Description

Are you tired of the same long, boring days creating dashboards, charts and Vlookups while barely having time to do anything else?

Wouldn't it be cool if you could automate all these tasks, spend less time in front of the computer and more time advancing your career,   scaling your business, or doubling your salary?

 Why Learn VBA?

Excel VBA can completely skyrocket your productivity - if you learn how to automate Excel processes you will achieve the same results in 50% of the time.

However, it is not something easy to learn - it will take you countless hours in front of the computer. The good news is that with the right approach you can shortcut that process and learn the fundamentals that will give you 80% of the skills with 20% of the effort.

If you learn how to program in Excel properly, you can:

  • Have one task always execute the same way with the push of 1 button
  • Perform that task at a much higher speed than if you were to do it manually
  • Ensure 100% accuracy
  • Enable people that don't know much about the task to execute it the same way as yourself
  • Differentiate yourself at the workplace by enabling Excel to do operations that might seem impossible to others
  • Sit back and relax while letting your macros handle the complex tasks that take up computational power and a lot of time

The Excel VBA Blueprint 

That's why we created the Excel VBA Blueprint. Rather than taking you through a long list of boring features, we teach you 9 specific VBA Macros that you can apply straight away.

Tired of time consuming deeply nested formulas? You'll learn how to create your own tailor made Excel functions

Want to automate your reporting process? Learn how to automatically send emails directly from Excel

How about upgrading your charts? Learn the simple code to create charts that are customisable through a dropdown menu.

 All of this, and much more.

When building this course, our main focus was practicality.  That's why:

  • You get class test scenarios and solutions at every Section end so that you can test your newly learned abilities
  • You get every spreadsheet at every step along the way - this way you can always check your code for accuracy
  • Each section is a scenario for a particular Macro - this is our version of learning by doing!

If you want to learn the VBA hacks that will skyrocket your productivity, then this course will take you there. Have a look at our free preview lectures, take this course now and join us on this exciting journey!

Who is the target audience?
  • Anybody that is adept at Excel and wants to learn automation
  • People that want to Excel at the workplace and become an authority in this field
  • Individuals that love programming and automating tasks & work consistently in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
59 Lectures
04:20:25
+
Introduction
1 Lecture 02:51

Course overview

Preview 02:51
+
Introduction To VBA and Excel Macros
9 Lectures 22:34

Find out what VBA is and what can be used for

Preview 01:28

Learn how to enable Developer tab in Excel and how to open VBA

Preview 01:35

Get in touch with Visual Basic for Application IDE (Integrated Development Enviroment)

Preview 03:19

Get your first hands on experience with VBA by writing your own first macro

Preview 02:00

Find out what every line is doing from your first macro

Preview 01:44

Find how to tun a macro via a button added straight to your worksheet

Run A Macro Using A Button
03:14

See how to customize Excel ribbon and add a button to run your VBA macros

Run A Macro Using A Menu Button
02:51

Saving your macro enabled Excel file is a bit different than your average Excel file

Save Your First Macro Enabled Excel File
05:29

You've seen how to run a macro via a button and a Ribbon control, but are there any other ways?

Action Test - Add A Macro To An Image
00:54
+
Consolidate Data with macro
7 Lectures 56:21

See how to use the the Excel workbook in VBA

Theoretical: Workbook Object
11:55

Learn how to use the Excel Sheet in VBA

Theoretical: Worksheet Object
06:21

Range object is the most used object in VBA programming, get in touch with it and learn the most used methods and properties

Theoretical: Range Object
11:41

See what are the prerequisites for this section and where to start coding. Also, you will dive into this section with the copying the information into clipboard.

Code: Copy Range Values
13:34

Learn how to paste the information copied in the previous video

Code: Paste Range Values
09:55

See how the final solution looks like

Final Solution
02:00

This part was created to help you improve your knowledge and to explore by yourself all the possibilities.

Section Test
00:55
+
Excel functions in VBA and UDF (User Defined Formulas)
8 Lectures 47:42

See what are the prerequisites for this section

Initial Setup
03:41

Learn how to create your tailor fit functions. In this video you will take care of the "Get_Item" Function

Code: Create "Get_Item" Function
12:56

Learn how to create your tailor fit functions. In this video you will take care of the "Get_Date" Function

Code: Create "Get_Date" Function
03:33

Learn how to create your tailor fit functions. In this video you will take care of the "Get_MonthName" Function

Code: Create "Get_MonthName" Function
03:48

Learn how to create your tailor fit functions. In this video you will take care of the "Get_Price" Function

Code: Create "Get_Price" Function
05:59

Learn how to create your tailor fit functions. In this video you will take care of the "Get_Discount" Function

Code: Create "Get_Discount" Function
09:45

Learn how to create your tailor fit functions. In this video you will take care of the "Get_Quantity" Function

Code" Create "Get_Quantity" Function
06:04

Complete Solution And Section Test
01:56
+
User friendly AutoFilter
6 Lectures 30:45

Learn what Form Controls are, where to find them and how to use them.

Theoretical: Form Controls
02:35

See what are the prerequisites for this section

Initial Setup
04:03

Fill the dropdowns with the information that the user needs

Code: Fill Comboboxes With Data
06:21

Filter the database based on what the user has selected

Code: Filter Data In Database
08:52

See how you can bring the filtered information to the user

Code: Copy Information To Filter Sheet
06:43

This part was created to help you improve your knowledge and to explore by yourself all the possibilities

Complete Solution And Section Test
02:11
+
Excel Comments Redefined With VBA
4 Lectures 26:53

See what are the prerequisites for this section

Initial Setup
01:24

Learn how to add or remove Excel cell comments

Code: Manipulate Excel Comments With VBA
13:13

Excel comment box hasn't changed a bit since forever, see how to change the appearance of your comments

Code: Style Your Comments With VBA
11:09

This part was created to help you improve your knowledge and to explore by yourself all the possibilities

Complete Solution And Section Test
01:07
+
Highlight Row and Column of Selected Cell using VBA
4 Lectures 22:04

Learn what Worksheet Events are, where to find them and how to use them

Theoretical: Worksheet Events
08:18

Highlight the selected row using VBA

Code: Highlight row
06:15

Highlight the selected column using VBA

Code: Highlight column
06:11

This part was created to help you improve your knowledge and to explore by yourself all the possibilities

Complete solution and section Test
01:20
+
Interactive Chart
5 Lectures 13:39

See what are the prerequisites for this section

Initial Setup
01:42

Insert a chart based on the pivot table

Insert the chart
01:38

Add the combobox and fill it with unique values with the help of a simple trick

Code: Setup the combobox
04:26

Learn how you can update the chart based on the selected drop-down value

Code: Bind the combobox to the chart
04:44

This part was created to help you improve your knowledge and to explore by yourself all the possibilities

Section Test
01:09
+
Send email from Excel using VBA
7 Lectures 14:33

Learn what a reference is and how to link Excel and Outlook togheter

Theoretical: Add Outlook reference in VBA
01:35

See how you can create an email from VBA

Code: Create Outlook and Email objects
01:54

Learn how to set the recipients (To, CC, BCC) and Subject of the email

Code: Set email recipients and subject
03:57

Learn how to add the email body and what options are there for customizing the text

Code: Create email body
03:47

What if you would need to add some files to your email? Learn how to do this

Code: Add attachments
01:05

See what you can do with the email once you created it.

Code: Display/Save/Send the email
01:29

This part was created to help you improve your knowledge and to explore by yourself all the possibilities
Section Test
00:46
+
Create a feedback form
7 Lectures 16:56

Learn what an UserForm is and how to customize it to fit your needs

Theoretical: Worksheet Events
02:12

Learn about the control properties and where to find them.

Theoretical: Properties window
02:36

See what are the prerequisites for this section
Initial Setup
02:09

See how you can extract the information from the UserForm

Code: Send information from the TextBoxes
02:45

See how you can extract the information from the UserForm
Code: Send information from the ComboBox
02:36

Learn how you can control what the user is adding to your form

Code: Sanitize the input
04:05

This part was created to help you improve your knowledge and to explore by yourself all the possibilities


Section Test
00:33
1 More Section
About the Instructor
Sisu Alexandru
4.3 Average rating
16 Reviews
1,109 Students
1 Course
Senior developer | Excel and VBA Expert

I am a senior software engineer with a background in Mathematics and Computer Science. 

As a developer I started working with Microsoft Office Visual Basic for Application building macros in Excel. In my 3 years in which I've interacted with VBA, I've worked on numerous projects from concept to completion starting from simple, several lines macros, up to projects along side multiple developers that extended up to several months.

Dragos Stefanescu
4.4 Average rating
1,028 Reviews
20,192 Students
15 Courses
Founder at TeacHack.com |15 Udemy Courses & 15,000+ Students

About Me

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach.

I have a wide array of skills that I share with you via my courses

(1) Social Media

One of my true passions, I have invested a lot of time building a presence online. Highlights include:

  • Creating a connection base of 100+ people in a large Management Consulting firm within weeks of starting the job.
  • Met with a handful of Managing Directors & Senior Managers after approaching them on Social Media
  • Trained Partners on how to effectively make use of LinkedIn & Twitter to network and generate leads
  • Conducted Workshops with Project Teams and Small Enterprises on the use of Twitter and LinkedIn
  • (2) Resume/CV & Interviewing

With 30+ Job applications, I have gained a deep understanding of the recruiting process

  • I have never failed to get an interview (phone or face-to-face) after submitting my Resume
  • Participated in over 20 Job Interviews & Assessment Centres
  • Worked for a leading Management Consulting firm in a highly competitive market
  • (3) Productivity
  • Heavy user of Microsoft Excel & PowerPoint. I completely rebuilt the spreadsheets inherited from one of my teams, reducing the monthly updating time by over half the time (a few business days)
  • Co-produced reports that were ultimately held by members of the Board of Directors in one of the Multinationals I worked in (using Excel & PowerPoint)
  • General productivity freak, I love technology and always look for ways to make it work for me

How I got here…

Until recently I never really envisioned myself starting my own business. In fact, it was quite the opposite - my dream was to work for a large Multinational/ Consulting company and enjoy the riches of the Corporate life…

I soon found myself in what I thought would be my "dream job" only to do work that wasn't at all fulfilling, spending hours every day commuting and paying enormous rent (almost half of my salary) in one of the largest cities in the world. I felt stuck, limited and didn't think much of my future prospects.

I look back now and find it funny how at our lowest points we make life-changing decisions. Since a few members of our Mastermind Group had launched online businesses, I decided I would give it a try. I made up my mind that whatever happened, I absolutely HAD to launch an online product before my birthday.

Within two months, I launched my first Udemy course.

One month later I decided to quit my job (to the utter amazement of my colleagues, managers, friends & family - they probably thought I was crazy) and never looked back since.

My Goal

What I aim for is simple: I want to get you real results in the fastest possible time. Whether it's improving your presence on Social Media, getting your dream job, improving your productivity or self-development, I want you to walk away from my courses with a sense of achievement.

The courses I create are structured in a step-by-step manner so that you can implement them straight away. They do require your effort & commitment, but if you do that I'm extremely confident you can get to the next level.

Ultimately, receiving a message from a satisfied student detailing how I've helped him or her is immensely gratifying, more so than any number of sales.

Get in touch!

If you're one of my students and you want to ask me a question, or you're just reading this now and think we might have something in common then post a discussion item on one of my courses - I'll be more than happy to answer & get to know you better!