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)

When we are dealing with a large amount of data in Excel, sometimes we want to cite/reference certain texts from one cell to another for better understanding. ...

0
VBA Conditional Formatting Based on Another Cell Value in Excel

When we are dealing with a large amount of data in Excel, sometimes we want to format the dataset in certain conditions for better readability. Implementing ...

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

A checkbox is a field that performs according to the input. Implementing VBA is the most effective, quickest, and safest method to run any operation in Excel. ...

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
Excel VBA to Count Blank Cells in Range (3 Methods)

When we have a large amount of data in our Excel worksheet, it is easier if we have the knowledge of the total counts of certain ranges of the sheet. ...

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

When we are dealing with multiple Excel sheets, sometimes we have to copy data from one spreadsheet to another with certain conditions for better readability. ...

0
VBA to Delete Every Other Row in Excel (6 Criteria)

When we have a large amount of data with lots of unnecessary rows in our Excel worksheet, it is hard to understand sometimes. If we remove the rows that we ...

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
VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

Sometimes we need to re-organize columns into rows when working on a large dataset in Excel for better readability. Implementing VBA is the most effective, ...

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

Turnaround time is a very common concept in various aspects such as Education, Work, etc. of our life. You can learn how to Compute Turnaround Time (TAT) in ...

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 Annual Growth Rate in Excel (3 Methods)

To calculate annual growth over multiple periods, Compound Average Growth Rate (CAGR) and Annual Average Growth Rate (AAGR) are the two most common and ...

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