Sum Cells based on Background Color

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

How To Freeze Rows In Excel

Just assume you are school teacher and have around 90 students in a class which is divided into various sections. Now, you have to collate their marks in every subject in an excel.If you are using a 15-inch laptop to do this, then as soon as you go to the 25th row or later you lose the context of which column is for which subject. All of this … [Read more...]

Counting Unique Values In Excel – 5 Effective Ways

Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each value.Though this can be a very common requirement in many scenarios but excel doesn’t have any single formula that can directly help us to count unique values in excel inside a range.In today’s post, we will see 5 … [Read more...]

Use an Image as a Background in Excel

Generally most of us have seen Excel as plain and monotonous piece of software.But have you ever thought how you can use your creativity to create amazing and attractive spreadsheets?In this post, I am going to share one such technique, here we are going to learn how to add background images in your Excel worksheets.So grab a cup of coffee, … [Read more...]

Excel Function Keys and Shortcuts

Function Keys in Excel are a handy and faster way of doing certain tasks by using keyboard instead of mouse. In this article we are going to discuss about the use of excel function keys (F1 to F12). Function keys provide same output in all versions of Excel making it easier to recall.Before we head onto our topic, let us first know about the … [Read more...]

Named Range in Excel

In this article we are going to learn about Named Range in Excel. Named Range gives the Excel users a privilege to provide names to a specific cell, cells (defined range of cells), formula or constant value. Named Range is supported in all versions of Excel. This article will brief you about why and how to use named range.When and Why to Use Named … [Read more...]

How to Use Excel 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

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

Privacy Policy | Disclaimer | About