How to recalculate in Excel

You can watch a video tutorial here.

How to use named ranges in Google Sheets

How to convert word table to into Excel

How to make reference to another spreadsheet in Google Sheet

Google sheet gained popularity due to certain reasons. Users have the unique capability of working on data remotely. They can use almost all the functionality of Microsoft Excel in Google […]

How to create a dropdown list from another sheet in Excel

In this tutorial we’ll learn how to create a dropdown list from another sheet in Excel. Let’s see the dataset above, it has records of payments made against order IDs. […]

How to use a cell value in Sentence in Excel

Microsoft Excel is one of the most efficient and responsive software to perform mathematical calculations on numeric datasets. In addition to this, it also provides many features to handle the […]

How to remove formulas and keep values in Excel

In today’s tutorial, we’ll learn how to remove formulas from cells but keep the values intact. Let’s look at this dataset. We have the cost of items and a discount […]

How to extract the numeric portion of a street address in Excel

Microsoft Excel provides many features to handle the text data along with numeric data. There are many functions available to join, split and merge data in Excel. The data could […]

How to generate a random name in Excel

In today’s tutorial, we’ll learn how to generate a random name from the list of names. Let’s look at this dataset. We have the names in the list and we’ll […]

How merge cells in Google Sheets using keyboard shortcuts

There are no direct shortcuts to merge rows in Google Sheets; however, we can use keyboard key combinations to merge cells through keyboard keys only. In this tutorial, we’ll learn […]

How to insert a row in Google Sheets using keyboard shortcuts

There are no direct shortcuts to insert rows in Google Sheets; however, we can use keyboard key combinations to insert rows through keyboard keys only. In this tutorial, we’ll learn […]

How to create a Yes or No dropdown in Excel

In this tutorial we’ll learn how to create a YES or NO dropdown in Excel. Let’s see the dataset above, it has records of payments made against order IDs. We’ll […]

How to use the shortcut keys for the date in Excel

You can also enter dates by using the shortcuts in Excel. However, these shortcuts only let you enter the current date i.e., today’s date in any cell. In this tutorial […]

How to remove duplicates but keep the first entry in Excel

Removing duplicates from data in Excel is important for a few reasons. Firstly, duplicate data can lead to inaccurate results and misrepresentation of the data. This is because when data […]

How to fix can’t run code in Break Mode in Excel

The reason of Error The “can’t execute code in break mode” error in Excel occurs when the user is attempting to run a macro or VBA code while the Excel […]