Excel VBA: A Starter's Guide for Non-Programmer
4.1 (9 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.
623 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA: A Starter's Guide for Non-Programmer to your Wishlist.

Add to Wishlist

Excel VBA: A Starter's Guide for Non-Programmer

Learn how to Google search complex VBA codes, identify the relevant ones, customise & execute them to automate tasks.
4.1 (9 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.
623 students enrolled
Last updated 5/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn from the Pro - a Professional Corporate Trainer (PwC, EY, RBS, Tata Group, XLRI etc.)
Get Course Completion Certificate
Get Downloadable Case Studies [mapped to the Lectures]
Learn Basic to Intermidiate skills on Activating Macro Tab, Know How of Macro Security Setting, Developer Tab Essential Buttons, Head & Tail of Macros,Record & Run, Ways to Run Macros, 3 Magic Word Technique to Find and Use Macro (without Programming Know How
View Curriculum
Requirements
  • Course works on all Excel versions 2003, 2007, 2010, 2013, 2016
  • Pre-requisite: Basic knowledge of Excel
Description

I am not a Programmer. Why should I learn Macros?

Firstly, you don't need to be an Excel Guru to take this course, just average Excel skills will do. It's adjusted for first-time users. Secondly, it will benefit you in automating your Excel work. It saves time and improves efficiency.

But I have heard from colleagues that it takes a lot of time (weeks and months) to actually implement the solutions and benefit from it.

This is what one of our students had to say in context of this-

“I am new to VBA and your index page macro has helped me want to learn more about VBA. I know you didn’t write the macro, but the technique of copy and paste into excel and then adjusting to accommodate the excel macro has helped me a lot.” Dave Wilson, Saint Helens, United Kingdom 

----------------------------------------------------------------------------------------------------------------

Your Question - Why should I take this mini-course on Excel VBA?

Unlike text-book approach, these videos quickly explain the super essentials and actionable steps to get started with Macros - practically. You will learn:

  • Essential pre-requisite Settings (Developer tab, Security, File extension etc.)
  • Head (start) and Tail (end) of a Macro code for easy identification
  • Understanding the nut and bolts of the workspace and key-buttons.
  • Record and ways to Run a Macro; Viewing the code
  • Understanding the VBA workspace - VB Editor, Project Explorer, Properties Window, Module etc.
  • Personal Macro Workbook

A beginner, as well as an advanced user of Macros, must know a specific trick to locate relevant Macro codes through Google search. You will learn:

  • A special trick to using Google to locate VBA codes relevant to your work
  • Custom edit the code using record technique and VB Editor

We have 16 videos of duration 1 hr in this course.

------------------------------------------------------------------------------------------------------------------

“I thought you knew me - You solved the exact problem which I face at my office in your course” by Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.

-------------------------------------------------------------------------------------------------------------------

Your Question – So will I learn Loops, User Forms & Validations?

Our Response – No. This course covers Activate Macro Tab, Know How of Macro Security Setting, Developer Tab Essential Buttons, Head & Tail of Macros, Record & Run, Ways to Run Macros, “3 Magic Word” Technique to find relevant VBA codes from Google, identify and use them without Programming Know How.

------------------------------------------------------------------------------------------------------------------

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice – over 9 workbooks included  for immediate practice 
  • Access to all videos 24 x 7 - learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied) 

---------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 1 hr. to learn the techniques to implement VBA Codes (Macros) with zero programming know how.

Who is the target audience?
  • Course is purely focussed on helping you achieve skill in Excel VBA to work without programming knowledge
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 17 Lectures Collapse All 17 Lectures 57:11
+
Basic of Excel VBA (Macros)
7 Lectures 18:05

Before we begin learning about Macros, you must understand how can it benefit you in automating your work. We share some examples which demonstrates how it saves time and improves effeciency.

Preview 04:17

Turn ON the Developter tab if you want to create a macro, user forms or insert controls.

Preview 02:02

Learn about the file extension that is used to save Macro-enabled Workbook. Bonus Tip: Turn ON the "Control Panel" setting to view a file's extension. 

Learn to save a Macro-enabled WorkBook (XLSM)
02:53

Learn more about the various Security Settings of Macros and choose the right one for you.

Know-How of Macro Security Settings
02:13

Become familiar with the key buttons on Developer tab.

Developer tab - Essential Buttons
00:54

Learn the essential basic about a Macro Code i.e. Head & Tail of a Macro (Sub Procedure & User Defined Function)

Head and Tail of a Macros (Sub Procedure and User Defined Function)
04:00

Learn how a Form Control (Button) can be created. The button will be associated with a Macro to run it.

Click Here button to run a Macros
01:46
+
In Action
6 Lectures 20:07

Learn the basics of Recording a Macro and running it thereafter.

Preview 05:07

Learn a quick way to view a Macro's code.

Macros - Viewing the code
02:41

Macro free Workbook (.XLSX) wil not save your Macros codes for future use. Use Macro-enabled Workbook (.XLSM).

Macro-free vs. Macro-enabled Workbook
00:55

Understanding our VBA workspace - Visual Basic Editor, Project Explorer, Properties Window, Module

Visual Basic Editor (VBE)
03:18

Understanding the concept of storing a Macro in Personal Macro Workbook

Personal Macro WB
05:20

Learning the various ways of running a Macro code

Ways to Run a Macros
02:46
+
3 Magic Words - KickStarter Guide for Non Coder to Excel VBA (Macro)
3 Lectures 18:57

Using Google to locate a VBA code to create index of links to all worksheets in a workbook.

Using Google to locate useful VBA codes - 1
07:42

Using VBE and Record Macros to custom edit a Macro code

Using VBE and Macro Recorder to customise Macro code
04:46

Using Google to locate a VBA code to insert rows based on cell values

Using Google to locate useful VBA codes - 2
06:29
+
Downloadable Practice Files
1 Lecture 00:02
Practice Excel files
00:02
About the Instructor
Yoda Learning
4.2 Average rating
1,091 Reviews
31,689 Students
42 Courses
Become 4X Faster | Join 32000+ Udemy Students

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based"learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.4 Average rating
385 Reviews
8,277 Students
26 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.