# Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Expertise

Rhino3D, Maxsurf, C++, MS Office, AutoCAD, WordPress and Excel & VBA

## Experience

• Intern at Khulna Shipyard, Khulna, Bangladesh.
• Probationary Officer at United Commercial Bank PLC, Bangladesh.

## How to Create and Use the Color Function in Excel – Easy Steps

It is possible to make custom functions for calculation based on the color of the cells using the Microsoft Visual Basic for Applications (VBA). ...

## How to Remove Blank Lines in Excel (7 Methods)

Dataset Overview In our dataset we have data of different members of a club. Our dataset contains several blank lines. We will delete these empty rows by ...

## How to Use IFERROR with VLOOKUP in Excel: 5 Different Methods

Method 1 - Replace #N/A with Custom Text Search for a student whose name isn’t in the list, you want to show custom text such as “Not found”. Enter the ...

## Using the INDEX Function to Match and Return Multiple Values Vertically in Excel – 2 Methods

This is an overview of the INDEX function. The sample dataset contains 2 columns: Country and City. Method 1 - Using the INDEX ...

## SUMIF Across Multiple Sheets in Excel: 3 Methods

In our datasheet, we have Quarterly sales by different salesmen across different sheets. Now we want to calculate the yearly sales of different salesmen. For ...

## How to Calculate Years from Today in Excel (4 Easy Ways)

There is no built-in function to calculate the years between a past or future date and today’s date in Excel. However, you can do it by applying a combination ...

## How to Compare Two Columns in Excel for Match (8 Easy Ways)

Consider the following dataset with 10 days of sales data from two different salesmen. Each of them sold one car per day which is given in columns B and C. We ...

## How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

Method 1 - Combining MID, CELL, and FIND Functions to Insert the Sheet Name into Cell Value Consider the following dataset. We want to insert the Excel sheet ...

## Count One Column If Another Column Meets Criteria in Excel

We have a dataset of the Sales Report of a Company. We will count one column if the values in another column meet certain criteria. Method 1 - Using ...

## How to Find Last Cell with Value in a Row in Excel (6 Ways)

Consider the following dataset about different customers who have applied for a bank loan. We will find the last cell with data in a row. Method 1 - ...

## How to Delete a Column in Excel Without Affecting the Formula – 2 Methods

The following dataset showcases Unit Production in column C and Per unit Cost in column D. The total per month is calculated in column E. To delete columns ...

## How to Calculate Difference Between Two Dates and Times in Excel

Part 1 - Calculating the Difference Between Two Dates in Excel We have the Starting Date of different projects in column C and the Ending Date in ...

## Absolute Reference in Excel – 4 Examples

The Absolute reference locks the referred cell. If you use an absolute reference, the cell won’t change after dragging the Fill Handle. To create ...

## How to Copy a Sheet to Another Sheet in Excel (5 Easy Ways)

To showcase copying sheets, we’re going to consider the following sheet named Dataset. We will copy this sheet to a new sheet. Method 1 - Using the ...

## How to Merge Rows Without Losing Data in Excel (5 Easy Ways)

In Excel, merging multiple rows, columns or cells is a common task. However, the standard merging procedure only keeps data from the upper left cell. In this ...

Browsing All Comments By: Prantick Bala