Excel Macro Tutorial Archives

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

Invoice Template [ FREE Download ]

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips, Popular Articles

Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my...

VBA Beginners: How to write macro for a Command Button

Excel Macro Basics, Excel Macro Beginner, Excel Macro Tutorial

Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3...

Excel Tip: How to refer characters using ASCII Value

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips

Hello friends, In this article, I am going to explain you, how can you use special characters in Excel VBA and formulas without breaking the syntax. For Example: You can not use double quote or any other Special Characters, which are generally a part of Formula...

Excel VBA Tips: How to comment or uncomment a Block of Code in VBA

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips

Dear Friends, Providing proper short descriptions for each of your functions or statements etc. makes your VBA code - easy to read, easy to understand by anyone who refers your code. Now the question is, how can you write description in English language in between...

Excel VBA Basics : All about Debugging Excel VBA code

Excel Macro Basics, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips

Dear All, In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is...

Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial

This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this...

Complete VBA tutorial to interact with Power point Presentations – Part – 1

Excel Macro Tutorial

[fusion_text] ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so...

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