Use an Image as a Background in Excel

print_preview_using_background

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 … [Read more...]

Excel Function Keys and Shortcuts

Print Options

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

Name Manager from Excel Ribbon

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 … [Read more...]

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

NETWORKDAYS Syntax

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

Standard_ToolBar_In_VBE

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

Privacy Policy | Disclaimer | About