B03dicprrghjujtjopag

KickStarter Guide for Non Coder to Excel VBA (Macro)

Learn to use VBA Codes in 30 mins

Requirements

  • Course works on all Excel versions 2003, 2007, 2010, 2013, 2016
  • Pre-requisite: Basic knowledge of Excel

About the course

I am not a Programmer. Why should I learn Excel 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 Excel Macros 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 Macros?

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 3 videos of duration 30 minutes 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.

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

If you have read this far, next action is JOINING this course. Invest 30 min 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


Your Instructor


Yoda Learning
Yoda Learning

We create Data Analytics and Presentation Tricks for Big Four Professionals (KPMG, E&Y, PwC and Deloitte). We offer instructional videos, practice files, and personalized learning dashboards to the learners. This empowers an individual to master use cases of the software at their own pace, anytime and anywhere. We work with industry experts who double up as an award-winning instructor for our courses.


Course Curriculum


  Using VBE and Macro Recorder
Available in days
days after you enroll
  Using Google - Part 2
Available in days
days after you enroll

FAQs


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
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.

Get started now!