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.
Sometimes, you might need to do Bank Reconciliation to manage your financial condition. In Microsoft Excel, you can perform Bank Reconciliation in bulk and ...
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 a very essential and important document to keep track of your financial situation. In Microsoft Excel, you can easily create a Bank Ledger and ...
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 ...
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. ...
Sometimes, while working on Microsoft Excel, we might find all numbers are stored as text. This will hamper our actions in a lot of ways. So, we might need to ...
A Price Comparison Chart is a handy tool for many scenarios. In Microsoft Excel, you can make a Price Comparison Chart with the help of other chart types. ...
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 ...
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 ...
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. ...
In many cases, you may need to make a Bar Graph in Excel with multiple variables. A Bar Graph is a great way to show the relationship or the comparison between ...
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 ...
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 ...
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 ...
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 ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS