We’ve all been there—you’re working on an Excel file, making great progress, and then disaster strikes. Maybe Excel crashes, your computer restarts, or you accidentally close the file without saving. So now you’re asking: how do I recover an Excel file not saved? Good news: Excel has built-in features that might save your work. Here’s […]

Occasionally while working with your Excel sheet, you will find that you need to generate random numbers in Excel. Here we will walk through how to generate random numbers in Excel and some examples of practical application. How to use Excel RAND() Function to Generate Random Numbers The RAND() function is the most common random

Learn how to create a drop down list in Excel in this step-by-step tutorial. We’ll firstly teach how to create a drop down list with a selection from the days of the week. Then, we’ll also explain how to create a smaller drop down list with only two options: yes and no. By the end

Sometimes you may need to summarize your dataset by combining the rows with the same ID.  In this tutorial, we will look at the following three methods you can use to combine the rows with the same ID: How to use the Excel Consolidate tool to combine rows in Excel The Consolidate tool summarizes data

In the default settings of Excel, when a dataset that has blank rows is sorted, blank rows are consigned to the end of the dataset. Sometimes you may want to override this behaviour by ignoring the blank rows when sorting data.  In this tutorial we will look at the following three methods we can use

You are given an Excel file dataset to work on and you discover that it has so many unnecessary parentheses. How do you remove parentheses in Excel? You may decide to remove them one by one by selecting and deleting them using the delete key, but this would be tedious and quite time-consuming, especially if