Sowmik Chowdhury

About author

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, AutoCAD, ABAQUS, Rhinoceros, ANSYS FLUENT, Solidworks, and Python.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc. in Naval Architecture & Marine Engineering, BUET.


Microsoft Office, AutoCAD, ABAQUS, Rhinoceros, ANSYS FLUENT, Solidworks, C++, Python


  • Technical Content Writing

Latest Posts From Sowmik Chowdhury

How to Do Bank Reconciliation in Excel (with Easy Steps)

Let’s assume you have a Bank Statement and a Cash Book as shown below. Here, we can see that the closing balances don’t match. So, you want to do Bank ...

How to Do Data Mapping in Excel (5 Handy Ways)

  Method 1 - Inserting VLOOKUP Function to Do Data Mapping in Excel Let’s assume a dataset with the Sales Quantity for three different models of laptops ...

How to Make a Bank Ledger in Excel (with Easy Steps)

A Bank Ledger is the bank account balance computed by a bank for each account every business day. It includes all kinds of deposits and withdrawals. In this ...

How to Add Text to End of Cell in Excel (6 Easy Methods)

There might come some instances, where you need to add text to the end of a cell or cells in Excel. Microsoft Excel enables you to do such tasks in bulk and ...

How to Set Print Titles to Repeat in Excel (2 Ways)

In many cases, when you have a worksheet with lots of data, you might need to set print titles to repeat. In Microsoft Excel, you can do so within seconds. ...

How to Fix All Numbers Stored as Text in Excel – 6 Easy Methods

This is the sample dataset. Method 1 - Using the Flash Fill Feature Steps: Add a new column. Enter the three first numbers from the Age ...

How to Make a Price Comparison Chart in Excel – 3 Examples

How to Make a Price Comparison Chart in Excel: 3 Examples   This is the sample dataset, containing product prices for different months and brands. ...

How to Add Milestones to Gantt Chart in Excel (with Quick Steps)

In many cases, we need to add milestones to the Gantt Chart. In Microsoft Excel, a swift method is available to do it. Although you can’t do it directly, there ...

How to Create Pie Chart for Sum by Category in Excel (2 Quick Methods)

A Pie Chart is a great way to show the comparison between multiple variables. In many cases, you might need to create a Pie Chart for the sum by category in ...

How to Create an Area Chart in Excel (6 Suitable Examples)

An Area Chart is a great way to show the relationship or comparison between different sets of data. In Microsoft Excel, you can create 6 types of Area Charts. ...

How to Create a Bar Graph with Multiple Variables in Excel – 5 Steps

    The dataset below showcases the Sales Quantity of three different laptop models over different weeks. To compare Sales Quantity, use a ...

How to Create a Progress Tracker in Excel (3 Handy Ways)

A progress tracker is a very handy tool in our life. You may need a progress tracker for tracking progress of employees in a project, to keep track of your ...

[Fixed!] Formula Not Working in Excel and Showing as Text

If your formula is not working in Excel and is showing values as text and you are looking for solutions then this article is for you. Here, we will demonstrate ...

How to Remove Consolidation in Excel (2 Handy Methods)

Consolidation, merging, or combining data in a cell from different rows and columns is a common phenomenon. But, the hard part is to remove this consolidation ...

How to Organize Bank Statements in Excel (2 Handy Methods)

Bank statements are one of the most necessary documents in our day-to-day life. Financial institutions need to prepare organized bank statements on a regular ...

Browsing All Comments By: Sowmik Chowdhury

Advanced Excel Exercises with Solutions PDF