Nehad Ulfat

About author

NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.  In this role, he creates techy content all about Excel and VBA. Later, he was promoted and worked as a project portfolio manager at ExcelDemy in SOFTEKO. You'll find him reading books, travelling, and watching documentaries outside work.


Project Portfolio Manager at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Naval Architecture & Marine Engineering, BUET.


ABACUS, AutoCAD, Rhinoceros, Maxsurf, Hydromax, Excel, Word and PowerPoint


  • Technical Content Writing
  • Team Management
  • Project Management


  • He is currently working as Project Portfolio Manager at ExcelDemy in SOFTEKO.
  • He started writing technical content for Excel & VBA for ExcelDemy in March 2021.
  • He started working as a Team Leader at ExcelDemy.
  • He was promoted to Project Manager at ExcelDemy in 2022.

Latest Posts From Nehad Ulfat

INDEX-MATCH Formula to Find Minimum Value in Excel (4 Ways)

INDEX and MATCH functions are two of the most common functions in Excel chores to search for as well as store different data from a large array. In this ...

How to use SUMPRODUCT Function with Multiple Columns in Excel (4 Suitable Approaches)

SUMPRODUCT is one of the most powerful array functions in Microsoft Excel that can pull out data from an array based on the criteria along multiple columns ...

Excel Formula to Find Date or Days for Next Month (6 Quick Ways)

Microsoft Excel has provided a wide range of date and time-related functions that we can use to find dates, days, or some other time-related data for next ...

How to Calculate YTD (Year to Date) in Excel [9 Simple Ways]

The sample workbook will provide a few different scenarios for when you need to calculate YTD in Excel, such as YTD price, profit, or growth rate. ...

How to Use the SUMPRODUCT with INDEX and MATCH Functions in Excel

Introduction to the Functions: SUMPRODUCT, INDEX and MATCH (with Examples) Before delving into how these three powerful functions work together, let’s ...

How to Sum Based on Column and Row Criteria in Excel (7 Ways)

There is a wide range of suitable methods to sum up a range of cells based on column and row criteria in MS Excel. In this article, we’ll try to illustrate how ...

How to Use COUNTIFS to Count Across Multiple Columns in Excel

There are many default Excel functions that we can use to create formulas. The COUNTIFS function provides plenty of opportunities to count cells under ...

Excel COUNTIF Function to Count Cells Greater Than 0

COUNTIF function is one of the most basic & simple operations in MS Excel that can be used to count 0 (Zero), greater than 0, or less than 0 under lots of ...

Excel SUMPRODUCT Function to Count Unique Values with Criteria

Using the Excel SUMPRODUCT function to count unique values with criteria means counting unique numbers or texts based on single or multiple conditions from a ...

How to Use the Excel COUNTIF Function with Multiple Criteria in Different Columns – 4 Examples

Excel COUNTIF function searches for a single criterion in a given range and returns its total number of occurrences. Consider the following sample ...

How to Extract Unique Values Based on Criteria in Excel

Extracting unique values based on single or different criteria is very common in offices & businesses. Microsoft Excel has also added a few useful & ...

How to Round up Decimals in Excel (5 Simple Ways)

Microsoft Excel has provided a number of very easy, quick & useful methods to round up the decimals to a particular point or limit. In this article, I’ll ...

How to Extract Only Numbers from Excel Cell (7 Easy Ways)

Although Microsoft has not provided a straight formula or syntax to extract only numbers from the Excel cell, we can incorporate a wide range of Excel formulas ...

