DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
User Posts: Kawser

Effective Interest Method of Amortization Calculator (Free Download)

Kawser November 1, 2018

I made an Excel template that you can use as the effective interest method of amortization calculator. Download the template from the following link. ...

READ MORE +

Effective Interest Rate Method Excel Template (Free)

Kawser October 31, 2018

Effective Interest Rate Method Excel Template "No Macro used. No installation is necessary. Just download and start using." - Kawser Ahmed ...

READ MORE +

Effective Interest Method of Amortization in Excel

Kawser October 25, 2018

Effective Interest Method of Amortization in Excel (for bonds sold on discount) Effective Interest Method of Amortization in Excel (for bonds sold on ...

READ MORE +

How to calculate effective interest rate on bonds using Excel

Kawser October 16, 2018

In this blog post, I will discuss how to calculate the effective interest rate on bonds using Excel. What is the effective interest rate? If you know ...

READ MORE +

Nominal Interest Rate Formula Excel (calculate from Effective Rate)

Kawser October 11, 2018

Except learning the nominal interest formula Excel, we shall also cover several topics in this article. What will you learn from this article? What ...

READ MORE +

Mortgage payoff calculator with extra principal payment (Excel Template)

Kawser July 28, 2018

Mortgage Payment Calculator with Extra Principal Payment "No Macro used. No installation is necessary. Just download and start using." - ...

READ MORE +

Mortgage Payoff Calculator with Extra Payment (Free Excel Template)

Kawser July 19, 2018

Mortgage Payment Calculator with Extra Payment "No Macro used. No installation is necessary. Just download and start using." - Kawser Ahmed ...

READ MORE +

How to calculate periodic interest rate in Excel (4 ways)

Kawser July 1, 2018

In this short article, I will show how to calculate periodic interest rate in Excel. I will show 4 methods of calculating the periodic interest rate. ...

READ MORE +

Create a report that displays the quarterly sales by territory

Kawser June 27, 2018

In this article, I will create a report that displays the quarterly sales by territory. You can call it also a dynamic and interactive Excel dashboard that ...

READ MORE +

How to calculate IRR (internal rate of return) in Excel (9 easy ways)

Kawser June 11, 2018

In this article, I will discuss how to calculate IRR (internal rate of return) in Excel. I will focus on several topics like: Calculating IRR using ...

READ MORE +

How to add secondary axis in Excel (2 easy ways)

Kawser June 9, 2018

In this article, I will show you how to add secondary axis in Excel charts. Take a look at the following image. Above a regular chart, and below you’re seeing ...

READ MORE +

How to calculate monthly payment in Excel (with Excel calculator)

Kawser June 8, 2018

In this article, I will show you how to calculate monthly payment in Excel with some examples and criteria. Here are the criteria: You have got ...

READ MORE +

How to change the orientation of a worksheet to Landscape

Kawser June 5, 2018

Sometimes it is convenient to use Landscape page orientation rather than the default Portrait orientation, especially when you have data with a lot of columns. ...

READ MORE +

Using Excel to Lookup Partial Text Match [2 Ways]

Kawser June 3, 2018

In this article, I will show you how to use Excel to lookup for partial text match. For this, we can use VLOOKUP or INDEX MATCH functions combo. In the ...

READ MORE +

Excel formula to compare two columns and return a value (5 examples)

Kawser June 2, 2018

In this article, I will show you several techniques of using Excel formula to compare two columns and return a value. Your necessity might be different, so I ...

READ MORE +
Browsing All Comments By: Kawser
  1. Reply
    Kawser July 20, 2015 at 9:22 PM

    It’s my pleasure Rick. Nice to see you here and thanks for commenting!

  2. Reply
    Kawser July 29, 2015 at 4:06 PM

    Aziz Bro, thanks for your comments. Excel has extended its power more in recent times making Excel to work with Microsoft’s Power BI tools. I shall focus on them within very short time. Keep in touch. Thanks again.

  3. Reply
    Kawser August 26, 2015 at 5:18 AM

    Mohammed Hussain,
    Thanks for the comments 🙂

  4. Reply
    Kawser July 18, 2017 at 2:40 PM

    Thanks for notifying me. It was a technical mistake. I’ve uploaded them and you can download now. Thanks.

  5. Reply
    Kawser January 14, 2018 at 1:22 PM

    Hi Mark,
    Use the following formula instead of the formula you’re using.
    =DATEDIF($B$1,$B$2,”Y”)& ” years, “&DATEDIF($B$1,$B$2,”YM”)& ” months, “&ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)&” Weeks, and “&DATEDIF($B$1,$B$2,”MD”)-ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)*7&” Days.”
    Regards
    Kawser

  6. Reply
    Kawser February 12, 2020 at 8:29 PM

    Thanks for your input 🙂

  7. Reply
    Kawser January 15, 2020 at 4:42 PM

    Thanks for the feedback. Hope you will find this technique useful for your next some jobs.
    Best regards
    Kawser Ahmed

  8. Reply
    Kawser January 15, 2020 at 4:41 PM

    Nice to hear that you found this article helpful. Thanks for the feedback!
    Best regards

  9. Reply
    Kawser December 29, 2019 at 10:17 AM

    Please check your email.
    Thanks.

  10. Reply
    Kawser December 14, 2019 at 7:28 PM

    Hello Wasim,
    I am keeping this on my to-do list. Will try to give you a solution of your problem.
    Thanks.

  11. Reply
    Kawser December 9, 2019 at 1:56 PM

    Please checkout your email. Thanks.

  12. Reply
    Kawser December 4, 2019 at 10:11 AM

    Glad to know that this was helpful to you 🙂
    Best regards

  13. Reply
    Kawser November 26, 2019 at 9:16 AM

    Thanks for your feedback.

  14. Reply
    Kawser November 21, 2019 at 9:37 AM

    You can copy the article and paste in a word file and then use it personally. Thanks.

  15. Reply
    Kawser November 18, 2019 at 7:50 PM

    It is actually important 🙂 Thanks for your feedback.

  16. Reply
    Kawser October 31, 2019 at 9:09 AM

    You’re most welcome! Thanks for your feedback, Anthony!

  17. Reply
    Kawser October 24, 2019 at 9:06 AM

    You will also find the file in our article. The file is at the upper part of the article. You will find the file under this title: “Calculate Hours Worked and Overtime Excel Template”.
    Best regards
    Kawser Ahmed

  18. Reply
    Kawser October 16, 2019 at 8:33 PM

    You’re welcome, Florano!

  19. Reply
    Kawser October 10, 2019 at 12:59 PM

    Most welcome, Nilesh 🙂

  20. Reply
    Kawser October 10, 2019 at 12:58 PM

    Nice, Roger. I am glad to know that the formula helped you 🙂

  21. Reply
    Kawser October 8, 2019 at 12:37 PM

    Maybe it is due to the payment time. Do you pay at the beginning of the month or at the end of the month?

  22. Reply
    Kawser October 1, 2019 at 10:30 AM

    Thanks Chamila for your feedback!

  23. Reply
    Kawser September 26, 2019 at 7:06 PM

    Thanks for your feedback, Mdu!

  24. Reply
    Kawser July 25, 2019 at 6:33 PM

    You’re most welcome, Dennis!
    Thanks for the nice words.
    Best regards
    Kawser Ahmed

  25. Reply
    Kawser July 23, 2019 at 6:50 PM

    Check your email please.

  26. Reply
    Kawser July 18, 2019 at 6:20 PM

    Maybe a little bit tough for the complete layman. I shall change my Phrase then 🙂

  27. Reply
    Kawser July 15, 2019 at 8:02 PM

    Thanks for your good words, Dayo!
    Best regards
    Kawser Ahmed

  28. Reply
    Kawser July 10, 2019 at 8:25 PM

    It is sent. Thank you.

  29. Reply
    Kawser June 20, 2019 at 7:19 PM

    Thanks for the suggestion 🙂 I will keep it on my list.

  30. Reply
    Kawser June 13, 2019 at 6:16 PM

    Thanks for your Prayer, Shakeel!
    Best regards
    Kawser

  31. Reply
    Kawser June 8, 2019 at 2:24 PM

    When we have more than one files for an article, we make a compressed file.
    Hope you understand. Other articles that have just the Excel file to share, the download options are in Excel File.
    Best regards
    Kawser Ahmed

  32. Reply
    Kawser June 8, 2019 at 2:22 PM

    Thanks for your feedback!

  33. Reply
    Kawser June 8, 2019 at 2:21 PM

    It is sad to hear that you did not get the PDF. Just check your email.
    Thanks and regards
    Kawser Ahmed

  34. Reply
    Kawser June 8, 2019 at 2:20 PM

    I am keeping your note. Thanks, Jaime for your feedback.
    Best regards
    Kawser Ahmed

  35. Reply
    Kawser June 3, 2019 at 6:10 PM

    Glad to know that it helped you.
    Thanks and regards
    Kawser Ahmed

  36. Reply
    Kawser June 3, 2019 at 6:09 PM

    Thanks for your valuable input.
    Best regards
    Kawser Ahmed

  37. Reply
    Kawser May 30, 2019 at 5:02 PM

    Hi Gilbert,
    I am really sorry for not having PDF formats of the Articles.
    But you can make your own PDFs. Only thing is: you can use it personally. Not for commercial use, of course.
    Hope you understand.
    Thanks and regards
    Kawser Ahmed

  38. Reply
    Kawser May 29, 2019 at 4:54 PM

    Thank you so much for your input, Wayne! Hope this input helps my readers 🙂
    Best regards
    Kawser Ahmed

  39. Reply
    Kawser May 21, 2019 at 9:54 PM

    You’re welcome, Frank! Feeling good to hear that this article helped you.
    Best regards

  40. Reply
    Kawser April 22, 2019 at 9:43 PM

    Nice to hear that it helped you. Thanks and regards.

  41. Reply
    Kawser April 22, 2019 at 9:43 PM

    Nice to hear that it helped you. Thanks and regards.

  42. Reply
    Kawser April 15, 2019 at 1:32 PM

    Thanks, Sarabjeet Singh, for your feedback!

  43. Reply
    Kawser April 11, 2019 at 9:42 PM

    You’re welcome, Andrew 🙂

  44. Reply
    Kawser March 26, 2019 at 9:53 PM

    Thanks for your feedback 🙂

  45. Reply
    Kawser March 7, 2019 at 7:58 PM

    Thanks, Ferreira!

  46. Reply
    Kawser March 7, 2019 at 7:58 PM

    Thanks for your feedback 🙂

  47. Reply
    Kawser February 27, 2019 at 6:34 PM

    Thanks, FERREIRA for your feedback!

  48. Reply
    Kawser February 27, 2019 at 6:33 PM

    Thanks, Surya!

  49. Reply
    Kawser February 27, 2019 at 6:29 PM

    Please check out your email.
    Thanks.

  50. Reply
    Kawser February 23, 2019 at 1:52 PM

    I am sorry, I am not available for freelance.
    But you can contact our partner here: https://www.exceldemy.com/consulting-services/
    Thanks.

  51. Reply
    Kawser February 14, 2019 at 4:26 PM

    You’re most welcome 🙂 I am glad to know that our tutorials add some value to your life.

  52. Reply
    Kawser February 9, 2019 at 12:36 PM

    You can use the DATEDIF Function without any problem.
    Thanks.

  53. Reply
    Kawser January 31, 2019 at 9:25 PM

    Thanks for your feedback 🙂

  54. Reply
    Kawser January 30, 2019 at 1:26 PM

    Thanks a lot for your feedback. I will make plans to correct them. Best regards

  55. Reply
    Kawser January 22, 2019 at 3:58 PM

    I will check this issue and let you know. Glad to know that we can add some value via our emails.
    Best regards
    Kawser

  56. Reply
    Kawser January 19, 2019 at 8:00 PM

    Thanks, Ghosh for your feedback.

  57. Reply
    Kawser January 10, 2019 at 3:50 PM

    Thanks for your input, Greg.
    Best regards

  58. Reply
    Kawser January 9, 2019 at 1:06 PM

    Glad to know that you liked this article.
    Thanks for the feedback.

  59. Reply
    Kawser January 6, 2019 at 6:45 PM

    Glad to know that it helped you to learn something new.

  60. Reply
    Kawser January 3, 2019 at 12:40 PM

    Not right now. I will update when I will have one. Or if you have any specifications, let me know. I will make one for you.
    Thanks and regards
    Kawser

  61. Reply
    Kawser December 29, 2018 at 3:59 PM

    Hi,
    You can try to use the concepts in real-world problems.
    Thanks.

  62. Reply
    Kawser December 25, 2018 at 3:40 PM

    Please, download the working file (it’s free) to see if anything is missing in this article.
    Thanks.

  63. Reply
    Kawser December 15, 2018 at 1:59 PM

    Thanks for your feedback, JG. I will think about a method as per your necessity.
    Best regards
    Kawser

  64. Reply
    Kawser December 6, 2018 at 5:22 PM

    Thanks for your feedback 🙂

  65. Reply
    Kawser December 3, 2018 at 1:13 PM

    Thanks a lot for the feedback. I shall input this method when I will update this article later.

  66. Reply
    Kawser November 21, 2018 at 12:05 PM

    You’re welcome.
    Best regards

  67. Reply
    Kawser November 4, 2018 at 6:47 PM

    Thanks for your valuable comment. Unfortunately, right now I don’t have any dashboard like that. Maybe later.
    Thanks and regards

  68. Reply
    Kawser October 29, 2018 at 1:06 PM

    Thanks, Mittal!

  69. Reply
    Kawser October 25, 2018 at 9:47 PM

    Thank you so much for your feedback.
    Best regards

  70. Reply
    Kawser October 9, 2018 at 6:12 PM

    Thanks for your feedback.

  71. Reply
    Kawser October 7, 2018 at 3:21 PM

    Thank you for your valuable feedback. It’s something 🙂
    Best regards

  72. Reply
    Kawser September 6, 2018 at 12:23 PM

    Yes, Robert!
    Thanks for the feedback.

  73. Reply
    Kawser September 6, 2018 at 12:23 PM

    Thanks for your valuable feedback.

  74. Reply
    Kawser September 5, 2018 at 1:28 PM

    You’re most welcome, Sola.
    Thanks for your feedback.

  75. Reply
    Kawser September 4, 2018 at 6:26 PM

    Thanks for your feedback. Glad to know that it helps you.

  76. Reply
    Kawser September 1, 2018 at 2:20 PM

    Thanks, Melinda!
    Yes, it was a typo and I have corrected it.
    Best regards
    Kawser

  77. Reply
    Kawser September 1, 2018 at 2:17 PM

    Thanks, Mark.

  78. Reply
    Kawser September 1, 2018 at 2:17 PM

    Hi Helen,
    Thanks for the feedback.
    And I will work with the click-baits to make it more user-friendly.
    Thanks and regards

  79. Reply
    Kawser August 28, 2018 at 12:28 PM

    Thank you for your feedback, Anirudh!
    Best regards

  80. Reply
    Kawser August 8, 2018 at 10:46 AM

    You’re welcome.

  81. Reply
    Kawser August 8, 2018 at 10:45 AM

    Ram,
    I have a list of Excel books that is good for learning Excel from the beginning. Please visit this page: https://www.exceldemy.com/best-excel-training-books/
    The best is obviously the Excel Bible Series. You will get the link on the page. If you talk about Video Channel, it is tough to find one as most of them don’t start from the beginning. But if you search for a topic, there are several. One of the best is ExcelIsFun YouTube channel. I hope it helps.
    Best regards
    Kawser

  82. Reply
    Kawser August 7, 2018 at 5:28 PM

    Hi David,
    Check our your email.
    Thanks.

  83. Reply
    Kawser August 7, 2018 at 5:24 PM

    Hi Mike,
    Check out your email.
    Thanks.

  84. Reply
    Kawser July 18, 2018 at 8:17 PM

    It is sent. Check out your email.

  85. Reply
    Kawser July 17, 2018 at 2:38 PM

    Thanks, Emil!

  86. Reply
    Kawser July 4, 2018 at 12:17 PM

    You have to use VBA or you can use Power Query.

  87. Reply
    Kawser June 25, 2018 at 4:16 PM

    You are welcome.

  88. Reply
    Kawser June 25, 2018 at 11:55 AM

    Hi Daniel,
    Thanks for your feedback.
    Yes. INDEX and MATCH combo work in a more versatile way than the VLOOKUP function. I did not use Index Match because I wanted to show all the examples with VLOOKUP and IF Functions.
    Keep in touch.
    Best regards
    Kawser

  89. Reply
    Kawser June 23, 2018 at 4:53 PM

    Thanks for your feedback, Uche Uche.
    Feeling happy to know that you found the articles helpful.
    Best regards
    Kawser Ahmed

  90. Reply
    Kawser June 21, 2018 at 12:28 PM

    I will check out this code. Thanks for the input.

  91. Reply
    Kawser June 21, 2018 at 12:28 PM

    Thanks for your feedback, George!

  92. Reply
    Kawser June 13, 2018 at 12:36 PM

    Please check your email. I have sent the file. Thanks and sorry for the inconvenience.

  93. Reply
    Kawser June 7, 2018 at 11:35 AM

    You can collect it from our resource page. The resource page is shared with every subscriber, every day.
    Best regards
    Kawser Ahmed

  94. Reply
    Kawser May 31, 2018 at 10:57 AM

    Glad to know that it was helpful.
    You’re welcome 🙂

  95. Reply
    Kawser May 30, 2018 at 8:30 PM

    You are welcome, Chandrasekhar! Glad to hear that our tips help you.
    Best regards

  96. Reply
    Kawser May 29, 2018 at 7:50 PM

    I will update you.
    Best regards
    Kawser

  97. Reply
    Kawser May 29, 2018 at 7:46 PM

    Hi Stanley,
    Thanks for the comments. Glad to hear that it is helpful. Yes. You can share it with an online class with an attribution to our blog.
    Best regards

  98. Reply
    Kawser May 29, 2018 at 11:27 AM

    James, thanks for your feedback.
    Glad to hear that it was useful for you.
    Regards

  99. Reply
    Kawser May 17, 2018 at 12:36 PM

    Hi Anatoly,
    We have written a detailed guide on solving equations using Excel. You will get the guide here: https://www.exceldemy.com/solving-equations-in-excel/
    If you have some specific equation, let us know via email.
    Thanks and regards.

  100. Reply
    Kawser May 16, 2018 at 11:11 AM

    Hi Moataz,
    Thanks for the feedback on our blog.
    Actually, this is not a big deal. The concepts are same with both Excel 2013 and Excel 2016. Most of the variations/updates occur with the Excel features, not in VBA. Just start with what most suit you.
    I hope this reply helps you.
    Thanks and regards

  101. Reply
    Kawser May 8, 2018 at 1:32 PM

    Thanks for asking. It was creating more indexed pages in Google that was bad for us. What you can do is: just you can copy the whole article and paste into a word document and then convert it into a PDF file. There is little chance of getting back of that button.
    Best regards

  102. Reply
    Kawser May 8, 2018 at 1:29 PM

    That is really a good percentage of reduction. Thanks for the feedback, Abraham.

  103. Reply
    Kawser April 26, 2018 at 8:28 PM

    Hi Ajeet,
    Then you can download it from the Excel Resources Page that you get in every email I send.
    Thanks.

  104. Reply
    Kawser April 24, 2018 at 2:14 PM

    Hi Ahmad,
    You’re welcome. Glad our blog posts help you master Excel topics.
    I have updated this part. For your clarification: the condition 1 must be fulfilled to be eligible to take the thesis work/project. Of the last conditions, students must fulfill one condition. I hope this makes things clear to you.
    Best regards
    Kawser

  105. Reply
    Kawser February 22, 2018 at 11:53 AM

    Thanks. Glad to know that you found it useful.

  106. Reply
    Kawser February 20, 2018 at 5:25 PM

    Thanks, Farhana for the feedback.

  107. Reply
    Kawser January 28, 2018 at 11:09 AM

    Thanks for your feedback, Ven!

  108. Reply
    Kawser December 19, 2017 at 7:56 PM

    Thanks, Menon for your valuable feedback.

  109. Reply
    Kawser October 25, 2017 at 3:37 PM

    Mike,
    Thanks for your feedback 🙂
    Kind regards

  110. Reply
    Kawser September 12, 2017 at 1:20 PM

    Nope, Jan. You’re absolutely right. Excel can be used as a database when your database is not heavy and need a small load of query on it.

  111. Reply
    Kawser September 11, 2017 at 12:11 PM

    Please check your email.

  112. Reply
    Kawser August 3, 2017 at 8:18 PM

    Hi John,
    Sometimes discounts expire. Now the discounts are available. Thanks for your feedback.

  113. Reply
    Kawser July 14, 2017 at 9:34 PM

    Thanks for your feedback. Best wishes with your new journey 🙂 Excel, Word, and PPT are three most powerful office tools. I’m sure, you will enjoy your journey 🙂

  114. Reply
    Kawser July 6, 2017 at 6:31 PM

    Please check your mail.

  115. Reply
    Kawser June 17, 2017 at 3:49 PM

    Hi Bob,
    Did you download the Excel file before you follow me? Please do so. I’ve explained the whole process with two real time examples. If you can create these two examples in the Excel file, I hope you will be able to understand the whole system.
    Best regards
    Kawser

  116. Reply
    Kawser June 5, 2017 at 10:13 AM

    Check out trying. I never tried. If you face any problem, let us know 🙂

  117. Reply
    Kawser June 4, 2017 at 1:44 PM

    Thanks, Subbu!

  118. Reply
    Kawser April 3, 2017 at 9:02 PM

    Glad to know that it helps. The file is at the end of the article. Just click and download.

  119. Reply
    Kawser March 3, 2017 at 6:55 PM

    Thanks for your feedback 🙂

  120. Reply
    Kawser February 27, 2017 at 12:46 PM

    Thanks, Piotr! Glad to know it helps.

  121. Reply
    Kawser January 30, 2017 at 7:36 PM

    Syed,
    Sometimes when the formula is posted in WordPress platform, it might be changed. Please, download the working file and check the formula there.

  122. Reply
    Kawser January 15, 2017 at 1:23 PM

    Thanks for the feedback, Prabhudeva!

  123. Reply
    Kawser December 18, 2016 at 11:55 AM

    Roger, thanks a lot. I did not notify the issue. It’s a crucial problem. I am working on it.

  124. Reply
    Kawser December 14, 2016 at 9:37 AM

    Yes, when a number or date is placed in a cell in Text format, you cannot calculate with them.

  125. Reply
    Kawser December 14, 2016 at 9:36 AM

    Roger, this option (make PDF of the blog posts) is on my plan. Will execute in shortest possible time.
    Best regards and thanks for the comments.

  126. Reply
    Kawser November 23, 2016 at 10:22 AM

    Roger, please check your email.
    Thanks.

  127. Reply
    Kawser November 12, 2016 at 3:26 PM

    Please check your email, Kaz!
    Thanks.

  128. Reply
    Kawser November 7, 2016 at 11:10 AM

    Yes. Corrected.
    Thanks, Luke for the tips.

  129. Reply
    Kawser November 6, 2016 at 11:13 AM

    It’s a good idea, Rahul. I will think about it soon.
    Best regards
    Kawser

  130. Reply
    Kawser October 29, 2016 at 6:15 PM

    Spoo,
    I would recommend starting with Excel 2016 (or 2013) if you’re just starting. It’s better to be updated with time.
    Yes, some are still using Excel 2003 but that is not a good idea. They are missing a lot of new features Microsoft has added to this superb tool later.
    Regards

  131. Reply
    Kawser October 29, 2016 at 10:45 AM

    Please check your email, Sohail!

  132. Reply
    Kawser October 29, 2016 at 10:45 AM

    I will pass your request to the author, Jagadeesh!
    Glad to know it helped you!

  133. Reply
    Kawser October 28, 2016 at 9:39 PM

    Please check the email 🙂

  134. Reply
    Kawser October 28, 2016 at 9:30 PM

    Hey Tricia,
    I checked several times the link. There is no problem with the link 🙂 This is not a direct download link. You have to subscribe to get the cheat sheet. I hope you should not be embarrassed with the shared link.
    Best regards
    Kawser

  135. Reply
    Kawser October 13, 2016 at 12:56 PM

    It’s sent, check your email.

  136. Reply
    Kawser October 13, 2016 at 12:55 PM

    Thanks, Mohan!

  137. Reply
    Kawser October 9, 2016 at 11:26 AM

    Raja, any working file on that?

  138. Reply
    Kawser October 4, 2016 at 7:48 PM

    Thank you, Jaypogi!

  139. Reply
    Kawser September 29, 2016 at 8:20 PM

    Many thanks, Scott!

  140. Reply
    Kawser September 20, 2016 at 1:28 AM

    Thanks, Sam! I will reach it to Zhiping 🙂

  141. Reply
    Kawser September 15, 2016 at 11:21 AM

    Check your email please, Smith!

  142. Reply
    Kawser September 10, 2016 at 3:41 PM

    Armen, files are uploaded. Please let me know whether the concept is clear to you or not!

  143. Reply
    Kawser September 10, 2016 at 3:41 PM

    The working files are uploaded. Thanks!

  144. Reply
    Kawser September 6, 2016 at 2:03 AM

    Jack, I have notified it to the writer. She will answer soon 🙂

  145. Reply
    Kawser August 25, 2016 at 10:02 AM

    If cell A1 holds your string “BCD” and you want to show “AAAAAAABCD” in cell B1, input this formula in cell B1: =REPT(“A”, 10-LEN(A1))&A1.
    To solve this problem, you don’t have to use any looping. Or, do you have some other requirement for this problem? Let me know.
    Best regards.

  146. Reply
    Kawser August 25, 2016 at 2:01 AM

    Cindy,
    Millions of thanks for correcting me. It was a grand mistake. Sorry for that. You can buy the course now for just $10 using the above link.
    Best regards

  147. Reply
    Kawser August 21, 2016 at 3:23 PM

    Thanks Fina for sharing.
    Regards

  148. Reply
    Kawser August 16, 2016 at 3:10 AM

    Please, check your email.
    Regards

  149. Reply
    Kawser August 16, 2016 at 3:10 AM

    Please check your email.

  150. Reply
    Kawser August 6, 2016 at 1:28 AM

    Cherie,
    Check your email, please.
    Regards

  151. Reply
    Kawser August 1, 2016 at 10:50 AM

    Borb,
    I tried to reach you to your email address but it is showing the mail cannot be reached.
    How can I help you?
    Regards
    Kawser

  152. Reply
    Kawser August 1, 2016 at 10:39 AM

    Kateryna,
    Thanks for your kind words. Glad to know that it helps.
    You will get empty cells if no data is available for the filtering. What criteria did you use to filter data in intervals?

  153. Reply
    Kawser August 1, 2016 at 10:34 AM

    Waleed,
    Can you upload the working files of your problems? At least a sample file? If possible send an email to this address kawser@exceldemy.com

  154. Reply
    Kawser August 1, 2016 at 10:33 AM

    You can do that Ahmed. Thank you.
    Regards

  155. Reply
    Kawser August 1, 2016 at 10:32 AM

    Baber,
    I have sent you an email with instructions. Please check. I hope the email solves the problem.
    Regards

  156. Reply
    Kawser July 22, 2016 at 12:13 AM

    Thanks for the input, Jomili.
    Yes, the formulas are identical as every criterion in the Criteria range is unique. I am going to add the note there 🙂

  157. Reply
    Kawser July 16, 2016 at 1:10 PM

    Mike, you did a phenomenal job! Thinking in that way, awesome and the alternative!; Hats Off!

  158. Reply
    Kawser July 16, 2016 at 12:41 PM

    First Rate Work, Kadeo! Take my bow 😀

  159. Reply
    Kawser July 16, 2016 at 12:40 PM

    Yes, Menon! It’s a nice solution and more generic!

  160. Reply
    Kawser July 16, 2016 at 12:39 PM

    Thanks for the input, specially for the VBA part!

  161. Reply
    Kawser July 16, 2016 at 12:38 PM

    Cool 😀

  162. Reply
    Kawser July 16, 2016 at 12:37 PM

    Great Answer!

  163. Reply
    Kawser July 5, 2016 at 11:04 AM

    Please check your mail, Lilly.

  164. Reply
    Kawser June 11, 2016 at 12:26 PM

    Please check the mailbox. I have sent you an email with the direct download link of the resources.

  165. Reply
    Kawser June 11, 2016 at 12:23 PM

    Please check the mailbox. I have sent you an email with the direct download link of the resources.

  166. Reply
    Kawser April 5, 2016 at 5:15 PM

    Please check your mail.
    Thanks and regards

  167. Reply
    Kawser March 4, 2016 at 10:36 AM

    Hi Gina,
    Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.
    Best regards
    Kawser

  168. Reply
    Kawser February 24, 2016 at 1:10 AM

    Hello Rush,
    Thanks for your feedback 🙂
    If you are an email subscriber of my blog, then you would have access to all my data sets (workbooks or anything else) that I use to make the blog posts.
    Regards
    Kawser Ahmed

  169. Reply
    Kawser February 18, 2016 at 11:07 AM

    Hi Roger,
    Thanks for your feedback. Nice to meet an Excel Pivot Table ninja 🙂 If you like you can share your ninja skills with my audience.
    Regards

  170. Reply
    Kawser February 15, 2016 at 12:07 PM

    Hi Roger,
    Please check your inbox. Sorry for the inconvenience you are facing.
    Thanks and regards.

  171. Reply
    Kawser February 1, 2016 at 6:37 PM

    Thanks Jan for your feedback.

  172. Reply
    Kawser January 26, 2016 at 12:39 AM

    Thanks Orlando for updating me 🙂
    Regards
    Kawser

  173. Reply
    Kawser January 12, 2016 at 1:15 AM

    Vikas,
    Glad to know you liked it. Thanks for your feedback.
    Regards

  174. Reply
    Kawser December 31, 2015 at 1:30 PM

    Puneet, thanks for the comment. I like your presentation in your blog.
    Wishing you the best output in year 2016.

  175. Reply
    Kawser December 25, 2015 at 9:58 PM

    OZ thanks for your feedback. I am going to write these types of posts like a series. Your comments made me more inspired 🙂

  176. Reply
    Kawser December 2, 2015 at 5:23 PM

    Praveen,
    Would you please mail me the database and other resources using the mail in the contact me page?
    Thanks.

  177. Kawser November 29, 2015 at 11:59 AM

    It’s my pleasure Bob. Thanks for sharing.

  178. Reply
    Kawser September 4, 2015 at 3:23 PM

    Narendra, if you feel any way I can update my website, please let me know.
    Thanks and regards.

  179. Reply
    Kawser August 19, 2015 at 12:31 AM

    Shivaji,
    Right now I have no book on Microsoft Access. But just subscribe my Email list using the below link, you will get two books on Excel: 1200+ Macro Examples E-Book, 220+ Excel Keyboard Shortcuts E-Book and other Excel resources.
    http://www.eepurl.com/bqFItv

  180. Reply
    Kawser August 19, 2015 at 12:27 AM

    Shivaji,
    It is my achievement when a person says me that I helped him/her in some way. Thanks. Keep in touch.

  181. Reply
    Kawser August 1, 2015 at 3:07 AM

    Glad to hear that my website is helping you in a way.
    It’s my pleasure Mohammed Hussain. Keep in touch 🙂

  182. Reply
    Kawser February 27, 2015 at 8:01 PM

    In the Download Section, you will get the Workbook: production-model-scenarios.xlsx.

  183. Reply
    Kawser February 27, 2015 at 7:59 PM

    Rajesh,
    If you’ve given names to the changing cells and result cells, the table uses these names; otherwise, it lists the cell references. Just use some names for the cell references B13, C13, D13 and B15 in the Sheet1 Worksheet in the provided Workbook. Then create the Summary Report again. You will get the result cells using some names.

  184. Reply
    Kawser October 10, 2014 at 6:58 PM

    It’s my pleasure you liked the article. Thanks for the nice comment. Best regards.

About ExcelDemy.com

ExcelDemy is a place where you can learn Excel, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide Excel solutions to your business problems.

DMCA.com Protection Status

ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon.

Contact | Privacy Policy

Categories