Excel Basics

VLOOKUP with 2 Conditions

In Excel, you may need to search values using different lookup functions: LOOKUP, VLOOKUP, HLOOKUP. Today we are going to show you how to use VLOOKUP ...

How to Write Greater Than or Equal To in Excel IF Function

The IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, and ...

How to Sort Duplicates in Excel (Columns and Rows)

Sorting is one of the most common tasks in the daily use of Excel. You need to perform various sorts; sort multiple columns, sort dates, sort data ...

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

When you are dealing with a big amount of datasets, searching, organizing, keeping them in a specific cell, and tracking the specific data becomes ...

How to Create Custom Sort in Excel (Both Creating and Using)

Today I will be showing how you can create a custom sort list in Excel, and then use it. While working in Excel, sometimes we have to sort a data ...

Generate Random Number from List in Excel (4 Ways)

Although there is no suitable or single function to extract a random number from a list in Excel, there are numerous ways to manually construct the ...

How to Sort Rows in Excel (2 Simple Methods)

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, ...

Sort Column by Value in Excel (5 Methods)

When you add more raw data to your worksheet, balancing, organizing, and searching the specific data becomes more difficult. To get rid of this ...

How to Sort Data by Color in Excel (4 Criteria)

In Microsoft Excel, there are numerous ways available to sort table data under different criteria. If the data table contains colors in cells, fonts, ...

Sorting Columns in Excel While Keeping Rows Together

Sorting is the best way to make the dataset more convenient and acceptable. This makes our work with datasets in various ways. MS Excel provides ...

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

Sorting alphabetically in excel is very easy and at the same time very useful when you are working with a wide range of raw data. Sorting is one of ...

Shortcut to Copy Formula Down in Excel (7 Ways)

To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. In terms of copying formulas in MS Excel, there are ...

How to Autofill Numbers in Excel without Dragging (5 Quick Methods)

Microsoft Excel provides numerous ways to autofill numbers with or without dragging. Filling down the column is the most common method to complete a ...

How to Convert Columns to Rows in Excel (2 Methods)

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you ...

How to Sort by Last Name in Excel (4 Methods)

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

ExcelDemy
Logo