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 Calculate Intraclass Correlation Coefficient in Excel

This article will show you how to calculate Intraclass Correlation Coefficient (ICC) in Excel. What is the Intraclass Correlation Coefficient? The ...

0
How to Open Word Document and Save As PDF or Docx with VBA Excel

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. This article will show you how to open a word document, ...

0
Macro to Convert Excel to Pipe Delimited Text File (3 Methods)

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. This article will show you how to convert contents ...

0
VBA Code to Convert Text File to Excel (7 Methods)

The sample Text file named “Test File” contains random lines and Line breaks. We will learn how to convert this text file to a new Excel file with the same ...

0
VBA Code for Subtotal in Excel (3 Ways)

In generic terms, subtotal refers to the total of one set of a larger group of sets. Excel is widely used to store crucial numeric information of students or ...

0
VBA to Split String into Multiple Columns in Excel (2 Ways)

Sometimes we have to deal with pretty long strings in our Excel dataset and that is not quite convenient to work with always. Implementing VBA macro is the ...

0
Using VBA to Hide Rows Based on Cell Value in Excel – 14 Examples

  This is the sample dataset.   Example 1. Embed VBA to Hide Rows Based on Cell Text Value in Excel You want to hide rows that hold ...

0
VBA to Hide Rows Based on Criteria in Excel (15 Useful Examples)

Sometimes we need to hide some specific rows based on various criteria from our large dataset in Excel for better readability. Implementing VBA macro is the ...

0
VBA to Generate Multiple Lines in Email Body in Excel: 2 Methods

Method 1 - Embed VBA Macro to Generate Multiple Lines in Email Body in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...

0
Random Number Generator with Data Analysis Tool and Functions in Excel: 5 Methods

Method 1 - The Data Analysis Tool as a Random Number Generator in Excel Steps: Go to the tab Data -> Data Analysis. From the Data Analysis ...

0
How to Calculate Forecast Accuracy Percentage in Excel  – 4 Easy Methods

  Introduction to Forecast Accuracy Forecast Accuracy is the deviation between the forecast demand and the actual demand. It is also called ...

0
Using a VBA IF Statement with Multiple Conditions in Excel – 8 Methods

  Method 1 - Using a VBA IF Statement with Multiple Conditions: IF with OR The OR Function is an Excel built-in logical function that evaluates two or ...

0
How to Add Hyperlink to Cell Value in Excel Using VBA (4 Methods)

Method 1 - Embed VBA to Add Hyperlink from a Different Worksheet to a Cell Value in the Active Sheet: Let’s consider the following dataset: In our workbook, ...

0
Difference Between Sort and Filter in Excel

This article will describe in detail about Sort and Filter tool of Excel. The introduction, methods, examples, uses, and advantages to sort and filter data in ...

0
How to Print Multiple Excel Sheets in a Single PDF File with VBA (6 Methods)

We have an Excel workbook consisting of three worksheets. The first worksheet is Sheet 1, and the data is shown in the picture below. The second ...

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