EXCEL VBA MACROS

Learning to code isn’t “Hello World”. Go beyond. Learn to automate Excel reports using our non-text book approach. 90% Practical and 10% Theory.

This Course includes:

Nip_Fab_testimonial_page_1.png
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”

Course Curriculum

0101 – Why learn Macros?
0102 – Activate the “Developer” tab
0103 – Saving a Macro-enabled WorkBook (XLSM)
0104 – Macro Security Settings
0105 – Developer tab – Essential Buttons
0106 – Head & Tail of a Macros (Sub Procedur & User Defined Function)

Download Course Curriculum

0201 – Macros – Record & Run
0202 – Macros – Viewing the code
0203 – Macro-free vs. Macro-enabled Workbook
0204 – Visual Basic Editor (VBE)
0205 – Personal Macro WB
0206 – Ways to Run a Macro

Download Course Curriculum

0301 – Using Google to locate useful VBA codes – 1
0302 – Using VBE and Macro Recorder to customize Macro code
0303 – Using Google to locate useful VBA codes – 2

Download Course Curriculum

0401 – Objects, Properties, Values, Methods, and Parameters 1
0402 – Objects, Properties, Values, Methods, and Parameters 2

Download Course Curriculum

0501 – Code Color & Activating Edit Toolbar w. Comments
0502 – Edit Toolbar – Indent, Bookmark 1.5
0503 – Code writing shortcuts incl. Intellisense
0504 – Testing the Code
0505 – Immediate Window

Download Course Curriculum

0601 – Range Selection – Method 1
0602 – Range Selection – Method 2 & 3
0603 – Advantage of Range Selection – Method 2 & 3
0604 – Range Selection (Rows & Columns) – Method 4
0605 – Assigning values to the selected range of cells
0606 – Exercise 1 – Assigning values to the selected range of cells
0607 – Exercise 2- Assigning values to the selected range of cells
0608 – Multiple Range Selection – Method 5
0609 – Multiple Range Selection – Method 6
0610 – Range Selection Ways – Others

Download Course Curriculum

0701 – Offset – Basics
0702 – Using Relative Reference in Macros

Download Course Curriculum

0801 – Navigating between a range of cells – Part 1
0802 – Navigating between a range of cells – Part 2
0803 – Navigating between a range of cells – Part 3
0804 – Exercise – Finding the Last Row No.
0805 – Exercise – Finding the Last Column No.
0806 – Exercise – Finding Next Row No.

Download Course Curriculum

0901 – Variable Decl – 1
0902 – Variable Decl – 2
0903 – Pvt vs Public – 1
0904 – Pvt vs Public – 2
0905 – Option Explicit
0906 – Difference – DIM vs. SET

Download Course Curriculum

1001 – “For…Next”
1002 – “If…Else…End If” nested within “For…Next”
1003 – “Do…While”
1004 – “Do…Until”
1005 – “For Each…Next”
1006 – “If…End If” nested within “For Each…Next”
1007 – Exercise – “Do While” and Loop Counter
1008 – “With…End With” – Example 1
1009 – “With…End With” – Example 2
1010 – “Select…Case” – Demonstration
1011 – “Select…Case” – Explanation

Download Course Curriculum

1101 – Speed up the code running – 1
1102 – Speed up the code running – 2
1103 – Speed up the code running – 3

Download Course Curriculum

1201 – Introduction
1202 – Events – Workbook Open and Worksheet Activate
1203 – Exercise 1 – Tracking Workbook Opens
1204 – Exercise 2 – Tracking Workbook Save
1205 – Event – Worksheet Before Double Click
1206 – Event – Worksheet Change
1207 – Event – Worksheet Calculate
1208 – Pivot Table – Refresh – Work Sheet Activate

Download Course Curriculum

1301 – Introduction
1302 – Input Box – 1
1303 – Input Box – 2
1304 – Input Box – 3
1305 – Input Box – 4

Download Course Curriculum

