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

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

To calculate Principal based on a loan, we need to execute Excel’s PPMT function, and to calculate Interest according to a loan amount, we need to apply ...

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)

Sometimes we need to modify rows when working on a large dataset in Excel for better readability. Implementing VBA is the most effective, quickest and safest ...

1
VBA to Hide Rows in Excel (14 Methods)

Sometimes we need to hide some specific rows when using our large dataset in Excel for better readability. Implementing VBA macro is the most effective, ...

1
VBA to Merge Cells in Excel (9 Methods)

In Excel, to merge multiple cells or ranges and make it as one singular cell, Range.Merge method is used. In this article, we will show you how to merge ...

0
How to Print Sheet on One Page in Excel (9 Easy Ways)

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If you know ...

0
How to Use VBA to Insert Row in Excel (11 Methods)

Sometimes we need to modify our large dataset in Excel by inserting rows according to specific requirements. Implementing VBA macro is the most effective, ...

0
VBA to Sort Table in Excel (4 Methods)

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to sort the ...

0
VBA to Sort Column in Excel (4 Methods)

To sort in Excel with VBA, you need to apply the Range.Sort method. In this article, we will show you how to sort the column in Excel with the Range.Sort ...

0
How to Remove Outliers in Excel (3 Ways)

Finding outliers and removing them is a very common task to analyze data in statistics, data mining, machine learning etc. There are so many ways that you can ...

0
How to Perform Custom Filter in Excel (5 Ways)

Excel sheets with massive datasets are hard to deal with. But if you can filter the dataset according to your specific need, then the task becomes quite easier ...

0
VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function in VBA is ...

0
VBA Format Function in Excel (8 Uses with Examples)

The Format function in Excel is a built-in function categorized as a String/ Text function. It is also used as a VBA function in Excel. In this article, we ...

0
VBA If – Then – Else Statement in Excel (4 Examples)

Conditional statements are used to perform a set of actions depending on the specified condition in programming languages. In this article, we will show you ...

0
How to Refresh Pivot Table with VBA in Excel (5 Examples)

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you how to refresh the ...

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