1.

How to Calculate Range in Excel (5 Handy Methods)

We have made a dataset of Sales of Shoes and Bags in 2021 at different stores. We'll use it to apply various range functions. Method 1 - Applying MAX and MIN Functions…

2.

How to Select a Range of Cells in Excel (9 Methods)

We will use the following dataset to illustrate selecting cells. Method 1 - Click & Drag to Select a Range of Cells in Excel For example, click on cell B3 and drag…

3.

How to Find Value in Range in Excel (3 Quick Methods)

Let's use a table that contains several actors from different film industries with one of their popular movies. We'll find different values based on movie or actor names. Method 1 - Use…

Advanced Excel Exercises with Solutions PDF