1401 – Introduction to Msg box in Excel VBA
1402 – MsgBox – 1
1403 – MsgBox – 2
1404 – MsgBox – 3
1405 – MsgBox – 4

Download Course Curriculum

1501 – Form Controls vs ActiveX Controls
1502 – MouseMove Event w. Appln Statusbar

Download Course Curriculum

1601 – Introduction 1.0
1602 – User Form – Basics
1603 – Exercise – Part 1 of 4
1604 – Exercise – Part 2 of 4
1605 – Exercise – Part 3 of 4
1606 – Exercise – Part 4 of 4
1607 – Option Button – 1
1608 – Option Button – 2
1609 – Multi Page – Introduction
1610 – Multi Page – 1
1611 – Multi Page – 2
1612 – Multi Page – 3
1613 – Check Box
1614 – Combo Box – Method 1
1615 – Combo Box – Method 2

Download Course Curriculum

1701 – UDF Introduction
1702 – UDF Example 1 – ScoreResult with IF END IF
1703 – UDF Example 2 – CellComments
1704 – UDF Samples – Series A
1705 – UDF Samples – Series B

Download Course Curriculum

1801 – Split Workbook
1802 – Protect – Unprotect Sheets
1803 – Index of Hyperlinks to all Sheets
1804 – Extract all Comments of a WorkBook to a new WorkSheet
1805 – Project- Automate, Comment, Insertion, and Extraction
1806 – Count Cells by Color
1807 – Combine WorkSheets

Download Course Curriculum

1901 – Case Study- Intro
1902 – Case Study – Demo
1903 – Create the first UserForm
1904 – Write the first line of code
1905 – VBA code to match Username and Password
1906 – Continue with UserForm
1907 – VBA code for the second UserForm
1908 – Unload and Hide UserForm
1909 – Setting of the third UserForm
1910 – Validation for the third UserForm – Part 1
1911 – VBA code to enable a button
1912 – Validation for the third UserForm – Part 2
1913 – VBA code for the third UserForm
1914 – Configuring the Previous button
1915 – Submit Data and hide content in excel sheet
1916 – Capture data from the UserForm
1917 – Create a Table Format
1918 – VBA code to send Email
1919 – Send an Email
1920 – The finishing touch to the project
1921 – Testing the code

Download Course Curriculum

COURSE INSTRUCTOR

Rishabh Pugalia

Course Narrator

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”
Peter Klugsberger - Yodalearning Student
Peter Klugsberger
Mckinsey & Company
“The courses are not only technically very knowledgeable, but also genuinely helpful for professionals who want to work smarter, not harder.”
Karnika Bhalla - Yoda Learning Student
Karnika Bhalla
Delloite
“The training curriculum and course was extremely well designed, thorough and catered to use cases relevant to our domain of work.”
Yoshika Chhabra
Yoshika Chhabra
E & Y

Lifetime Access

Excel VBA Macros for Non-Coders
$ 29
  • 129 HD Videos
  • 8.4 Hours of Video
  • Lifetime Support

30 days Money-back Guarantee

FAQ

DO YOU PROVIDE SUPPORT DURING THE COURSE?

We have a chat panel in every lecture window. You can take screenshots, upload file, and send queries to our support desk. QnA should be related to the case study files ONLY.

WHAT VERSION OF EXCEL DO YOU TEACH?

We use Excel 2013 and we have added all new features up to Office 365.

DO I GET A CERTIFICATE AT EACH LEVEL?

No, you do not get a Certificate at each level. We only provide the course completion certificate.

CAN I DOWNLOAD THE COURSE?

No. But, you can watch the videos unlimited number of times.

CAN I ACCESS THE COURSE FROM MORE THAN ONE COMPUTER?

Yes, you can access the course from only 2-3 devices (computer or mobiles) with your login credentials.

EXPLAIN THE REFUND POLICY.

You can ask for refund within 30-days of enrollment. No questions asked.

FOR ENQUIRY ABOUT EXCEL VBA COURSE? CONTACT US:

[email protected]

IN: +91-7738922884

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