LARGE Function Archives

How to Create a Risk Heat Map in Excel (3 Easy Methods)

May 14, 2022 Excel Basics

A heat map is a visual representation of the comparison of a dataset based on color. If you are looking for some special tricks to create a risk heat ...

How to Remove Text from an Excel Cell but Leave Numbers (8 Ways)

Apr 24, 2022 Excel Formulas

Sometimes we insert both the texts and numbers into the same Excel cell. For some reason, we may want to remove the texts from the cell keeping only ...

How to Create a Dynamic Top 10 List in Excel (8 Methods)

May 22, 2022 Advanced Excel

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

How to Calculate Average of Multiple Columns in Excel (6 Methods)

May 24, 2022 Excel Basics

In this tutorial, I will show some methods regarding calculating the average of multiple columns in Excel. Usually, you can get an average of a range ...

How to Auto Sort Table in Excel (5 Methods)

May 23, 2022 Excel Basics

While working with a large data table in Microsoft Excel, sometimes we need to sort tables and Excel can easily do it. Excel is very useful for ...

Random Number Generator in Excel with No Repeats (9 Methods)

May 23, 2022 Excel Formulas

For specific purposes (e.g. phone number, lottery, statistical sampling), we have to generate random numbers without repetition. However, you may get ...

How to Sort Numbers in Excel (8 Quick Ways)

May 23, 2022 Excel Basics

To do analysis or to keep numbers in order, Sorting is important. In Excel, there are a couple of ways to Sort numbers. There are two possible ways ...

44 Mathematical Functions in Excel (Download Free PDF)

May 22, 2022 Excel Basics

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

Advanced Filter with Criteria Range in Excel (18 Applications)

May 19, 2022 Advanced Excel

In Microsoft Excel, the Advanced Filter option is helpful when looking for data that meets two or more criteria. In this article, we will discuss ...

How to Use AGGREGATE Function in Excel (13 Examples)

May 18, 2022 Excel Functions

In Excel, the AGGREGATE function is used on different functions to get specific results. In this article, we will show you how to use the AGGREGATE ...

How to Remove Letters from Cell in Excel (10 Methods)

May 18, 2022 Advanced Excel

In this article, you will learn how to remove letters from a cell in Excel. Download Workbook You can download the free practice Excel ...

Conditional Formatting on Multiple Rows Independently in Excel

May 18, 2022 Excel Basics

Conditional formatting is one of the essential tools in Microsoft Excel. Analyzing data, creating insights, and other things that we can do using ...

How to Calculate Average in Excel (Including All Criteria)

May 17, 2022 Excel Formulas

In Microsoft Excel, there are several ways to calculate an average of a range of data. In this article, we’ve tried to include all possible criteria ...

How to Sum Rows in Excel (9 Easy Methods)

May 14, 2022 Excel Basics

In Microsoft Excel, the Sum is one of the most common operations we use. There are different techniques to sum up values in multiple rows in excel. ...

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