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 ...
Step 1 - Prepare the Dataset Insert the product names in the Product column. Insert the manufacturing date in the MFG Date column. ...
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 ...
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 ...
Method 1 - Using the ThisWorkbook Method in VBA to Refresh an Excel Sheet Automatically Step 1 - Creating the Dataset We will create a ...
In the below dataset, we have 3 columns: Customer Name, Region and Product. Method 1 – Using Data Validation Steps: Select a cell ...
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. ...
Method 1 - Create Outline of GST Bill Format Create a basic dataset of the products, like the image below. We need to create another ...
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 ...
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 ...
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 ...
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 ...
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: ...
Macro 1 - VBA to Find Row Number by Changing Selection Steps: Right-click on the sheet title and select View Code from the context menu. ...
Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, ...
Advanced Excel Exercises with Solutions PDF
