MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel and VBA. Outside work, catch him reading books, exploring new places during travels, and watching movies.
The sample dataset showcases Employee Name and Attended Office. Find the names of employees who didn't attend the office. Method 1 - ...
I'll explain to you how to add time in Excel over 24 hours in an efficient and easy way. We will use a sample dataset, where names and weekly hours are given. ...
In this article we will cover several simple and effective ways to use a profit and loss percentage formula in Excel. To demonstrate our methods, we'll use the ...
We will use a sample data set containing the Loan amount, Yearly Interest Rate, Daily Interest Rate, and Accrued Interest Period to Calculate Accrued Interest ...
Dataset Overview For your better understanding, we will use a sample dataset. The data set contains, Names, Months, Number of attendances, and number of total ...
Consider this dataset: Year, States, Items, Sales Channel, and Sales Unit. Let's say you want to summarize the total units sold at the states and sales channel ...
To put the concept of freezing the top two rows into practice, here's a sample data set of people's basic information: Last Names, Ages, Occupations, Marital ...
The following dataset contains the names of some salesmen, their state addresses, sales amounts in dollars, and target achievements. Method 1 – ...
We'll use a sample dataset as an example to help you understand how to multiply columns. We are given Names of some Items in column B, Prices in column C, ...
