Introduction: Excel VBA (Visual Basic for Applications) is a powerful tool that allows you to automate tasks and enhance your productivity in Excel. With VBA, you can write custom code to perform repetitive actions, manipulate data, and create customized solutions. In...
Results for "text"
Resources
Few of the Best resources available around Microsoft Excel Excel Gurus.. My Favorite.. Bill Jelen: Well known as "Mr. Excel". In a true sense, he is Mr. excel. You're one-stop for Excel Tips and Solutions. Purna Duggirala - "Chandoo" - Chandoo.org If I talk in his...
LearnExcelMacro.com is now VMLogger.com
Dear LEM readers, Learnexcelmacro.com is now vmlogger.com.Other than Excel VBA related articles, now there are much more you will get in this blog. For example, Python, Cloud, Kubernetes, Data Science etc. For now all excel related articles, tutorials can be found...
Excel Tips & Tricks
Dear Friends, Excel Tips and Tricks will probably not be able to make your work SUPER easy but it will definitely make you productive. In this Section, we will be sharing small-small Tips and Tricks which can be used in our day-to-day life. Tips and Tricks must not...
Excel Formulas
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required....
Custom Functions
Microsoft Excel allows us to create our own functions, based on our own needs. Such functions are called “User Defined Functions” (UDFs) or Custom Function. These functions behave exactly like Excel’s inbuilt formulas. These are helpful in simplifying complicated...
Tutorials
Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database...
Downloads
FREE Tools & Templates to DownloadMacro Enabled Tool Distance Calculator in Excel This tool is to show how to use Google API to calculate the distance between two places. It is explained here in this article in detail. Download this Excel tool and learn with fun...
Welcome to my blog
Thanks for visiting this...
About Page
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...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
40 Useful Excel Macro [VBA] examples – Part 1 of 2
Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro...
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...
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...