Latest Blog Posts

How to Print Multiple Excel Sheets in a Single PDF File with VBA (6 Methods)

We have an Excel workbook consisting of three worksheets. The first worksheet is Sheet 1, and the data is shown in the picture below. The ...

How to Extract Data from Image into Excel (With Quick Steps)

Data extraction from images, a feature available on the subscription-free Excel 365 mobile app, is very effective method of importing data. ...

[Fix:] Hyperlink to Website Not Working in Excel

Hyperlinks in an Excel file can relate to the location of a file on the computer or a place inside the same worksheet. Furthermore, hyperlinks might ...

Excel VBA: Cut and Insert Column (5 Examples)

We’ll use the Range.Cut method to cut single or multiple columns and then the Range.Insert method to insert into the worksheet. We’re going to use ...

How to Merge Excel Files Based on Column (3 Ways)

The following image shows the names and corresponding designations which we saved in a file named Merge Files. This figure shows the names and ...

How to Select a Random Sample from a Population in Excel (3 Ways)

When you work on a large set of data and want to select some data from the dataset, you find it really difficult to achieve it. Sometimes it provides ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo