Excel Basics

How to Make a Drop Down List in Excel (Independent and Dependent)

Example 1 - Create an Independent Drop-Down List in Excel We have a list of popular Samsung smartphones. We’ll make a drop-down list in Cell E7 from ...

Excel Auto Sort When Data Changes (9 Examples)

In this article, we'll demonstrate how to use the SORT function or combine it with other functions to sort data automatically when data is changed ...

How to use Greater Than or Equal To in the IF Function – 3 Examples

This is the sample dataset. Example 1 - Use Greater Than in the IF Function  Steps: Select F5 and enter the following formula. ...

How to Sort Duplicates in Excel – 3 Methods

The following dataset contains duplicate items and quantities in kg. Duplicates were sorted in alphabetical order from A to Z. Quantities were sorted ...

How to Sort Rows by Column in Excel (4 Easy Methods)

Method 1 - Use Ascending (A-Z) or Descending (Z-A) Options to Sort Rows by Column in Excel Method 1.1 - Sort Rows by Column from A-Z (Smallest to ...

How to Perform Random Sort in Excel (6 Easy Methods)

We will show 6 easy methods to random sort in Excel, using a dataset of a shop containing product Name, Quantity, Delivery Date, and Price. ...

How to Perform Custom Sort in Excel – 3 Steps

The sample dataset showcases Names, Marks in Mathematics, and students' Grades. There are 6 different grades. A+, A, A-, B, C, and ...

How to Generate Random Number from List in Excel (4 Ways)

  Method 1 - Using INDEX and RANDBETWEEN Functions to Get a Random Number from a List in Excel In the following picture, Column B has ten ...

How to Sort Rows in Excel (3 Easy Ways)

To demonstrate methods for sorting rows in Excel, we’ll utilize this simple dataset listing several footballers and their goals scored over the last ...

How to Sort by Date in Excel: 9 Suitable Methods

Method 1 - Applying Sort & Filter Feature to Sort by Date in Excel Steps: Select the whole data set by selecting cells B4:D19. Go to the ...

How to Sort Column by Value in Excel (7 Easy Ways)

Let's use a List of Employees. This dataset includes the IDs, Names, and their corresponding Income in columns B, C, and D, respectively. We'll use ...

How to Sort by Color in Excel (4 Criteria)

Example 1 - Sort by Single Color in Excel Step 1: ➤ Select the entire table. ➤ Under the Data ribbon, select the Sort option from the Sort ...

How to Sort by Column in Excel and Keep Rows Together (4 Easy Ways)

Method 1 - Using the Sort Command to Sort by Column and Keep Rows Together Select the cells in the range D5:D10. Go to the Data tab. From ...

How to Sort Multiple Columns Alphabetically in Excel (4 Methods)

Dataset Overview To illustrate the methods, we'll use the following sample data set: Method 1 - Ascending or Descending Sorting ...

How to Copy Formula Down with Shortcut in Excel

Method 1 - Using Keyboard Shortcut to Copy Formula Down for a Column in Excel Steps: Choose a cell (D7) and press CTRL+SHIFT+END to select all ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo