# Sowmik Chowdhury

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.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Education

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

## Expertise

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

## Experience

• Technical Content Writing

## 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)

Method 1 - Utilizing Flash Fill to Add Text to the End of Cell We have a dataset with a list of employees and their respective ages. We want to add “Years” to ...

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

Example 1 - Setting Column Titles to Repeat in Excel The sample dataset contains data up to Week 47 which will come to more than one page when printed (in the ...

## 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)

What Is a Gantt Chart? A Gantt Chart is a graph that generally shows the relationship between tasks or milestones and time. It is a very useful tool to keep ...

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

We have a dataset with a list of products that fall into three categories and their Sales Quantity. The categories are Laptop, Headphone, and Smartwatch. We ...

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

Watch Video – Create an Area Chart in Excel Example 1 - Make a Simple 2-D Area Chart in Excel Steps: Select range B6:E12. Cell B6 is the ...

## 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 Bar Chart: ...

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

We have a dataset with a list of people and the percentage of their Task Completed. We'll add progress bar to track their progress. Method 1 - Using ...

## The Formula is Not Working in Excel and Showing as Text – 6 Problems and Solutions

In the following image, you can see that the formula is not working and showing as text. The dataset showcases Name, Weekly Salary, Total Working Hour, ...

## How to Remove Consolidation in Excel (2 Handy Methods)

Method 1 - Applying the FILTERXML and SUBSTITUTE Functions in Excel We have a dataset where there is a list of Countries and their respective cities ...

## How to Organize Bank Statements in Excel – 2 Methods

How to Create a Bank Statement Outline Using Data Organization Guidelines in Excel Create an organized outline for a Bank Statement using the Data ...

Browsing All Comments By: Sowmik Chowdhury

Advanced Excel Exercises with Solutions PDF