Use an Image as a Background in Excel

Generally, most of us have seen Excel as a plain and monotonous piece of software.But have you ever thought about 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 … [Read more...]

Extract Filenames from Filepath in Excel

Getting filenames from a Filepath looks like an easy task at first sight. But actually, this is a very cumbersome task when you are dealing with a large number of file paths. Very recently I also wanted to do this task and during the process of extracting filenames, I found few methods that can automate this process.And today I will be sharing … [Read more...]

Excel Function Key Shortcuts

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

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

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