Home » Blog » Page 78
Microsoft Excel Guides
Google Sheet guides
Productivity resources
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. […]
When it comes to calculating the median of the data based on a criteria then Excel does not have the ability in the median function to achieve this goal. So […]
