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...
Results for "graphs"
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...
Write Post and get Paid – Guest Author [ Rs.1000 per Post ]
Dear LEM readers, LearnExcelMacro.com is inviting you to become one of the Guest Author at learnexcelmacro.com. and get paid up to INR 1000 for each article you submit, approved and published. LearnExcelMacro.com does not compromise with the quality of the content...
Button to Zoom in a Graph in Excel – [Method 1]
I wish Microsoft Excel has a built-in feature to Zoom-in and Zoom out a graph made in Excel 🙂 like many other web applications. But not to worry, you can easily create one to simulate the Zoom-in and Zoom out feature on an Excel graph. There are more than one...
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...
Macro to Copy from Excel in to Word Document
In Previous Article we saw how to Copy Content from a Word Document and Paste in in to the Active Workbook. Now in this Article i am going to write a function will Select a Range from Excel and paste the content in a New Word Document. Here there are two possible way...
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 (=).
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...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...