Latest Blog Posts

How to Reverse Order of Data in Excel (4 Useful Methods)

To illustrate, we have used 2 types of datasets in Excel; one for horizontally reversing, and the other one for vertically reversing, the data order ...

How to Merge Datasets in Excel (5 Easy Methods)

The below dataset contains a table displaying, Student IDs and Names and another table containing Student IDs, Math, and Physics Scores. We will ...

Excel VBA to Select First Visible Cell in Filtered Range

Method 1 - Use Sheet Name to Select First Visible Cell in Filtered Range with Excel VBA STEPS: Go to the Developer tab and select Visual Basic. ...

Create a Search Box in Excel with VBA (5 Suitable Examples)

We have taken the following table as the dataset. This table contains State, Sales Person, and Product columns. We will create a search box in Excel ...

How to Calculate Remaining Shelf Life Percentage in Excel (With Easy Steps)

  Step 1 - Prepare the Dataset Insert the product names in the Product column. Insert the manufacturing date in the MFG Date column. ...

How to Compare Dates in Two Columns in Excel (8 Methods)

Method 1 - Compare Dates in Two Columns Whether They Are Equal or Not Steps: Select an appropriate cell (D5 in this example) and use the ...

How to Select Visible Cells in Excel (5 Quick Tricks)

When working with large data sets containing hidden cells, one can easily select the visible cells along with the hidden cells by dragging the mouse ...

How to Refresh Excel Sheet Automatically Using VBA (4 Methods)

  Method 1 - Using the ThisWorkbook Method in VBA to Refresh an Excel Sheet Automatically Step 1 - Creating the Dataset We will create a ...

How to Create a Filtering Search Box for Your Excel Data (5 Methods)

In the below dataset, we have 3 columns: Customer Name, Region and Product. Method 1 – Using Data Validation  Steps: Select a cell ...

Add 15 Minutes to Time in Excel: 4 Easy Methods

Method 1 - Use SUM Function to Add 15 Minutes to Time in Excel Steps: Add a new column on the right side and remove all the minute values. ...

How to Create GST Bill Format in Excel with Formula: 4 Methods

Method 1 - Create Outline of GST Bill Format Create a basic dataset of the products, like the image below. We need to create another ...

How to Cut Text Using Formula in Excel (6 Simple Methods)

Method 1 - Combine LEFT and FIND Functions to Cut Text in Excel To cut the first text from cell B5 of the dataset, we will use the LEFT and FIND ...

How to Add Sheet After Current One with Excel VBA (3 Variants)

Basics of VBA Sheets.Add Method Sheets.Add is a method that is used to add a new worksheet to the current worksheet. This method is used while ...

How to Create a Scoring Matrix in Excel (Easy Steps)

What is a Scoring Matrix and Where Do We Use It? A scoring matrix is a valuable tool for assessing the relative worth of various items, such as ...

How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

We have a large dataset that we need to select rows from. Method 1 - Using the Name Box to Quickly Select Thousands of Rows Steps: ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo