Latest Blog Posts

How to Add Parentheses with CONCATENATE Function in Excel 

You might occasionally need to add brackets around the text in a cell to contain the cell value for a specific purpose. You can easily add brackets ...

How to Create a Sensitivity Table in Excel (2 Methods)

Sensitivity analysis evaluates how various values of an independent variable impact a specific dependent variable. We will apply this to the sample ...

Advanced Excel Exercises with Solutions PDF

In this article, you will find advanced Excel exercises with solutions in PDF format. You need to possess advanced Excel knowledge to solve these ...

How to Calculate Frequency Using COUNTIF Function in Excel

Method 1 - Using COUNTIF Function to Calculate Frequency in Excel Steps: Use the following formula in cell D17. ...

Creating Dynamic Ranges with the OFFSET and the COUNTA Functions in Excel – 2 Methods

The OFFSET and the COUNTA Functions The OFFSET function returns a reference to a range. The syntax of the OFFSET function is: ...

Using the Excel COUNTIF to Count Cells That Contain Text from other Cells

This is the sample dataset.   1. Using the Asterisk Sign with the COUNTIF Function Including Blank Cells Steps: Go to C17 and ...

How to Use COUNTIF Function to Count Text from List in Excel

While working in an Excel worksheet, you may need to count if cells contain text from a list in Excel. To solve this problem, we can use five easy ...

Excel Data Entry Practice Exercises PDF

These problems are mostly beginner-friendly. You will need to know about the IF, SUM, SUMIF, MATCH, INDEX, MAX, and LARGE functions, as well as ...

Excel Data for Pivot Table Practice

To solve these problems, you need to be familiar with inserting pivot tables, using slicers, utilizing calculated fields, inserting pivot pie charts, ...

Nested IF Function Practice Exercises in Excel

  Problem Overview Our dataset has three columns for the first exercise: “Name”, “Score”, and “Comment”. We will slightly change the dataset ...

Excel Data for Practice Free Download

You should know how to use the following functions: IFERROR, IFS, AND, COUNTIFS, SUM, COUNTIF, SUMIF, WEEKDAY, and SUMPRODUCT. Additionally, you ...

Excel Practice Exercises PDF with Answers

To solve the following exercises, you will need to know about the SUM, AVERAGE, IF, VLOOKUP, INDEX, MATCH, ROUNDUP, UNIQUE, COUNTIF, LEFT, SEARCH, ...

What Is the Best Practice for Financial Modeling in Excel?

In this article, you will learn about the best practice for financial modeling in Excel. In order to comprehend this article, you need to possess ...

Sample Excel File with Employee Data for Practice

In this example, you will get a sample Excel file with employee data for practice. The problems are beginner-friendly and you will need to know the ...

How to Use COUNTIFS Function with 3 Criteria in Excel

  Here’s the sample dataset that we’ll use to demonstrate the examples. It represents some salespersons’ sales and dates in different ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo