Syeda Fahima Nazreen

About author

SYEDA FAHIMA NAZREEN is an electrical & electronics engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Proteus, MATLAB, Multisim, AutoCAD, Jupiter Notebook, and MS Office, going beyond the basics. With a B.Sc in Electrical & Electronic Engineering from American International University, Bangladesh, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel and VBA. Beyond the tech stuff, catch her lost in books, explore new places during travels, and enjoy movies and TV series in her downtime.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Electrical & Electronic Engineering from American International University, Bangladesh.


Proteus, MATLAB, Multisim, AutoCAD, Jupiter Notebook, MS Office, Excel & VBA


  • Intern at Dhaka Electricity Supply Company Limited DESCO, Bangladesh.

Latest Posts From Syeda Fahima Nazreen

How to Use SUMIF Function between Two Values in Excel

Database maintenance frequently requires summing up based on criteria. Summing two values based on criteria is one of them. The article will explain a method ...

How to Convert Number (YYYYMMDD) to Date Format in Excel

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, 1900 (e.g., ...

Cumulative Sum in Excel If Condition Applied (6 Methods)

Cumulative summation is one of the most used operations throughout the world to keep track of data related to similar things. Cumulative summation helps to see ...

How to Apply Formula Based on Cell Color in Excel (5 Easy Ways)

You might have a colorful dataset and you would like to use the cell color to work with the Excel formula. Excel has a lot of amazing bunches of formulas to ...

How to Use SUMIFS Function with Wildcard in Excel (3 Examples)

In Microsoft Excel, the SUMIFS function is used to evaluate the sum from a range of cells under multiple conditions. Adding the wildcard feature can make this ...

How to Sum If a Cell Contains Criteria (5 Suitable Examples)

Summing up is one of the common things needed daily. While the usual summation is lengthier for large datasets, summation based on criteria is a more critical ...

How to Use INDEX MATCH with Multiple Criteria in Excel (3 Ways)

Excel datasets are used to keep records of information. Searching for information from large datasets can be time-consuming. Excel has some useful formulas to ...

How to VLOOKUP and SUM Across Multiple Sheets in Excel

In general, corporate databases are usually complex and contain multiple worksheets in workbooks. However, you might like to work with ease and be able to ...

How to Remove Special Characters in Excel?

Many times the database contains some special characters that we do not need in the database, and we want to remove them. We can easily perform this task with ...

How to Find Case Sensitive Match in Excel (7 Ways)

When you have a database with case-sensitive values, you might need to match those. Excel has some amazing formulas to match case-sensitive values. The article ...

How to Find First Occurrence of a Value in a Range in Excel

In the corporate world, we are used to seeing databases where a few things occurred more than once. One may want to find out the first occurrence of a value in ...

How to Count Empty Cells in Excel (4 Suitable Ways)

Many times, the database might contain empty cells. One would like to count the empty cells. Microsoft Excel has some amazing formulas and tools to do it ...

Lookup Value in Column and Return Value of Another Column in Excel

The corporate world works with huge datasets. Microsoft Excel has made their work easier through various formulas to maintain the datasets with ease. However, ...

How to Fill Blank Cells with Value Above in Excel (4 Easy Methods)

Microsoft Excel has several useful methods to fill blank cells with the value above. Today we will describe 4 instrumental methods to fill blank cells with the ...

How to Count Specific Characters in a Column in Excel

Microsoft Excel is a powerful tool for organizing, analyzing, and manipulating data. One useful feature of Excel is the ability to count specific characters in ...

Browsing All Comments By: Syeda Fahima Nazreen

Advanced Excel Exercises with Solutions PDF