Join over 10, 000+ Excel VBA Enthusiasts & get this FREE e-Book Now!


  • Don’t miss any new article, tips, tools, tutrials etc. which I publish.
  • This e-Book is mainly for the Excel VBA beginners
  • 10,000 + Excel enthusiasts has already downloaded it
Download Now


Ask me, I hate browsing hundreds of pages, as much as you do, to find what exactly I am looking for. Category based grouping of articles, tutorials made life so easy to get exact information at exact place. So let’s excel in Excel.

Are you new to Excel Macro?

Are you new to Excel macro and willing to start learning? This is the right place for you to start with. A step by step tutorial for beginners.

Excel Tips, Tricks & Formulas

Learn excel quick tips, tricks and formulas. Learn 60+ most frequently used formulas in excel with examples.

Explore Excel VBA & Macros

200+ Articles on Excel Macro/VBA for all kind of users – Beginners, Intermediate and experts. Explore the world Excel VBA

Download Excel Tools & Templates

Repository of really useful and interesting tools and templates developed in Excel VBA. Download 20+ FREE excel tools and templates.


Learning Excel VBA is made so easy with the help of step by step tutorials for all type of users.Various tutorials with videos, Images, VBA code snippets covering a wide range of topics in Excel VBA. So let’s excel in Excel.

VBA Tutorials for Beginners

A step by step tutorial for beginners. Tutorials with videos, images, VBA code snippets and downloadable excel files with VBA code to practice.

Intermediate & Advanced

Are you aware of basics of programming or VBA programming? If, yes, ake a further step by clicking here and reading my tutorials for intermediate and advanced level users.

Video Tutorial

Reading tutorials are boring?? Not to worry!! Here are my video tutorials. Find many excel VBA video tutorials, tips and tricks.


Other than beginners and intermediate level tutorials, I have some other tutorials like sending email, database connections, HPQC connection, accessing Google API via VBA etc.


Enjoy reading the latest articles published. To receive all the articles directly in to your mailbox as soon as they are published… SUBSCRIBE below .

Validate BurgerServiceNummer (BSN) using Excel VBA

Important Note: This post will make more sense to those who stays in Netherlands. But wait.. even if you do not stay in Netherlands, you will learn some interesting Algorithm!! BSN is [...]

Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]

Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by outlook. Thanks to you all for providing me the prompt feedback about the [...]

FREE Download : Send Multiple Emails Tool – Ver 4.0

Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of your friends a Happy New Year Email for this coming new year [...]

Wish you all a Merry Christmas 2016

Dear LEM Readers, LEM wishes you a Merry Christmas and a very happy Holiday season to you and and your family. Merry Christmas 2016 Recommended Articles and Pages: Beginner's Page: Excel Macro Tutorial [...]

Mr. Vishwamitra
Thank you for such clean and informative website on excel VBA. The content is exhaustive and i can spend all day reading and knowing more about Excel and excel in my work. I would like to see more tools coming up in your Downloads section.
Anil Kulkarni
Very helpful.
PS : Some steps are occasionally left out for learners but really excellent.
thank you very much . Your examples are great .
Thank you, Mr. Viswamitra,

very great work.. it helps me very lot…

Thanks Mr.Viswamitra, all are very great tools for me, thanks for your work…..