Home » Microsoft Excel Guides » Page 71
While working in google sheets one might encounter an error that Vlookup evaluates to an out of bound range as shown in the image above. So let’s see how the […]
In this tutorial we’ll learn how to find last Friday (i.e. The Friday of the last week) from any given date. Let’s look at the data set in the picture […]
We often come across situations where we try to use a formula and we get an error instead of the desired result. Whether it is Microsoft Excel or Google Sheets, […]
This feature allows users to combine the different cell’s data in one cell. It does not depend upon the symmetry of data. Users can easily combine data from different cells.To […]
In this tutorial you will learn how to clear the formatting from Excel Workbook by using standard Excel tools. Let’s see how to use this special tool for our work.
In this tutorial we will learn how to shade every other row in Excel. To do it yourself we will start with an example. We have a data range and […]
We have a dataset of fruit prices and quantity and we need to calculate the total cost of each fruit type. The dataset is shown in the picture above.
Microsoft Excel provides us with a variety of built-in formulas to manipulate text data. These formulas help us to extract a part of the data, starting from LEFT, MID or […]
Code Snippet: Here is the code. Before using the code you need to change the cell address “$I$2” to whatever cell you will use for creating the drop down list.
Let’s look at this data set which consists of the details about the hockey team players. We wish to highlight those players whose ages are less than 30 years. We’ll […]
Sometimes a pivot table may become inactive or you may want to delete it for creating one from a different dataset. In excel this can be achieved in two ways. […]
Let’s consider the following dataset which contains the details of the sales orders and we wish to find the 5 latest orders placed by our sales reps in any region. […]
In such situations if you use the same command i.e. CTRL+C and then CTRL+V to copy data from those cells with formulas in them, then we will get incorrect results. […]
