Who am i?
My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
In 2014, I married my Love, Shagun and we are living happily in Amsterdam, Netherlands. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it here.
I developed interesting in learning Python, Data Engineering, AWS Cloud – therefore I decided to share my journey through my blog. Since this domain was very specific to Excel therefore this rebranding is done via a generic domain name.
Recent articles
Recent Articles
Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide
In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365...
How to Declare a Public Variable in VBA
While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the...
How to Copy content from Word using VBA
As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about...
How to connect to Access Database – ADO Connection String
Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. In this Article you will...
Recommended Pages
Recommended Tutorials
Automate sending email via Excel VBA
Enjoy several tutorials and articles for sending email via Excel VBA. You can be able to download some amazing tools as well for sending emails.
User Defined Functions in Excel
Didn't find a formula which you wish to have in Excel? Don't worry, create your own formula to use it in your excel sheets.
Excel VBA tutorial for Intermediate
Some amazing tutorials for intermediate level excel vba learners.
FREE Downloads
Download some amazing tools and templates in order to improve your productivity at work.
Beginner's Page
Excel macro tutorials for beginners. Learn basics to start with your excel vba journey.
HP Quality Center - VBA Codes
Download and read so many amazing piece of vba codes in order to automation HP QC related tasks, reporting etc.
VBA Programming
Learn programming concepts related to Excel VBA with sample code and illustrative images. You will learn here about For Loop, While loop, Do While loop, If else, Switch, etc.
Databases - via Excel VBA
Want to connect to a Database via Excel VBA Code? Run any kind of query like Select, Update, Delete, Insert via Excel VBA? This series of articles will explain you in a very detailed manner.
Want to learn?
What do you want to learn?
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.
Explore VBA & Macros
200+ Articles on Excel Macro/VBA for all kind of users – Beginners, Intermediate and experts. Explore the world of Excel VBA
Free Tools & Templates
Repository of really useful and interesting tools and templates developed in Excel VBA. Download 20+ FREE tools and templates.