Udemy

Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel

Enroll Now
  • 1,318 Students
  • Updated 1/2017
  • Certificate Available
4.4
(45 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
4 Hour(s) 20 Minute(s)
Language
English
Taught by
Sisu Alexandru, Dragos Stefanescu
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.4
(45 Ratings)
1 views

Course Overview

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

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!

Course Content

  • 11 section(s)
  • 59 lecture(s)
  • Section 1 Introduction
  • Section 2 Introduction To VBA and Excel Macros
  • Section 3 Consolidate Data with macro
  • Section 4 Excel functions in VBA and UDF (User Defined Formulas)
  • Section 5 User friendly AutoFilter
  • Section 6 Excel Comments Redefined With VBA
  • Section 7 Highlight Row and Column of Selected Cell using VBA
  • Section 8 Interactive Chart
  • Section 9 Send email from Excel using VBA
  • Section 10 Create a feedback form
  • Section 11 Quickwin

What You’ll 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


Reviews

  • D
    Dom Lim
    2.0

    Too basic

  • M
    Mohammed Yassir Amin
    4.0

    Love the way you are explaining the course. Simple to understand so far

  • F
    Fahmi Eshaq
    5.0

    Excellent productive course that summarizes commonly used tasks in a cohesive easy manner.

  • O
    Osman Ismail
    5.0

    It’s important

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