What is Excel VBA? : Excel VBA Basics 001

Excel VBA

Visual Basic for Applications (VBA) in Excel, is a powerful and sophisticated built-in programming language that allows you to write your own functions or commands in an Excel spreadsheet.These custom functions or commands, can help to ease your tasks and thus by using Excel VBA you can do almost any imaginable thing in Excel.Now, before we … [Read more...]

Calculating Weighted Average in Excel

Marks-of-Sutudent-in-5-subjects

The concept of average comes from mathematics, average can be defined as the result obtained by adding several quantities together and then dividing this total by the number of quantities.Usually when we calculate average, we put same weight or priority to each value, this is called un-weighted average.For example, let’s say we want to … [Read more...]

How to Merge and Combine Cells in Excel – Explained

Selected-Cells-Have-Been-Merged

Merging cells in a spreadsheet means taking two or more cells and constructing a single cell out of them. Merging is generally used as a cosmetic trick to center a title over a particular section in a spreadsheet.Below image clearly shows how a merged cell looks like.In this post we will see different ways to merge cells in Excel. But … [Read more...]

Printing Comments in Excel – Few Easy Ways

Sheet-With-All-Comments-Shown

An Excel workbook with comments looks more presentable and easier to understand. But do you know that, by default Excel only allows you to see comments on the screen. In other words, it has made the option of printing comments very inconspicuous.Now, what if you have to print those comments along with your data?No need to worry. In this … [Read more...]

HLOOKUP in Excel – With Examples

How to Use Excel HLookup

HLOOKUP function in Excel is a sibling of VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called as Horizontal Lookup.HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular.The task of HLOOKUP … [Read more...]

Excel DATEDIF Function – Calculate the difference between two dates

How-Excel-hides-datediff-function-from-users

DATEDIF is a hidden function in Excel. As the name suggests the job of this function is to calculate the difference between two given dates.I have referred this function as hidden because, for some reason Microsoft has decided not to document this function. And because of this you won’t find this function in the Formula Tab.To verify … [Read more...]

VBA IF Statement – Explained With Examples

VBA IF Statement

IF is one of the most popular and frequently used statement in VBA. IF statement in VBA is sometimes also called as IF THEN ELSE Statement. The task of IF Statement is to check if a particular condition is met or not.If you have followed my earlier posts, then you would remember that we discussed If Function in Excel. The IF Function in Excel … [Read more...]

Selecting All Checkboxes using a Single Checkbox in Excel

Add the Mixed State Macro in VBA

A few weeks ago, one of my readers left a comment on my blog asking if there is a way to select a bunch of checkboxes using a single checkbox. [Link to that comment]This is not a new issue, when you have a huge form with many checkboxes, it becomes quite cumbersome to select each checkbox individually. And this gives rise to the need of a … [Read more...]

Privacy Policy | Disclaimer | About