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 always be related to Excel, it could be anything.
I am sure that we all know a few Tips and Tricks which make our day-to-day life easy. So let’s start sharing them and make a HUGE repository of Tips and Tricks.
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 to solve, which can save some...
Regular Expression and its usage in Excel VBA
Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming....
3 Methods to Comment or Uncomment in Excel VBA
Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate-level users also do not know about all...
Top 4 VBA Methods to Export Excel data as CSV File
In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA. Did you...
Image in Signature not Displayed – Mail Sent by VBA
Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are...
What if you do not have internet ??
Wait.. this is supposed to be an Excel Blog.. right? Then why such article here? Am I going to discuss about this biggest problem of the World ;)...
Windows FileDialog to Select File or Folder Path in VBA
Dear friends, In my many Excel Tools, wherever there is a need for a file path to be entered from your local PC, I try to put a browse button to...
Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]
Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my...
[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel
Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, and tricks that...
Button to Zoom in a Graph in Excel – [Method 2]
Hello Friends, How are you doing? I am back with my next article about "how to make a button to zoom-in and zoom-out a graph in Excel VBA". this is...
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...
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance...
UDF to Convert Numbers to Letters
First of all, wouldn't it be great if we have a built-in function in Microsoft Excel to Convert Numbers to Letters? It...