User Posts: Kawser

If you do not like without your permission no one can edit or update your Excel file, you can make your Excel file read-only. If you don't know how to make an ...

READ MORE +

In this article, I will show you how you can use Pivot Table data in Excel formulas.No data analyst can think a day without using Pivot Table in their day ...

READ MORE +

So, you're looking for free online Excel course with certificates.You're at the right place.On this page, I've listed 40+ free Excel courses (online ...

READ MORE +

Today’s post will be concerned with comments. We will be seeing how and when to use them. So let's get started.Firstly, you normally insert a comment to a ...

READ MORE +

In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook.It has ...

READ MORE +

Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives ...

READ MORE +

With this post, we shall be starting our Excel Table series. Today’s post, in particular, will give you an overview of the topic at hand and walk you through ...

READ MORE +

When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the range. ...

READ MORE +

Have you ever heard or seen the terms big data, business intelligence and Power BI being mentioned in analyst’s reports and financial newspapers? These days ...

READ MORE +

Where do financial modelers work? The world of finance can be a very complex place that at times is quite tricky to navigate. One has, for example, millions ...

READ MORE +

Do you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated? Well, the ...

READ MORE +

So, you know your SUM formula, you also know how to use the COUNTIF function. In addition, you are the go-to person at your office, when basic or intermediate ...

READ MORE +

Analyzing data, taking the business decision based on the data has become the core part of a business.Genius data analysts (with the help of world ...

READ MORE +

So, you're a beginner or intermediate user of Excel and searching for the best Excel books that will take you to somewhere from nowhere.You're at the right ...

READ MORE +

Videos, podcasts, kindle versions of books and online courses are the trend now. So, do you still need a book to learn Excel?Yes!Of course!You ...

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 January 28, 2018 at 11:09 AM

    Thanks for your feedback, Ven!

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

    Thanks, Menon for your valuable feedback.

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

    Mike,
    Thanks for your feedback 🙂
    Kind regards

  9. 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.

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

    Please check your email.

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

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

  12. 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 🙂

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

    Please check your mail.

  14. 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

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

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

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

    Thanks, Subbu!

  17. 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.

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

    Thanks for your feedback 🙂

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

    Thanks, Piotr! Glad to know it helps.

  20. 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.

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

    Thanks for the feedback, Prabhudeva!

  22. 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.

  23. 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.

  24. 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.

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

    Roger, please check your email.
    Thanks.

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

    Please check your email, Kaz!
    Thanks.

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

    Yes. Corrected.
    Thanks, Luke for the tips.

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

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

  29. 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

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

    Please check your email, Sohail!

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

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

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

    Please check the email 🙂

  33. 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

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

    It’s sent, check your email.

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

    Thanks, Mohan!

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

    Raja, any working file on that?

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

    Thank you, Jaypogi!

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

    Many thanks, Scott!

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

    Thanks, Sam! I will reach it to Zhiping 🙂

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

    Check your email please, Smith!

  41. 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!

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

    The working files are uploaded. Thanks!

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

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

  44. 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.

  45. 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

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

    Thanks Fina for sharing.
    Regards

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

    Please, check your email.
    Regards

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

    Please check your email.

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

    Cherie,
    Check your email, please.
    Regards

  50. 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

  51. 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?

  52. 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

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

    You can do that Ahmed. Thank you.
    Regards

  54. 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

  55. Reply
    Kawser July 23, 2016 at 4:54 PM

    Yes, I am going to include Dashboard techniques in my tutorial topics. Thanks Rukma for the suggestions 🙂

  56. 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 🙂

  57. 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!

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

    First Rate Work, Kadeo! Take my bow 😀

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

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

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

    Thanks for the input, specially for the VBA part!

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

    Cool 😀

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

    Great Answer!

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

    Please check your mail, Lilly.

  64. 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.

  65. 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.

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

    Please check your mail.
    Thanks and regards

  67. 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

  68. 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

  69. 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

  70. 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.

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

    Thanks Jan for your feedback.

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

    Thanks Orlando for updating me 🙂
    Regards
    Kawser

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

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

  74. 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.

  75. 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 🙂

  76. 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.

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

    It’s my pleasure Bob. Thanks for sharing.

  78. Reply
    Kawser September 23, 2015 at 12:24 PM

    Rakesh, it is so sad that you are facing a problem with ExcelDemy.com. Would you please like to explain the problem in more details? Which is annoying you? The welcome mat (the home page the site shows at first) or the download working files issue? If you are subscribed for one time, you will just bookmark the page and use whenever you need that. I would like to hear more from you. Thank you.

  79. 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.

  80. 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

  81. 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.

  82. 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 🙂

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

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

  84. 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.

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

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