Souptik Roy

About author

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft Office Suites.


Designer and Content Developer at YouHaveGotThisMath and Brainor in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education in Naval Architecture & Marine Engineering, Bangladesh University of Engineering & Technology.


Content writing, C, C++, AutoCAD, Adobe Illustrator, Excel, Microsoft Office, Abacus.



  • Started as Excel & VBA Content Developer on 16 August 2022.
  • Currently working as a Designer and Content Developer for Project YouHaveGotThisMath and Brainor.
  • Former Part-time Content Reviewer- 10 Minute School - from November 2021-August 2022.
  • Former Part-Time Content Writer - Bengal Society- from October 2021- August 2022

Research & Publication

Latest Posts From Souptik Roy

Excel Formula to Change Zip Code to State (5 Examples)

In Excel, you may need to do a lot of work while working on a worksheet. One of the important works that can be done by Excel is to change a zip code to state ...

How to Add Additional Data Labels to Excel Chart

The most popular tool for navigating large datasets is Excel. Excel allows us to do countless tasks with numerous dimensions. Excel may be used to visualize ...

How to Check for Data Entry Errors in Excel (2 Easy Ways)

In Excel, you need to work with a set of data. Sometimes, errors may occur in data entry. So, you need to check for data entry errors to fix the error data and ...

How to Create a Multiplication Formula in Excel (5 Easy Ways)

While working on an Excel worksheet, you must perform different operations. One of these operations is Multiplication. There are different ways to multiply two ...

[Fixed!]: Excel Cursor Not Showing (6 Possible Solutions)

While working on an Excel worksheet, you may face many problems. One of the most common problems is the Excel cursor not showing. This may happen at any time ...

How to Use IF and COUNTIF Functions Together in Excel

While working on an Excel worksheet, you need to work with different functions. Sometimes, you need to combine the functions also to solve a problem. In Excel, ...

How to Use COUNTIF Function to Count Text from List in Excel

While working in an Excel worksheet, you may need to count if cells contain text from a list in Excel. To solve this problem, we can use five easy methods. In ...

Difference Between COUNT and COUNTA Functions in Excel

In Excel, we can use a huge number of formulas to calculate anything easily and properly. There are some common functions like SUM, AVERAGE, etc. COUNT and ...

How to Make Hotel Balance Sheet Format in Excel

You can do different and versatile work with an Excel worksheet. In this article, I will show you how to make a hotel balance sheet format in Excel. It is a ...

How to Make HELOC Payment Calculator in Excel

You can do a wide range of work in Excel worksheets. Excel is a versatile application used in the economic sector. For instance, you can create cash memos or ...

10 Key Differences Between Google Sheets and Excel

The most popular spreadsheet programs nowadays are Google Sheets and Microsoft Excel. When it comes to computations and formulas, they are very similar. This ...

How to Copy Chart Format in Excel (3 Easy Ways)

While using Excel, sometimes you may need to use charts to represent your data or results visually attractive. Moreover, you may need to change the chart ...

How to Convert Date to Quarter and Year in Excel

While working on an Excel worksheet, you need to handle different kinds of procedures. One of them is to convert date to quarter and year in Excel. You can ...

How to View CSV File in Excel (3 Effective Methods)

While working on an Excel Worksheet, sometimes you may need to work with a set of information like customer information, product information, or contacts of ...

How to Make a CSV File in Excel for Contacts (With Easy Steps)

While working on an Excel Worksheet, sometimes you may need to work with a set of information like customer information, product information, or contacts of ...

Browsing All Comments By: Souptik Roy

Advanced Excel Exercises with Solutions PDF