Sanjida Ahmed

About author

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.

Lives in

Dhaka, Bangladesh.

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.

Academic Projects

Projects

Thesis

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.

Research & Publication

Latest Posts From Sanjida Ahmed

0
How to Reference Text in Another Cell in Excel (14 Ways)

Method 1 - Reference Text from One Cell to Another Cell in the Same Worksheet in Excel Consider the following example. We will take cell B7 and reference the ...

0
VBA to Check If CheckBox Is Checked in Excel: 3 Ways

Method 1 - Embed VBA Macro to Check If CheckBox Is Checked with Numeric Value in Excel Add a checkbox to examine whether the checkbox is checked or not. To ...

0
[Fixed] F4 Not Working in Absolute Cell Reference in Excel (3 Solutions)

The F4 key in your keyboard is usually used to lock the values in cells in Excel. But sometimes the key doesn’t work for some reason. In this article, we will ...

0
Using Excel VBA to Count Blank Cells in a Range – 3 Methods

  This dataset contains blank cells. Use the COUNTIF Function and the COUNTBLANK Function in a VBA macro. Method 1 - Embed a VBA to Count ...

0
VBA to Copy Data to Another Sheet with Advanced Filter in Excel: 3 Methods

Method 1 - Embed VBA Code to Copy Data to Another Sheet with Advanced Filter in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer ...

1
VBA to Count Duplicates in Range in Excel (4 Methods)

When we have a large amount of data in our Excel worksheet, it is hard to understand sometimes. If we have a certain knowledge of how many duplicate values are ...

1
VBA to Copy Formula from Cell Above in Excel (10 Methods)

When we are dealing with a huge amount of data with various formulas, sometimes we have to copy data with formulas from the cell above in an Excel worksheet. ...

1
VBA to Copy Worksheet to Another Workbook and Rename (5 Methods)

When we are dealing with multiple Excel sheets, sometimes we need to copy one worksheet to another workbook and provide a new name to it for better ...

1
Macro to Copy and Paste from One Worksheet to Another (15 Methods)

When we are dealing with multiple Excel sheets, sometimes we have to copy data from one spreadsheet to another. Implementing VBA is the most effective, ...

1
How to Calculate Average Turnaround Time in Excel (4 Methods)

  Method 1 - Compute the Average Turnaround Time in Excel Look at the following picture. We have the Start Time and the End Time of some Projects. With ...

1
How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

When your dataset has values like dates, numbers, texts etc. and you want to concatenate them, Excel throws some random numbers at you. To concatenate the date ...

1
How to Calculate the Annual Growth Rate in Excel – 3 Methods

  1. Calculate the Compound Annual Growth Rate in Excel There is a basic formula to calculate the Compound Annual Growth Rate. =((End Value/Start ...

1
How to Calculate Principal and Interest on a Loan in Excel

PPMT Function in Excel to Calculate Principal The PPMT function calculates the principal of a financial product or service  (e.g. total investments, loans, ...

1
Calculate Moving Average for Dynamic Range in Excel (3 Examples)

The Moving Average is also known as the Rolling Average or Running Average in Excel. In this article, we will show you how to calculate the moving average for ...

1
VBA to Customize Row Height in Excel (6 Methods)

In this article, we will show you how to customize row height in Excel with a VBA macro, including how to set new row heights, change row height for a single ...

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,
    Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo