Latest Posts From Sowmik Chowdhury
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 ...
Sowmik Chowdhury
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 ...
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 ...
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 ...
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 ...
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 This is the sample dataset, containing product prices for different months and brands. ...
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 ...
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 ...
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 ...
The dataset below showcases the Sales Quantity of three different laptop models over different weeks. To compare Sales Quantity, use a Bar Chart: ...
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 ...
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, ...
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 Create a Bank Statement Outline Using Data Organization Guidelines in Excel Create an organized outline for a Bank Statement using the Data ...
See Our Reviews at
