How to Use Excel Sparklines

Line Sparklines

Excel Sparklines were introduced in Excel 2010 version. It is small line chart that could be easily embedded with the text and gives a great presentable output for easier depiction when aligned next to the tabular data. They are supported in Excel 2010 and above version only. Although sparkline’s design is not limited to lines they can also be … [Read more...]

Adding Current Date and Time Stamp in Excel

Date Using Keyboard Shortcut

Sometimes it happens that you might want to enter the current date and time stamp in your excel spreadsheets automatically. This need usually arrives because of various reasons, in my case I was urged to find a solution to it as I need to do some team management wherein I required the time my associates are spending on work daily. So, in this case … [Read more...]

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

Privacy Policy | Disclaimer | About