Excel Tips

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 few Tips and Tricks which makes our day-to-day life easy. So let’s start sharing them and make a HUGE repository of Tips and Tricks.

Calculate MOD of Large Numbers in Excel

Tags: , |

Excel Trick to Calculate MOD of Big Numbers. This article is all about MOD function in Excel. Every aspect of MOD function is covered here [...]

Regular Expression and its usage in Excel VBA

Tags: , , |

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 [...]

Comments Off on Regular Expression and its usage in Excel VBA

Methods to save a Macro FREE copy of a workbook [FREE DOWNLOAD]

Tags: , , , |

Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a times before sending your workbook with Excel VBA Macro [...]

3 Methods to Comment or Uncomment in Excel VBA

Tags: , , |

Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate level users also does not know about all these [...]

Hide Group outline symbol in Excel – [Manual Option + VBA]

Tags: , , |

Dear Friends, In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently. [...]

Top 4 VBA Methods to Export Excel data as CSV File

Tags: , , |

In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file [...]

Image in Signature not Displayed – Mail Sent by VBA

Tags: , |

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 [...]

What if you do not have internet ??

Tags: , , |

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 [...]

Windows FileDialog to Select File or Folder Path in VBA

Tags: , , , , |

Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I [...]

Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

Tags: , , , |

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 [...]

[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel

Tags: , , , , , , , |

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, [...]