Latest Posts From Al Arafat Siddique
How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the Visual Basic ...
Al Arafat Siddique
How to Create a Drop-Down List in Excel STEPS: Select a cell (E3, in this example) on which we’ll create the drop-down list. Go to the Data ...
Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores it in its ...
Method 1 - Use of VBA Len Function to Count Characters in a Cell in Excel The LEN function in VBA Excel returns the number of characters in a text or string. ...
If we remove conditional formatting from cells where it has been applied, Excel also removes the cell formats. In this article, we will demonstrate 2 different ...
The dataset showcases a course registration form with 6 different courses. Using a Code in the Visual Basic Editor Go to the Developer tab. ...
How to Use Code in the Visual Basic Editor Go to the Developer tab from the Excel ribbon. Click on the Visual Basic option. In the Visual ...
We’ve used a dataset that contains a sale list of a super shop. The dataset has a bunch of empty cells and we want to find them before performing any ...
Example 1 - Use the TODAY Function to Create a Day Countdown in Excel Here is a common template of the TODAY formula. We’re going to make a countdown for the ...
The dataset showcases a list of colors with duplicates in Sheet1. To copy the unique colors to another worksheet in the same workbook. Method 1 - ...
The Unix timestamp is a system of tracking time as a running total of seconds. The time count started at the Unix Epoch on January 1st 1970 UTC. So a Unix ...
Method 1 - Convert String to Number Using Type Conversion Functions Excel provides several built-in type conversion functions. We can use them in our VBA code ...
Method 1 - Calculate the Future Value When the CAGR Is Known in Excel Using a Basic Formula Using the following formula, we can easily calculate the Future ...
Method 1 - Calculate Elapsed Time in Excel by Subtracting Two Date Values In this example, we’re going to calculate the elapsed time of World War 2. Here, ...
Method 1 - Using the Excel GROWTH Formula Description The GROWTH function in Excel predicts future exponential growth based on existing data. Given a ...
See Our Reviews at
