# Syeda Fahima Nazreen

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.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Education

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

## Expertise

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

## Experience

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

## How to Use the SUMIF Function between Two Values in Excel

The dataset used for these methods contains three columns with the product ID, prices of the products, and delivery dates of a company's products.Â    ...

## How to Convert Number (YYYYMMDD) to Date Format in Excel – 4 Methods

Several Date formats are available in Excel. This is the sample dataset. Method 1 - Using the TEXT Function to Convert Number (YYYYMMDD) ...

## How to Get a Cumulative Sum in Excel If a Condition is Applied (6 Methods)

Method 1 - Using IF with Cell Reference for Excel Cumulative Sum with Condition Steps: In cell D5, enter the following formula: ...

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

Here's an overview of applying formulas in cells based on the colors they have. Apply Formula Based on Cell Color in Excel: 5 Examples We will use ...

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

Example 1 - Using SUMIFS Function with Asterisk (*) Wildcard 1.1 Text Contained Within a Text String Steps: Insert the formula in cellÂ E5. ...

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

Here's an overview of all the methods you can use to sum cells based on different criteria options. Download the Practice Workbook You can download ...

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

Let's have a quick look to the methods we will be using here and the relevant output. How to Use INDEX MATCH with Multiple Criteria in Excel: 3 Ways ...

## How to VLOOKUP and SUM Across Multiple Sheets in Excel

The sample sheets are for 3 consecutive months: January, February, and March, containing the Product Name, Product ID, and Sales for each month. We ...

## How to Remove Special Characters in Excel

This article describes various ways to remove special characters in Excel. Here's an overview of the methods and formulas we'll be applying. ...

## How to Find a Case Sensitive Match in Excel (7 Methods)

Dataset Overview Assuming that we have the following sample dataset which we are going to use in the next sections. You can see that there are two ...

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

We will use the following dataset to explain formulas to find the first occurrence of a value in a range in Excel. The dataset contains two columns with the ...

## 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 sample dataset contains data related to the Sales_ID, the Date of Sales according to the ID number, and the Number of Sales that occurred for that ...

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

Letâ€™s consider the following dataset. It contains the list of product IDs, sales dates, and sales numbers. Some of the cells have blank values, which ...

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