# 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 Lock Table Array in Excel (2 Effective Ways)

In this tutorial, I am going to show you 2 effective ways how to lock table array in Excel. You can apply these methods to any type of dataset and lock them in ...

## How to Undo Text to Columns in Excel: 3 Simple Methods

Method 1 - Using Ampersand Operator Steps: Double-click on cell D5 and type in the following formula: =(B5&” “%C5) Press Enter to ...

## How to Compute Grades in Excel (3 Ways)

In this sample dataset the columns are labelled Name, Marks, and Grades. For the grades, we have 5 possible options.   Method 1 - Computing ...

## How to Remove Drawing Tools in Excel (3 Easy Methods)

The dataset that we will use to remove the drawing tools contains various shapes as Excel objects. We put in multiple shapes to showcase ...

## How to Convert CSV to XML in Excel: 4 Methods

Method 1 - Opening CSV File in Excel Open the CSV file in Excel. Note down the heading of each column. This will be required to create the ...

## How to Calculate Annuity in Excel (5 Practical Examples)

In this tutorial, we will present 5 practical examples of how to calculate annuity in Excel. Determining the various aspects of an annuity is a fairly ...

## How to Create Student Attendance Sheet in Excel with Formula

In this tutorial, we'll create a simple Student Attendance sheet with formulas in Excel, that enables recording different students' attendance in a class over ...

## Troubleshooting Excel Print Area Issues (2 Possible Solutions)

Solution 1 - Using Page Break Preview If the Excel Set Print Area feature isn’t working as expected, try this first solution. Page Break Preview provides ...

## How to Insert Page Number in Excel (7 Easy Methods)

Method 1 - Using Page Layout View Style to Insert Page Number Steps: Go to the View tab and from the Workbook Views section, select Page Layout. ...

## How to Add Text to Beginning of Cell in Excel (7 Quick Tricks)

Method 1 - Using Ampersand(&) Operator to Add Text to the Beginning of a Cell in Excel Steps: Double-click on cell C5 and enter the following ...

## How to Show Only Working Area in Excel (3 Quick Tricks)

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample dataset, ...

## How to Remove Page 1 Watermark in Excel (4 Easy Methods)

Method 1 - Change Workbook Views to Remove the Page 1 Watermark in Excel In many situations, a page 1 watermark appears in an Excel workbook because of a ...

## How to Convert Number to Text in Excel with Apostrophe

In this tutorial, we will demonstrate a quick but useful method to convert numbers to text format in Excel using the apostrophe. Furthermore, this method will ...

## How to Align Shapes in Excel (5 Simple Methods)

Method 1 - Align Shapes in Same Plane in Excel We have four shapes that are on the same plane but are not arranged in a particular way. Steps: ...

## How to Find the Equation of a Trendline in Excel (3 Methods)

Method 1 - Single Trendline Steps Choose your dataset using the mouse. Go to the Insert tab and select Scatter from the Insert Scatter (X, Y) ...

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.