Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop application development.
In this article, we will learn how to generate automatic email alerts in Excel. In the banking or financial system, we have to deal with a lot of information. ...
In this article, we will learn how to write a paragraph in an Excel cell. Sometimes we need to insert an entire paragraph in an Excel cell. We can easily write ...
In this article, we will learn how to create double-entry bookkeeping in Excel. Bookkeeping is the process of recording financial transactions. In double-entry ...
In this article, we will learn how to create Budget Burndown Chart in Excel. Burndown chart is an effective tool for tracking the progress of a project. A ...
In this article, we will learn how to drill down without Pivot Table in Excel. It is difficult to compute the sum or average of different groups in large ...
In this article, we will explore VBA ComboBox properties in Excel. ComboBox is a drop-down list that combines textbox and list. To access the full advantage of ...
In this article, we will show the main dissimilarity between connections vs. queries in Excel. Data Table is a very useful tool in Excel and is mainly used for ...
In this article, we will learn how to calculate delta in Excel. Delta indicates the difference between the 2 numbers. We can easily calculate delta in Excel. ...
In this article, we will learn how to convert scientific notation to x10 to power of 3 in Excel. We often need the exponential format for writing scientific ...
In this article, we will learn how to create an interactive checklist in Excel. It is mainly used for selecting or deselecting any option. But we can make the ...
Suppose we have a dataset and we want to print it. But we may wish for the printed sheet to look clearer. Increasing font size helps us to read the data ...
In this article, we will learn to limit sheet size in Excel. Assume we've already created a data set. We may want to limit the size of the Excel sheet to keep ...
Assume we have created a chart based on a data set. However, we may have another dataset and wish to create a chart similar to the previous one. Then we don't ...
There are times when it is necessary to edit the data table. Sometimes we need to delete or edit the information in the table. Excel can be an extremely useful ...
Sometimes, we need a lot of Excel charts and cells into PowerPoint slides quickly and easily. If we use automation to link Excel and PowerPoint, we can skip ...
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