All resources related to Miscellaneous for Excel and Google Sheets.

All articles
Miscellaneous

How to Make a Heat Map in Excel

Heat map is a graphical representation of data on a color scale. It gives us a comparative view to understand the pattern in the data set. We create a heatmap with conditional formatting using built-in color scale rules. Figure 1. Heat Map How to Make a Heat Map Suppose we...

How to Copy a Worksheet in Excel

We may need to move or copy a worksheet as a backup. In this scenario, we can move or copy the sheet to another workbook or create a duplicate sheet in the same workbook. There are some quick methods to achieve this task. Figure 1. How to Copy a Sheet...

How to Add and Delete a Watermark in Excel

The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header &...

How to Solve the System of Equations in Excel

In mathematical terms, the system of equation is set of two or more equations having the same set of unknown variables like x, y, z where we need to find the values of unknown variables to solve these equations. To solve the system of equations, we can utilize functions and...

How to Show Sheet Tabs in Excel

When we open the Excel workbook, it contains several worksheet tabs like Sheet1, Sheet2, Sheet3 or the named worksheet tab like January, February, etc. Sometimes, we can’t see tabs, some or all of them, at the bottom of the workbook. We need to learn methods of how to make these...

How to Limit Number of Rows And Columns in Excel

By default, each worksheet contains more than 100,000 rows and 16,000 columns to input data. But it is rare to use all of these rows and columns. We can manage to make the maximum number of columns or the maximum number of rows visible and restrict the others to add...

How to Apply a Formula to Entire Column in Excel

Applying a formula is the most common task, but when we need to apply the same formula in the cells of an entire column, it becomes a tedious task. There are multiple ways to learn how to insert a formula for the entire column. Figure 1. Applying Formula to an...

Issue response time calculation

If you need to calculate a response time based on priority level, you can create a table with status and apply VLOOKUP. This tutorial will show you how to issue response time calculation with a detailed example. Formula =Xn+VLOOKUP(value, table, column, FALSE) Explanation In this formula, Xn represents any cell...

Get last entry by month and year

Do you want to get the last entry by month and year in Excel? There are large data piled up in Excel sheets. If you want a single entry, suppose the last one according to month and year. Here is a simple and easy guide for those who want efficient...

Flag first duplicate in a list

Figure 1. of Flag First Duplicate in a List Excel Function. Let's say we are required to mark/flag the first duplicate in a list of items, we can use the COUNTIF function to achieve this. In this tutorial, we will step through the process of flagging duplicate values in a...