fbpx

Excel VBA Online Course

Learn Excel VBA i.e. Programming Language with a practical approach
If you want to be a master in Excel VBA Programming language for Excel 2007, then our Excel VBA macros tutorials will make it easier for you to access it in Microsoft office application. Come create your own Macros and rule in excel.

  • Video Lessons = 129+ (8 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Here’s the level of the course:

Intermediate Skills

Able to implement techniques at work
  • Using Loops
  • Optimizing Code Efficiency
  • Using Event tracking 
  • Creating Userforms
  • Recording Macro button

Advanced Skills

Ninja-Level Skills
  • Creating User-defined functions
  • Mini Projects: Split, Protect-Unprotect, Automate Comment Extraction
  • Final Project: Corporate Travel planning Project (involves: advanced user forms and Email Automation)

Watch Free Lessons on Excel VBA

Excel VBA Macro basics

 

Excel VBA Macro basics

 


Excel VBA Macros Tutorial Online


 


What Will I Learn?

 Learn how to automate Advanced Excel Macros in daily routine
 Learn how to put Excel on AUTOPILOT
 Will be able to take Excel Automation tasks for self as well as client
 Automate your work and the work for others
 Learn how to record and run Excel Macros in detail
 Learn to use Google search to automate your tasks without coding
 Learn OBJECTS, PROPERTIES & METHODS in Excel Macros
 Learn to Color the code and Activating Edit Toolbar with Comments in Excel VBA Programming
 Understand RANGE & CELLS OBJECT in Excel VBA Macros
 Learn ABSOLUTE vs RELATIVE REFERENCE in Excel VBA Programming
 Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon

 Learn RANGE NAVIGATION in Excel Macros
 Learn Variable Declaration in Excel VBA Programming
 Learn how to Loop in Excel VBA
 Learn how to OPTIMIZING EXCEL VBA CODE EFFICIENCY
 Learn what is Events in Excel Macros
 Learn how to make Input Box and Message Box in Excel VBA Programming
 Learn how to Insert button under Developer Tab
 Learn how to make User Form in Excel VBA
 Learn what is UDF in Excel VBA Programming
 Won’t waste time in manipulating and repetitive formatting
 Use my excel file to send emails automatically (basically communicate with different tools)

What do TOP Excel Bloggers think about my course…

Big Peoples Reviews

Learner Testimonials

I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

peter-kuluberg-excel
Peter Klugsberger
ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies

Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!

barbara
Barbara Jones
Finance Professional

I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course

Placeholder
Peter Thomas
Accounting Professional

GET ACCESS TO THE EXCEL VBA COURSE

Module 1: WARM UP – 10 MIN

Picture11 Excel VBA Module

With this Module, you’ll learn the Beginner level of tricks required to make any Presentation. You’ll get a proper Guidance on how to select and play right with the Colors and Pictures in a Presentation.

✔ Quick Tour for Beginners
✔ Slide Background (Color & Picture)
✔ Slide Header N Footer
✔ QAT and Alt Key tricks

Module 2: RECORD AND RUN MACROS – 20 MINS

Excel VBA Module 2

With this Module, you’ll learn what you gain if you run record your own Excel Macros. You even get to learn how to Record and Run Macros.

✔ Macros – Record & Run
✔ Macros – Viewing the code
✔ Macro-free vs. Macro-enabled Workbook
✔ Visual Basic Editor (VBE)
✔ Personal Macro WB
✔ Ways to Run a Macros

Module 3: GOOGLE YOUR VBA CODES – 19 MINS

With this Module, you’ll learn the magic words you need to Google to get the VBA Code right. The technique that can be used to Customize the Macro Code.

  • Using Google to locate useful VBA codes – 1
  • Using VBE and Macro Recorder to customise Macro code
  • Using Google to locate useful VBA codes – 2

Module 4: OBJECTS, PROPERTIES, METHODS – 4 MINS

With this Module, you’ll learn about Objects and their Properties. Most of the programming languages today are Object-Based and these are mainly Object-Oriented Programming Languages. You’ll learn how these are used coupled with methods of Excel.

  • Objects, Properties, Values, Methods and Parameters 1
  • Objects, Properties, Values, Methods and Parameters 2

Module 5: WORKSPACE INTERFACE – 13 MINS

With this Module, you’ll learn that a workspace factory object can be a lot useful in creating new Workspace. Learn about the various editing methods to edit tools bars in Excel VBA.

  • Code Color & Activating Edit Toolbar w. Comments
  • Edit Toolbar – Indent, Bookmark
  • Code writing shortcuts incl. Intellisense
  • Testing the Code
  • Immediate Window 01

Module 6: RANGE & CELLS OBJECT – 26 MINS

With this Module, you’ll learn How to use the Cell Property to select a Range. And that making use of Cells is actually useful when you wish to loop through ranges. You’ll learn about the different Range and Cell objects.

  • Range Selection – Method 1
  • Range Selection – Method 2 & 3
  • Advantage of Range Selection – Method 2 & 3
  • Range Selection (Rows & Columns) – Method 4
  • Assigning values to selected range of cells
  • Exercise 1 – Assigning values to selected range of cells
  • Exercise 2- Assigning values to selected range of cells
  • Multiple Range Selection – Method 5
  • Multiple Range Selection – Method 6
  • RangeSelectionWays – Others

Module 7: ABSOLUTE VS RELATIVE REFERENCE – 5 MINS

With this Module, you’ll learn that while you record a cell could be made relative if there is a need to start Position or the absolute Address. Compares relative and absolute referencing while recording Excel VBA Macros. 

  • Offset – Basics
  • Using Relative Reference in Macros

Module 8: RANGE NAVIGATION – 15 MINS

Picture8 Excel VBA Module

With this Module, you’ll learn one of the best and common use object that is the Range object. You’ll learn about Navigation in between a Range of Cells.

  • Navigating between a Range of cells – Part 1
  • Navigating between a Range of cells – Part 2
  • Navigating between a Range of cells – Part 3
  • Exercise – Finding Last Row No.
  • Exercise – Finding Last Column No.
  • Exercise – Finding Next Row No.

Module 9: VARIABLE DECLARATION – 20 MINS

With this Module, you’ll learn Variable Declaration. Variable Declaration helps the Macro to run Faster. It helps to use the memory effectively.

  • Variable Decl 01
  • Variable Decl 02
  • Pvt vs Public 01
  • Pvt vs Public 02
  • Option Explicit
  • Difference – DIM vs. SET

Module 10: LOOPS – 52 MINS

With this Module, you’ll learn about loops in VBA. Looping is known as one of the most Powerful Technique of Programming. 

  • “For…Next”
  • “If…Else…End If” nested within “For…Next”
  • “Do…While”
  • “Do…Until”
  • “For Each…Next”
  • “If…End If” nested within “For Each…Next”
  • Exercise – “Do While” and Loop Counter”
  • With…End With” – Example 1
  • “With…End With” – Example 2
  • “Select…Case” – Demonstration
  • “Select…Case” – Explanation

Module 11: OPTIMIZING CODE EFFICIENCY – 8 MINS

With this Module, you’ll learn The Technique to Speed up the Slow Excel VBA.  You’ll get the information to optimize VBA Code to speed up the running of Macros.

  • Speed up the code running – 1
  • Speed up the code running – 2
  • Speed up the code running – 3

Module 12: EVENT TRACKING – 37 MINS

With this Module, you’ll learn about tracking all the events in VBA. For example, if a user ever changes the selection. Also, tracking the Worksheet changes of event.in Excel VBA. 

  • Introduction
  • Events – Workbook_Open and Worksheet_Activate
  • Exercise 1 – Tracking Workbook Opens
  • Exercise 2 – Tracking Workbook Save
  • Event – Worksheet_BeforeDoubleClick
  • Event – Worksheet_Change
  • Event – Worksheet_Calculate
  • Pivot Table – Refresh – WorkSheetActivate

Module 13: INPUT BOX – 23 MINS

With this Module, you’ll learn to use the INPUT BOX function in Excel VBA to initiate the Users in putting their input.

• Introduction
• Input Box – 1
• Input Box – 2
• Input Box – 3
• Input Box – 4

Module 14: MSG BOX – 16 MINS

With this Module, you’ll learn about the MSG BOX which is a Dialog Box in Excel VBA. You’ll learn to use the MSG BOX to inform users about your program.

  • Introduction
  • MsgBox – 1
  • MsgBox – 2
  • MsgBox – 3
  • MsgBox – 4

Module 15: ACTIVEX CONTROLS – 8 MINS

With this Module, you’ll learn to create ActiveX Controls in VBA. It helps to Overview Forms and even in Form Control.

  • Form Controls vs ActiveX Controls
  • MouseMove Event w. Appln Statusbar

Module 16: USER DEFINED FUNCTIONS – 17 MINS

With this Module, you’ll learn to make your own Functions. These Functions are called User Defined Functions. These are the Customize Excel Functions. These Codes allow you to take code from VBA and Rewrite it.

  • UDF Intro 001
  • UDF Example 1 – Score Result with IF END IF
  • UDF Example 2 – CellComments
  • UDF Samples – Series A
  • UDF Samples – Series B

Module 17: USER FORMS – 74 MINS

With this Module, you’ll learn to create USER FORMS, this is helpful in making the User’s Data Entry Controllable. User Form helps the users to use data Easily.

  • Introduction
  • User Form – Basics
  • Exercise – Part 1 of 4
  • Exercise – Part 2 of 4
  • Exercise – Part 3 of 4
  • Exercise – Part 4 of 4
  • Option Button – 1
  • Option Button – 2
  • Multi-Page – Introduction
  • Multi-Page – 1
  • Multi-Page – 2
  • Multi-Page – 3
  • Check Box 001
  • Combo Box – Method 1
  • Combo Box – Method 2

Module 18: MIS PROJECTS – 40 MINS

With this Module, if you’re a motivated individual then you’ll learn various Advanced Excel VBA Techniques while taking VBA MIS Training.

Module 19: REAL LIFE PROJECT – 91 MINS

With this Module, you’ll learn Combining WSheets, this is explained with Real Life Projects.

  • Combine WSheets

Start Learning Today

No Frills

Free Course Lessons

$FREE
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
WATCH NOW
No Frills

Lifetime Access

129+ Course Lessons
$48
  • 129+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

All Courses

Unlimited Learning [All YL Courses]
$297
  • 177+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Looking for subscription plan? Get All Courses in $39/mo: Enroll Now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

30 days money back gauarantee

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.

how-it-works

This Excel VBA Course is for you if...

✓ If you have doing repetitive tasks i.e. making reports, dashboards or slides and looking for ways to automate your task.

✓ If you’ve been dealing with reports from ERP system and apply the same formulas each time to generate the results.

✓ If you want Excel to talk on cross-platforms with other Microsoft applications

✓ If You want to use Excel for complicated & demanding tasks.

✓ If you want to create worksheet object, merge the data from various sheets and do heavy calculations.

✓ If you want to create your own small programs beneficial to perform tedious tasks for excel and want to be a master at programing language. With the help of Visual Basic for Application i.e. VBA, you can also create range object in Excel

This Excel VBA Course is not for you if...

✓ Your usage of Excel is pretty simple or you use it rarely [I love you guys, but this course will not help you]

✓ If you do not like formulas and hate calculations and coding.

✓ Your level of expertise for Excel is less than Basic (You are not aware of the terms of data cleaning technique, Vlookup, filter, sort and cell referencing)

✓ Anyone who wants an instant result and wants to join the course without taking any action in practicality and won’t practice the working files on regular basis.

✓ If you’re not that person who understands programming and neither you’re interested to learn about it.

✓ If you’re not loaded with data management tasks and do not need to perform complicated and heavy calculative tasks in your everyday life.

FREQUENTLY ASKED QUESTIONS

How do I enroll for the Excel Visual basic for Applications tutorial?

Its simple to enroll for this VBA stands for a Visual Basic application or Excel VBA tutorial. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
– Visa/Master Card credit card
– Through PayPal

What do you get in this Excel VBA Tutorial?

  • An accelerated, Practical approached program to teach you
  • All VBA case studies related to videos and create simple macro
  • Access to all videos 24 x 7 – learn online from anywhere
  • Learning VBA will help you to understand Line of Code
  • A 30-day money back guarantee (we want you to be 100% satisfied)

Do I will get Excel VBA Course Completion Certificate ?

Yes, we offer course completion certificate after you successfully complete the training program.

What will I be able to do after completing this Excel tutorials?

✓ Won’t waste time in manipulating and repetitive formatting

✓ Use my excel file to send emails automatically (basically communicate with different tools)

✓ Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon

How Much time to complete this excel vba tutorial for beginners?

This is a fast-paced, lean program of about 10 hrs 22 mins with videos around the programming language from basics to advance and case study. Watch the preview video to get a flavor the program’s uniqueness and relevance.

What if I’m unhappy with my course? Do I get a refund?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.

What if I have doubt or question?

This course entitles you for a lifetime support. Just send us your questions from your registered email address to [email protected] and we will back to you as fast as we can.