Excel Formula to Copy Cell Value from Another Sheet (4 Examples)

  Method 1 - Using the Copy and Paste tool to Copy a Cell Value Including Excel Formula From Another Sheet In our dataset, we have 2 columns (Columns D ...

How to Keep Leading Zeros in Excel (10 Suitable Methods)

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros & ...

Browsing All Comments By: Nehad Ulfat
  1. Hi, Marian. All our Excel-related contents on this website have been made using Excel 365. I suggest you try the formulas in Excel 365 or Excel 2021 version. Thanks!

  2. Hello, Kim! You can contact him through this email address:
    [email protected]

  3. Hello, Stefano! Can you please share your queries in English? Thanks!

  4. Thanks for mentioning, Ehsan! Pardon our mistake, we’re uploading it within next 24 hours!

  5. Hello. Tabuaka! You can check out our practice problems which should help you to get familiar with Excel works!

  6. Hello, Ali! Click here to autoscroll and you’ll find the download links for both pdf and xlsx formats.

  7. Hello, James Garang! There’re two download links available just after the table of contents in this article. You can download pdf or xlsx version whatever you need!

  8. Hi, Bruce Ritch! Glad to know it helped you! 🙂

  9. Great to know it helped you!

  10. Hello, Barry! You can check your default path folder for browser downloads. And if you need any assistance with the Excel problems you can mail us!

  11. Glad to know it helped you, Kadiri!

  12. Glad to know it helped you!

  13. Glad to know it helped in your work!

  14. Hello, Missy! Please send us your problems here: [email protected]

  15. Hello, ABDELAZIZ SALIH ABDELLAH ADAM! You can check out the following link to get access to some of our learning resources related to MS Excel.

  16. Hi Mohammad Sayed! Glad to know it helped you!

  17. Hello, Lalit Kansal! You can send us your attachment to this email: [email protected]

  18. Hello, John! Can you please email us the Excel file containing the dataset with the problem? We’ll look into it & try to solve it asap.

  19. Thanks for your feedback, Carol! Best regards.

  20. Hello, TRYSTAN! Can you please email us your Excel file containing the dataset with the problem? Thanks.

  21. Hello, OLUNIYI! Can you please email us your Excel file containing the dataset with the problem?

  22. Hi, NOHEMI WEST-PHELPS! Can you please email us the Excel file containing the problem with the dataset?

  23. Hello, ARIZONA AMBER! To enable Developer tab, you have to follow this procedure: Go to Excel Options > Customize Ribbon > Customize the Ribbon > Main Tabs > (Check) Developer tab.

  24. Hello, MAUREEN E CLAYCOMB! You can mention the keywords or problem here, we’ll try to prepare & publish the article within 2-3 days.

  25. Hello, SR! Thanks for your recommendation. We’ll cover this part & give you an update soon.

  26. Hello, KRISHNAN V! Thanks for your feedback. Hope you’ll find our other articles useful as well when needed for your works!

  27. Hello, OPIYO DENIS OCAYA! You can download our practice workbook and use it as a calculator which is quite similar to using an app instead!

  28. Hello, Mary Visco! The downloadable file has been sent to your gmail address. If you can’t find the mail in inbox then please look for it in spam folder. Best regards!

  29. Hello, GOKTUG! All of our contents were prepared based on Excel 365 version only. So, I recommend using the Excel 365 version instead of 2019. Hopefully it should fix your issues!

  30. Hello, Sanooj Kumar! When this content was prepared, we used Excel 365 version. Could you please try out the similar version?

  31. Hello, RUBAN! You can send your Excel Macro related problem to this email: [email protected]. We’ll start working on your problem as soon as we receive your mail! Thanks.

  32. Hello, JUAN! Glad to know you’ve found the solutions finally from our article!

  33. You’re welcome, RAAA1987! Best regards!

  34. Hi, ETHAN! Hope, the solutions have worked for you!

  35. Hello, PIET STRYDOM, you can check out this link to learn VBA programming step by step! Thanks!

  36. You’re welcome, CHRIS! Best regards!

  37. Thanks, SANDEEP! Best regards!

  38. Hello, Nick! Right now we’re not working with Mac so unfortunately we’re unable to provide you with the exact solutions.

  39. You’re welcome, ZAFER!

  40. Thanks, AJAY!

  41. You’re welcome, LAUREN! I hope, you’ll find more other solutions in our blog related to Excel problems in future!

  42. Thanks, TODD! Good to hear from you!

  43. Hello Jess, you’re most welcome! If you need any other solutions to more problems you can also email us.

  44. You’re most welcome, Ovi! We’re always trying hard to deliver the best possible solutions to our readers.

  45. I think your query should meet the requirements in methods 2.2 to 2.4. You can use any of them while dealing with similar numeric values. If it yet does not fulfill your criteria, then let me know. I’ll catch you up as soon as possible!

  46. Hi Roberto,
    If you write “=IF(A2“”,NOW(),””)” in Cell B2, then the timestamp in Cell B2 will update for each input name in the following cells(A3,A4,…….). To fix timestamp for each entry, you have to type “=IF(A2””,IF(B2=””,NOW(),B2),””)” in Cell B2.

Advanced Excel Exercises with Solutions PDF