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.

Designation

Designer and Content Developer at YouHaveGotThisMath and Brainor in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

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

Expertise

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

Experience

Summary

  • 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

0
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 ...

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

This is our sample dataset. The image below shows Year vs Sales curve generated from the dataset. The next image is the Year vs Profit curve ...

0
How to Convert a Date to a Quarter and Year in Excel (3 Methods)

Dataset Overview We'll use a dataset called the Product arrival Date of ABC Shop to demonstrate these methods. This dataset consists of two columns B and C ...

0
How to View a CSV File in Excel – 3 Methods

Consider the following dataset containing Customer Information: Name, Id, and Email Id. This file was saved as a CSV file. To view it in Excel: ...

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

  What Is a CSV File? You will unavoidably come across a comma-separated values file, or CSV, if you work with spreadsheet programs like Microsoft ...

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

We have a dataset called Product Price of ABC Traders. The dataset has two columns, B and C, called Product and Price. The Product column refers to the product ...

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

We will consider a dataset of Sales of ABC Traders from B4 to C10. We will add a chart and add a comment on it. Method 1 - Adding a Comment on a ...

0
How to Calculate the Prorated Salary in Excel – 3 Methods

  The dataset showcases Employee name, Joining Date, and Ending Date. Method 1 - Using the YEARFRAC Function to Calculate the Prorated ...

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

To demonstrate our methods, we'll use the following dataset: Method 1 - Using a Generic Formula We add a new row to calculate the total percentage. ...

0
How to Lock Borders in Excel (With Easy Steps)

In this article, we will explain how to lock the borders of a table in a few easy steps. Step 1 - Creating a Dataset To start with, we need a table whose ...

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

Method 1 - Using Generic Formula to Convert Date of Birth to Age in Excel In our sample database, we added two new columns, D & E called Current Date and ...

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

  Below is a dataset on the Bill Report of ABC Company. The dataset has three columns: Customer ID, Name, and Status. Penny's status is unknown, and ...

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

The dataset, Sales Report of ABC Traders, has 2 columns indicating Days and Sales. We will look at 3 easy steps for showing equations in an Excel graph. ...

0
How to Fill Empty Cells with a Default Value in Excel – 3 Methods

Consider the following dataset. To fill empty cells with default values: Method 1 - Fill Cells with a Default Value by Using a Simple Formula ...

0
How to Create a Dialog Box in Excel – 3 Examples

A dialog box is shown below.   Example 1: Create a Simple Message Box Steps: Open the Microsoft Visual Basic for Application by ...

Browsing All Comments By: Souptik Roy

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo