How to Calculate Accuracy Percentage in Excel (3 Methods)

Assume you have the following dataset. It contains the forecasted demand units and actual demand units for products. Method 1 - Calculate ...

The Insert Row Option is Grayed out – 9 Solutions

The following picture highlights the problem and the solution. Solution 1 - Press Windows+R and Change the Microsoft Excel AppData ...

How to Remove Blank Rows from an Excel Pivot Table – 4 Methods

Consider this sample dataset in a pivot table with blank cells. Method 1 -  Use the Pivot Table Options to Remove Blank Rows  Step 1: ...

Excel Button to Print Specific Sheets: 7 Easy Methods

There are three different sheets in our reference Excel file. We will print specific sheets from that file using the Excel button.   ...

How to Use Formula for Partial Number Match in Excel (5 Examples)

Frequently, you might need to deal with a larger dataset in Excel. What if you want to find the output from the entire dataset that matches your ...

How to Generate Random 10 Digit Number in Excel (6 Methods)

Method 1 - Combine ROUND and RAND Functions to Generate Random 10 Digit Number STEPS: Enter the following formula in cell C5. ...

Excel VBA: Move Column Based on Header (3 Examples)

While working with VBA in Excel, we often need to move one or more column (s) based on Header (s). In this article, I’ll show you how you can move a ...

How to Subtract a Percentage from a Price in Excel (4 Methods)

We'll use a simple dataset with item prices and percentage discounts to subtract them from the original price. Method 1 - Using a Percentage ...

How to Calculate a Percentage Decrease in Excel (4 Methods)

Introduction to Percentage Decrease While subtracting the second value from the first value, you will get the change between these two values. If ...

How to Use PERCENTILE with Multiple IF Condition in Excel (3 Examples)

Excel PERCENTILE Function Introduction In Excel, the PERCENTILE function is used to compute the k-th percentile of values in a range or array. For ...

How to Randomly Select Rows in Excel (2 Ways)

Method 1 - Randomly Select Rows Using RAND Function We want to select four random rows from the sample dataset. We will be using the RAND ...

How to Make Alphabetical List in Excel (3 Ways)

To make your dataset cool and presentable Sorting alphabetically is one of the most used functions in Excel. Throughout this article, we will learn ...

How to Move Columns in Excel Tables (5 Methods)

To demonstrate our methods, we'll use the following table containing Last Name, First Name, Salary and Department columns. We used Excel 365 in this ...

Conditional Formatting for Partial Text Match in Excel (9 Examples)

Method 1 - Using 'Text that Contains' Option for Highlighting Partial Text Matches In the sample dataset, we will highlight cells that contain the ...

How to Insert a Column Between Every Other Column in Excel (3 Methods)

We’ll use the following dataset that represents some fruit prices for three consecutive months. Method 1 - Use a Keyboard Shortcut to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo