Latest Blog Posts

Insert a Column with a Name in Excel VBA – 5 Examples

Example 1 - Insert a Single Column with a Name in Excel Using VBA The following dataset showcases sales data in different cities and in different ...

Random Selection from List with No Duplicates in Excel: 5 Methods

Method 1 - Using RAND, INDEX, and RANK.EQ Functions for Random Selection without Duplicates Steps: ➤ For generating random unique numbers type the ...

Generate Random Number in Excel with Decimals (3 Methods)

  Method 1 - Generate Random Number with Decimals Using Excel RAND Function The RAND function returns a random number greater than or equal ...

How to Generate Random Date and Time in Excel (3 Ways)

In the dataset below, you can see a column filled with dates and times. They have been chosen randomly using different combinations of formulas. ...

How to Correct a Spill (#SPILL!) Error in Excel (7 Easy Fixes)

Let's look at some of the scenarios where you could get the #SPILL! issue and how to correct them. We are going to use the following dataset, which ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo