Vishwamitra Mishra, Author at Let's excel in Excel

How to create folders in windows via Excel VBA

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial

Dear LEM Readers, Till now, I had published many articles on how to list files from a folder / sub folder,

List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]

Dear Readers, Many of you were looking for a excel tool same as File Manager - which lists down all the files from each and every folders and subfolders, to list down all the folders and sub-folders under a given Main Folder Path. Therefore rather than replying to you...

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

Excel Formula, Excel Macro Tutorial, Excel Tips

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 HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question...

[Personal] Wish you a very happy Diwali

Personal

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

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

Excel Tips, Video Tutorial

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 will be useful for you during the development of any Excel VBA tool. YouTube Channel You can subscribe to VMLogger.com...

[YouTube Video] Complete Guide to Write your First Excel Macro

Excel Macro Beginner, Excel Macro Tutorial, Video Tutorial

Dear Readers, Here is the second episode of the Excel Macro Tutorial for Beginners. If you have not watched the first part of the Tutorial, you can watch it here or on the YouTube Channel. Kindly provide your feedback on this video. Any improvements/ suggestions are...

[VIDEO] Excel Macro Tutorial-Part-1-Introduction to Excel VBA

Excel Macro Beginner, Excel Macro Tutorial, Video Tutorial

Dear Readers, Recently, I realized that Videos/audios are sometimes more easy medium for a blogger like me who is mainly teaching some new things in Microsoft Excel area, to convey the message in a very appropriate way. At the same time, for a reader as well it is...

Button to Zoom in a Graph in Excel – [Method 2]

Excel Macro Beginner, Excel Macro Tutorial, Excel Tips, Interesting VBA Functions

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 the second method I am going to explain you. In my previous article, I had explained about the very basic method. There...

[Video Tutorial] How to add controls like command button in excel [For Beginners]

Excel Formula, Excel Macro Tutorial, Video Tutorial, Videos

Hello friends, I have created a Youtube channel where I am going to share many more recorded video tutorials for beginners, intermediate and advanced users. Don't want to miss any of the videos? Then Subscribe to my Youtube Channel. Subscribe my channel on Youtube Do...

Button to Zoom in a Graph in Excel – [Method 1]

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial

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

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.

Hurray..Lets Go

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 (=).

Know more