ExcelDemy - Page 239 of 286 - Free Excel Tutorial & Online Courses

How to Use Excel IF Function with Range of Values

Oct 10, 2021 Excel Formulas

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

VLOOKUP to Return Multiple Values Horizontally in Excel

Feb 24, 2022 Excel Formulas 2

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

VLOOKUP Max of Multiple Values (With Alternative)

Feb 24, 2022 Excel Formulas

MS Excel’s VLOOKUP function is used when we need to find things in a table or in a range by row. It makes our task easy in terms of searching for ...

How to Sort Duplicates in Excel (Columns and Rows)

Feb 28, 2022 Excel Basics

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)

Oct 28, 2021 Excel Basics

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

Random Sort in Excel (Formulas + VBA)

Jun 5, 2022 Excel Formulas

MS Excel provides a few different sorting choices on top of the usual ascending and descending orders. We also have sorted by color or icon, as well ...

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

Feb 24, 2022 Excel Basics

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)

May 12, 2022 Excel Basics

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)

Feb 24, 2022 Excel Basics

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, ...

How to Sort by Date in Excel (8 Suitable Ways)

Feb 24, 2022 Excel Formulas

Today I will be showing how to sort a data set in Excel by date. While working in Excel, we often have to work with dates. From insertion to ...

Sort Column by Value in Excel (5 Methods)

Feb 24, 2022 Excel Basics

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 by Color in Excel (4 Criteria)

Feb 3, 2022 Excel Basics

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

Feb 24, 2022 Excel Basics

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)

Jun 20, 2022 Excel Basics

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)

Feb 24, 2022 Excel Basics

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 ...

Latest Posts