I hope you are all doing well in this amidst corona pandemic period. As Take care of yourself and near and dear ones. Stay home as much as possible. Take all the precautions suggested by the Health Organizations (WHO, local health orgs, government bodies etc.) when...
Personal
A Personal request and appeal
Dear LEM readers, I hope you are all staying safe and healthy during this Corona Pandemic period and at the same time, utilizing this period to achieve the personal growth goals. I am as well thriving for the same. I feel that we belong to a privileged and blessed...
Corona Virus Map Graphs – Using Web Query in Excel
This post is about how to extract Corona Virus Affected Statistics from https://www.worldometers.info/coronavirus/ in Excel using WebQuery and create your own Graph, metrics etc. Once you receive the data from Internet through WebQuery it is up to you how you want to...
Support !!
Dear Readers, Its been long since I posted any new article or any useful Excel Tools on the website. As you are aware of that all the tools which I publish here are always available to download for FREE. I will continue to do so in future. You can also help me in...
Do you want to be part of my Next article?? … Here you go…
Dear Readers, In my next article, which will be published next Monday, I am going to cover following two topics: 5 Interesting but rarely used features/functions in Excel/Excel VBA 5 Interesting facts about Excel [from history...] Before I publish these articles, I...
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. Recommended Articles and Pages: Beginner's Page: Excel Macro Tutorial Tips and Tricks: Excel Tips and Tricks HP Quality Center: Excel Macros for HP Quality...
[Personal] Wish you a very happy Diwali
Dear readers, Wish you a Very happy Diwali :). Diwali is an Indian festival. It is called festival of lights. On this eve people lights lot of Dias, Candles etc. All the places, houses, shops will be scintillating by all different kind of lights and frills. Like any...
Wish you Merry Christmas & happy Holidays
To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the...
Wishing you and your Family a Very Happy Diwali
Wishing you a very Happy Diwali to you and your family. May this Diwali brings health, wealth and prosperity in your life. May this festival of Lights brings light in each one of your life For my readers who does not know about this festival: This an Indian Festival...
Merry Xmas to you All – 2012
Dear Friends, Wishing you a very very happy Christmas to you all. May God bless you all with tons of happiness and love. Enjoy !! Merry Christmas
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 (=).
Convert PDF Tables to Excel with VBA | Step-by-Step Guide
Convert PDF Tables to Excel with VBA | Step-by-Step Guide How to Convert PDF Tables to Excel Using Excel VBA (Macros)...
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...