Sagufta Tarannum, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, contributes significantly as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep interest in research and innovation, she actively engages with Excel. In her role, Sagufta not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, underscoring her unwavering commitment to consistently delivering exceptional content. Her interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.
A bi weekly budget plan helps to keep control over the income and continue working towards the goal. In this article, we will learn to create a bi weekly ...
A company or organization often needs to create a projected balance sheet. It provides an idea of the company’s financial performance and also helps to ...
Sometimes, we may need to pick one value between two given values in Excel. In this article, we will learn how to use the formula to choose between two values ...
In this article, we will learn how to change the decimal separator in Excel. This tutorial will guide you with some quick methods to do so. We will describe ...
We usually use the CHOOSE function to find a value from a list. In this article, we will learn to use the CHOOSE function with an array to perform different ...
We often need to determine the sum and average of some numbers in Excel. There are many ways to calculate these. In this article, we will learn some handy ...
We often use the SUMIFS function for multiple criteria in Excel. But in this article, we will use the Excel SUMIFS function with multiple sum ranges and ...
Most of the time, we create or insert formulas for a single worksheet in Excel. But sometimes, we need to create formulas for multiple Excel worksheets. By ...
In Excel VBA, we can form an option button that allows the users to choose a particular option. Usually, the option button is found in UserForms, but sometimes ...
We may think that creating a search box in Excel without VBA is impossible. But it’s not true. In this article, we will learn how to create a search box in ...
One of the most fundamental Excel operations is selecting rows. In Excel, you can select rows in a variety of methods, including by using the mouse or the ...
In Excel, you might occasionally need to reverse the order of data, which means reversing the data order from left to right in a horizontal dataset and also ...
We often need to add numerical numbers depending on the cells that contain specific text. When using Excel to analyze data from a data table, this is a very ...
When comparing two data sets, we employ root mean square error in a variety of applications. Moreover, the root mean square error is one of the most used ...
Sometimes we need to summarize the data for a whole year or sometimes more than that. If we follow the manual process then it will take a lot of time to ...
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