# Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his chosen field.

## Designation

Junior Software Developer at SOFTEKO

## Education

BSc in Naval Architecture and Marine Engineering from BUET.

## Expertise

JavaScript, React, Nodejs

## Experience

• Software Developer
• Content Writer

## Summary

• Currently working as Junior Software Developer in Web Technologies in Software Development Team.
• Started technical content writing of Excel & VBA in June 2022 and later joined the software development team after 8 months.

## How to Color an Excel Bubble Chart Based on Value (2 Methods)

Method 1 - Color Bubble Chart Using Single Series Data Values This method of creating a bubble chart is quite simple. You can set the color of the bubbles ...

## How to Create Graphs in Excel with Multiple Columns (5 Methods)

Watch Video – Create Graphs in Excel with Multiple Columns Method 1 - Create 2-D Graph with Multiple Columns in Excel Ther is a ...

## How to Add Line to Scatter Plot in Excel (3 Practical Examples)

In this tutorial, I am going to share with you 3 practical examples of how to add lines to an Excel scatter plot. Lines may be needed to show a threshold or ...

## How to Create Barcode in Excel (3 Easy Methods)

Watch Video – Create Barcode in Excel Method 1 - Apply IDAHC39M Font to Create Barcode in Excel Steps: Download the IDAHC39M font and ...

## How to Automatically Calculate the Percentage in an Excel Spreadsheet – 2 Methods

Method 1 - Using an Excel Formula to Automatically Calculate the Percentage 1.1 Using the Conventional Percentage Formula The dataset showcases the total ...

Browsing All Comments By: Nazmul Hossain Shovon
Nazmul Hossain Shovon Dec 4, 2022 at 3:14 PM

Hi Shruti,
I have attached an Excel file that you can use to find specific absent dates. Hope it helps!

Nazmul Hossain Shovon Dec 4, 2022 at 2:23 PM

Hi Maikel,
Can you share your Excel file with us, kindly? So that we may have a look at it and give you some suggestions.

Nazmul Hossain Shovon Dec 4, 2022 at 12:24 PM

Hi Cory,
You can follow the steps below for this:
1. Fill up the information in the pdf file. Then go to File >> Save as Text. This will create a file in .txt format.
2. Now open an Excel sheet. Go to the Data tab. Here in the top left corner, click on From Text/CSV and select the text file you just saved.
3. Finally in the next window, click on Load and this should bring the filled-in information as well.
Hope this helps!

Nazmul Hossain Shovon Nov 14, 2022 at 11:03 AM

Hi Mike,
You can try the following steps to change the date format in excel comments:
1) Type intl.cpl in the Windows Search Box.
2) Now, under Date and time formats, click on the Short date drop-down and choose the date format that you want to use in the comments in excel.

Nazmul Hossain Shovon Nov 14, 2022 at 10:59 AM

Hi James,
Thanks for your correction. To add, you can also calculate the GST amount using this formula:
GST Amount = `(C4*C5)/(1+C5)`
Then we can deduct this value of cell C6 from C4 to get the original price in cell C7.

Nazmul Hossain Shovon Oct 24, 2022 at 3:39 PM

Hi Brijesh,
1. I am assuming that you have a Sheet1 like below:

2. Now, go to the Sheet2 and insert the following formula in cell C5:
`=IFERROR(VLOOKUP(Sheet1!\$B\$5,B5:B12,1,FALSE),"Not Found")`

3. Now, simply copy this formula down using Fill Handle and this should tell you whether the product in cell B5 inside Sheet1 exists in the Product List column or not.