Excel VBA Tutorials

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.

What’s covered in the Excel VBA Tutorial

Learn Excel VBA Tutorial onlineStars_Resize4.5 (452 ratings) 1,544 students enrolled

 ‘VBA’ for your knowledge stands for Visual Basic for Applications which is even known and called the Programming Language for Excel. It might amuse you to know that you can now copy multiple data from various sheets into one fresh sheet just by using VBA techniques. You need not to be an Excel king or any coding Guru to be able to automate and simplify multiple tasks on Excel but we guarantee you that this feature of Excel VBA tutorials is going to make you an addict in creating your own Excel Macros use command buttons and have the VBA command with our VBA learning techniques. If you learn Advanced Excel VBA you get to create custom functions for your application and you can even have the knowledge about VBA for dummies.

Intermediate Skills

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

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)

Excel VBA Tutorial

You don’t have to pretend that you’re satisfied with our work. If our tutorials have helped you we are more than happy. Customer satisfaction is what we are looking for. But in case, if you’re not satisfied then contact us anytime in the next 30 days of your enrollment period. We will refund your money.

30 Days Money Back Guarantee

Full 30 Day Money Back Guarantee No Questions Asked

100% Secure Checkout

Verified & Secure Checkout. Pay Via Credit Card or PayPal

Free Lessons

If you’re planning to make use of Excel in your job then VBA is one feature that you need to learn right now. Learn VBA from our Excel VBA Tutorials and ask the company to recruit you and your bosses to promote you if they want the work to be done in a smarter way over harder way

Our Excel VBA Tutorials contain the course that is going to help you to prepare Excel Spreadsheets and will make you an expert in automating and customizing different processes in Excel through VBA coding. It uses the various Range objects, Excel Models, worksheet object and ranges to manipulate and control the applications. Furthermore, the students will be exposed to the different programming constructs and techniques in handling data from the worksheet.

Learner testimonials

  • I would like to tell you that I am very impressed with your excel 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
  • Dear Rishabh, I am a subscriber to Excel VBA course on your training site – Yoda Learning. And, I am amazed by your style of teaching and making complex subject of VBA very easy. I feel more connected with your courses as they are result oriented and I think that is mainly because of your CA and industry background.

    Placeholder
    Rishikesh Joshi
    CFO
  • 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.

    barbara
    Barbara Jones
    Financial proffesional
learn excel online for free

We’ve helped these COMPANIES

with exact strategies and techniques used in this course

Professionals at gulf are using advanced excel tutorials to become faster & better at workProfessionals at bajaj finserv are using advanced excel tutorials to become faster & better at workProfessionals at bosch are using advanced excel tutorials to become faster & better at workProfessionals at Pxf housing are using advanced excel tutorials to become faster & better at workProfessionals at icici bank are using advanced excel tutorials to become faster & better at workProfessionals at kpmg are using advanced excel tutorials to become faster & better at work

Professionals at microsave are using advanced excel tutorials to become faster & better at workProfessionals at polyplastics are using advanced excel tutorials to become faster & better at workProfessionals at shairu gems are using advanced excel tutorials to become faster & better at workProfessionals at snapdeal are using advanced excel tutorials to become faster & better at workProfessionals at tata power are using advanced excel tutorials to become faster & better at workProfessionals at verizon are using advanced excel tutorials to become faster & better at work

 

Course Curriculum

Macro Basics and Developer Tab - 18 mins

  • Why learn Macros?
  • Activate “Developer” tab
  • Saving a Macro-enabled WorkBook (XLSM)
  • Macro Security Settings
  • Developer tab – Essential Buttons
  • Head & Tail of a Macros (Sub Procedure & User Defined Function)
  • “Click Here” button to run a Macros

Record and Run Macros - 20 mins

  • 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

GOOGLE your VBA codes - 19 mins

  • 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

OBJECTS, PROPERTIES, METHODS - 4 mins

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

WORKSPACE INTERFACE - 13 mins

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

RANGE & CELLS OBJECT - 26 mins

  • 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

ABSOLUTE vs RELATIVE REFERENCE - 5 mins

  • Offset – Basics
  • Using Relative Reference in Macros

RANGE NAVIGATION - 15 mins

  • 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.

VARIABLE DECLARATION - 20 mins

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

LOOPS - 52 mins

  • “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

OPTIMIZING CODE EFFECIENCY - 8 mins

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

EVENT TRACKING - 37 mins

  • 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

INPUT BOX - 23 mins

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

MSG BOX - 16 mins

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

ACTIVEX CONTROLS - 8 mins

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

USER FORMS - 74 mins

  • 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

USER DEFINED FUNCTIONS - 17 mins

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

MIS PROJECTS - 40 mins

  • Split Workbook
  • Protect – Unprotect Sheets
  • Index of Hyperlinks to all Sheets
  • Extract all Comments of a WBook to a new W Sheet
  • Project_Automate Comment Insertion and Extraction
  • Count Cells by Colors
  • Combine W Sheets

REAL LIFE PROJECT - 91 mins

  • Combine WSheets

Start Learning Today

No Frills

[No Frills] Lifetime Access

129 Course Lessons
$29
  • 129+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Lifetime access

[Premium] Lifetime Access

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

    Office Training Bundle

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

    Don’t have a Credit Card? Click here
    Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

    Course Completion Certificate By Yodalearning

    Unlock your completion certificate

    • Complete any premium course at Yoda Learning Solutions
    • You are awarded a completion diploma
    • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

    For Enquiry About Courses? Contact Us:
    [email protected]
     +1- 203-349-9909

    Feel free to call us for any query related to courses. Our support team will resolve your issue.

    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 spreadsheets, 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.

    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 Ask Questions

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

    Its simple to enroll for this 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
    – Don’t have a Credit Card? Click here

    What do you get in this Excel VBA Tutorial?

    • An accelerated, Practical approached program to teach you
    • All VBA case studies related to videos
    • Access to all videos 24 x 7 – learn online from anywhere
    • A 30-day money back guarantee (we want you to be 100% satisfied)

    Is There 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.