Latest Blog Posts

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

How to Fix Formula in Excel (9 Easy Methods)

While working in Excel, you may have trouble using formulas. To get rid of this problem, you need to know how to Fix Formulas in Excel. In this ...

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

How to Do Integration in Excel (2 Handy Approaches)

Integration is One of the most crucial mathematical tools. We can use it to compute area, volume, and many other beneficial metrics. We can also use ...

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 Rename Column in Excel (3 Easy Ways)

The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the ...

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

VBA Read Text File into Array (2 Suitable Methods)

While working in Excel, we often need to read and extract texts from a text file into array using VBA code. For a small text file, we can do this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo