Sagufta Tarannum

About author

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.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


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


C++, Python,  Microsoft Suite, AutoCAD, Matlab, ETABs, SAP, SketchUp.


  • Technical Content Writing
  • Undergraduate Project & Thesis
    • Design of Water Supply and Sewerage System of a Textile Industrial Village” for Environmental Engineering Sessional course.
    • Effect of Silica and Phosphate on the Precipitation of CaCO3 in Water Treatment and Distribution System.

Latest Posts From Sagufta Tarannum

How to Create Bi Weekly Budget in Excel (2 Useful Methods)

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 ...

How to Create Projected Balance Sheet Format for 3 Years in Excel

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 ...

How to Use Excel Formula to Choose Between Two Values

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 ...

How to Change Decimal Separator in Excel (7 Quick Methods)

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 ...

How to Use CHOOSE Function with Array in Excel

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 ...

How to Calculate Sum & Average with Excel Formula

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 ...

Excel SUMIFS with Multiple Sum Ranges and Multiple Criteria

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 ...

How to Calculate Data Across Worksheets with Formulas in Excel

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 ...

How to Create & Apply Option Button Click Event in Excel VBA

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 ...

How to Create a Search Box in Excel Without VBA (2 Easy Ways)

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 ...

How to Select All Rows in Excel (6 Easy Ways)

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 ...

How to Reverse Order of Data in Excel (4 Useful Methods)

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 ...

How to Sum If Cell Contains Text in Another Cell in Excel

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 ...

How to Calculate Root Mean Square Error in Excel

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 ...

How to Create a Summary Sheet in Excel (4 Easy Ways)

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 ...

Browsing All Comments By: Sagufta Tarannum

Advanced Excel Exercises with Solutions PDF