NETWORKDAYS Function In Excel


The best thing about Excel is that it gives us a wide variety of options to choose from its functions based on our needs. And today, we are going to have a look at a similar function, i.e. NETWORKDAYS. Using this function in excel you can easily calculate the number of weekdays between two dates. As the name suggests, NETWORKDAYS Function in … [Read more...]

Sum Cells based on Background Color

Table with colored cells

Few weeks back, one of my regular visitors dropped me an email describing an issue that he was facing. His task was to add the contents of certain cells based on their background colors. As we all know, Excel by default has no formula or feature to calculate such a thing. So, in this post I will share few methods that will help you to achieve … [Read more...]

Getting Familiar with VB Editor (VBE) : VBA Basics 002


Now, after having learned what Excel VBA is, let’s move a bit further and see what is VB Editor. VB Editor (or more commonly known as VBE) is the tool used to create, modify and maintain Visual Basic for Applications (VBA) procedures and modules in Excel. NOTE: Many people also refer VBE as Excel IDE, IDE stands for integrated development … [Read more...]

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


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


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


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

Privacy Policy | Disclaimer | About