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

How to Concatenate Cells but Keep Text Formatting in Excel (3 Effective Ways)

In Excel, you can join the texts by using the CONCATENATE function. But, the problem arises when you need to keep the same text format after using the ...

How to Add a Comment on a Graph in Excel (3 Easy Methods)

While working in an Excel Workbook, you may need to add charts or graphs to make the results more attractive and easy to understand. To make the graph more ...

How to Use Text to Columns in Excel for Date (With Easy Steps)

While using Excel, you may need to use the text-to-columns option in Excel. This option can be used for many activities. In this article, I will show you how ...

How to Calculate Derivative from Data Points in Excel

A derivative is a common tool to calculate any rate of change of any value. You can calculate derivatives by using Excel. In this article, I will show how to ...

How to Calculate Prorated Salary in Excel (3 Suitable Ways)

While using Excel, sometimes you may need to calculate salary of employees if you run a company. To calculate the salary, you may need to calculate prorated ...

How to Calculate Probability in Excel (3 Practical Examples)

Sometimes, you need to calculate probability with your database. You can calculate this probability using Excel. In this article, I will show how to calculate ...

How to Do Sum of Percentages in Excel (2 Easy Ways)

While working with a dataset, sometimes you need to make a percentage. After getting percentages, the sum of percentages may be required. In Excel, there are a ...

How to Lock Borders in Excel (With Easy Steps)

While working in Excel, we need to deal with a lot of tables in a dataset. Sometimes we may need to lock the borders of a table in Excel. There is a few ...

How to Convert Date of Birth to Age in Excel (3 Easy Ways)

While working in an Excel spreadsheet, sometimes we need to convert the date of birth to age. To know any person’s age, we can use some simple methods in ...

How to Autosum Column in Excel (4 Easy Methods)

When working in Excel, you need to do many kinds of operations. One of the most common operations is to make a sum of a column or a row. Calculating the sum of ...

How to Left Align a Chart in Excel (with Easy Steps)

Charts are very important tools to visualize and represent data attractively. While working with Excel charts, sometimes you need to Align the charts in Left, ...

How to Use CHAR(10) Function in Excel (3 Practical Examples)

While working in Excel, sometimes you need to break your line or connect two strings to make your report or presentation more lucrative and presentable. To ...

How to Calculate Average of Averages in Excel (with Easy Steps)

In Excel, we use to solve different types of real-life problems. One of them is to Calculate the Average of Averages. In real life, an Average of averages or ...

How to Use Cell Address in Excel Formula (8 Suitable Examples)

To perform calculations and retrieve data based on the values in specific cells, you must know how to use a cell address in Excel Formula. However, it can be ...

How to Show Equation in Excel Graph (with Easy Steps)

In Excel, graphs are so important to visualize data or results after any kind of operation. Most of the time, for business purposes, there is no need to show ...

Browsing All Comments By: Souptik Roy

Advanced Excel Exercises with Solutions PDF