Latest Posts From Asif Khan Pranto
In this article, we will learn about the Excel Formula for a 30-Year Fixed Mortgage. Here we will use several formulas related to 30 Year Fixed Mortgage. We ...
Asif Khan Pranto
Dataset Overview Let’s assume we have a dataset of a company’s sales with columns A to G representing Delivery Date, Region, Sales Person, Product Category, ...
Dataset Overview We have a dataset with columns for State Name (Column B), Budget Allocation (Column C), and Region (Column D). We'll identify the first value ...
Suppose we have a dataset of a company's sales having Delivery Date, Region, Salesperson, Product Category, Product and Sales Amounts. We'll use a pivot table ...
Suppose we have a dataset of several employees with DoB (date of birth) in column C. We want to convert the date to month and year only for our ...
We have a dataset containing five columns: Serial Number, Candidate Name, Acquired Number, DoB, and Candidate’s Code. We will use different Columns of our ...
The dataset showcases movie names. Method 1 - Using the LEN Function The LEN function calculates the number of characters in a text ...
