# Sanjida Ahmed

Sanjida Ahmed, who graduated from Daffodil International University with a degree in Software Engineering, has worked with SOFTEKO since 2021. She has written over 100 articles on Excel & VBA and, since 2022, has worked as the Project Manager of the Excel Extension Development Project in the Software Development Department. Since starting this software development, she has established an outstanding workflow encompassing a full SDLC. She always tries to create a bridge between her skills and interests in Artificial Intelligence.

## Designation

Software Developer

## Position

Project Manager in Microsoft Office Extension Development project in SOFTEKO.

## Education

BSc in Software Engineering (SWE) in Daffodil International University.

## Expertise

Java (J2SE, J2EE), Spring, C#, .Net, Asp.net (Core, MVC, Entity), C, HTML, CSS, PHP, UML, SQL, SQLite, VBA, VB.Net, MATLAB, Selenium, Git, Linux (Ubuntu, Mint), LaTeX, Microsoft Office.

### Robotics Project

• Obstacle Avoiding Autonomous Car
• Line Tracing and Locating an Object Robot

## Experience

• Software Engineering
• Project Management
• Team Management

## Summary

• Currently working as Project Manager in Microsoft Office Extension Development project in SOFTEKO.
• Started technical content writing of Excel & VBA in October 2021 in SOFTEKO.

## How to Use TREND Function in Excel (3 Examples)

Introduction to The TREND Function The TREND function calculates the values of a given set of X and Y variables and returns additional Y-values by ...

## FORECAST Function in Excel (with other Forecasting Functions)

What Is the FORECAST Function in Excel? Description The FORECAST function is a Statistical function in Excel. It calculates or predicts a future value ...

## How to Use AGGREGATE Function in Excel (13 Examples)

In this article, you will learn about the AGGREGATE function in Excel. We will explore its uses, aggregate data, with multiple criteria, combine aggregate with ...

## How to Use Nested VLOOKUP in Excel: 3 Methods

Method 1 - Using Nested VLOOKUP in Excel to Extract Product Price Steps: Click on the cell that you want the Price of the ID (e.g. cell beside ID A101 in ...

## How to Remove Letters from Cell in Excel (10 Suitable Methods)

Here's a quick overview of the function that can remove text based on how many characters you want to keep. Read on to learn all the methods you can use for ...

## How to Convert Column Number to Letter in Excel (3 Methods)

Method 1 - Convert Column Number to Letter in Excel Consider the following dataset which we will be using as our example to convert column number to letter by ...

## VBA Macro to Delete Columns Based on Criteria in Excel: 8 Examples

Method 1 - VBA Macro to Delete Columns Based on Cell Value in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic ...

## VBA to Convert Column Number to Letter in Excel (3 Methods)

In this article, we will demonstrate how to convert a column number to its corresponding column letter in Excel with VBA code using 3 methods: converting a ...

## VBA to Delete Column in Excel (9 Criteria)

Generic Syntax The generic syntax to delete single or multiple columns in Excel using VBA is: Columns(column number/ column address).Delete We ...

## VBA to Set Range in Excel (7 Examples)

VBA Range Object The Range object in VBA can contain a single cell, multiple cells, rows, or columns within the Excel worksheet. The hierarchy of ...

## [Fixed!] Subscript Out of Range Error in Excel VBA

Here's an overview of VBA code that outputs errors. What Is the Subscript Out of Range Error in VBA? VBA Subscript out of range error occurs when ...

## How to Check If Cell Is Empty Using Excel VBA: 5 Easy Methods

Method 1 - Using the VBA IsEmpty Function to Check If Cell Is Empty  Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> Visual ...

## Using a Macro to Compare Two Columns and Highlight the Differences in Excel – 2 Methods

Method 1 - Using a VBA Macro to Compare Two Columns and Highlight the Differences in Excel This is the sample dataset. Steps: Press Alt + F11 or ...

## How to Merge Multiple Excel Files into One Sheet by VBA (3 Examples)

We have 3 Excel files - File1, File2, and File3 - which we are going to merge into one sheet or in one workbook. Remember: The files you need to ...

## How to Remove Strikethrough in Excel (3 Ways)

To demonstrate our methods for removing strikethroughs from text in Excel, we'll use the following dataset: Method 1 - Using Keyboard Shortcut to ...

Browsing All Comments By: Sanjida Ahmed
1. Glad that we could help you. Don’t hesitate to ask if you have any more Excel related problems. Here, our experts will be happy to assist you.

2. Hi Jesse,

Thanks for your comment. Have you checked the method no. 2 (VBA Macro to Export Excel Contents with Specified Range to a Pipe Delimited Text File) of this article? I think that solves your problem.

3. Hi James, In some cases, Excel’s IsNumeric property doesn’t always produce the correct result in VBA. Could you please try If Cells(i, 1) = 103 Then instead of If IsNumeric(Cells(i, 1)) = 103 Then in your code?

4. Hello Maurice,