User Posts: Kawser
0

Spreadsheet software is a computer program (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very simple to ...

0

How to Show, Hide, & Customize Excel Ribbon

In this tutorial, you are introduced to Excelâ€™s Ribbon feature. Excel ribbon makes your work faster and smoother. After reading this article you will be able ...

0

How to reference a cell from a different worksheet in Excel

Before understanding this topic, you have to understand cell reference in a formula. Say I have a formula like this â€˜=B3*C3+D3â€™. In this formula there are ...

0

How to use cell references with multiple worksheets in Excel

Before understanding this topic, you have to understand cell reference in a formula. Say I have a formula like this â€˜=B3*C3+D3â€™. In this formula there are ...

0

What is and How to Do Absolute Cell Reference in Excel?

In this article, I will discuss what is an absolute reference and how to do absolute reference in Excel? Then I will show how you can shift from one type of ...

0

Relative cell references in Excel

Before understanding relative cell references, you have to understand cell references in a formula. Say I have a formula like this â€˜=B3*C3+D3â€™. In this formula ...

0

What is an Active Cell in Excel?

What is an active cell in Excel? How to make a cell active in Excel? Can more than one cell work as an active cell at the same time? You will get all of these ...

0

What is cell in Excel definition

Every Excel worksheet/spreadsheet consists of columns and rows. The intersection of columns and rows make cells in Excel. Columns are labeled from A to XFD and ...

0

Keyboard Shortcuts for Moving around Excel Spreadsheets

We shall discuss here the various ways and keyboard shortcuts to move the cells in an Excel Spreadsheet. Every Excel worksheet/spreadsheet consists of ...

0

You will do all your works in a workbook file. You can add as many worksheets as you need in a workbook file. Each worksheet appears in its own window. By ...

0

Excel 2013 New Features

The new version of an application comes with new features. Microsoft Excel 2013 (part of Microsoft Office 2013 suite) also has come with some unique and ...

0

What is Excel Used for in the Workplace?

Excel has been the world standard for many years. Excel is popular as it is versatile. â€˜Excel is versatileâ€™â€“ which means that you can do many things with ...

0

What is spreadsheet and how it works

A spreadsheet is basically a worksheet which is divided into rows and columns to store data; data from business inventories, income-expense report, and ...

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

2. 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. Mohammed Hussain,

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

5. 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. Hi Andrea,
Here is an article for your problem: https://www.exceldemy.com/number-of-days-between-two-dates-excel/
Check out this part of the article “How to Calculate Age in Excel”.
Thanks and regards

7. I have to check, Glen. Thanks.

8. Thanks for your feedback, we shall check the issue.

10. This is not completely automatic, Lea!

11. This is not completely automatic, Lea!

12. The formula is working at our end perfectly. You can download the workbook where we did the whole thing and cross-check, please.

13. Hi Alexa,
Best regards

14. Hi Michael,

15. Send your problem to this email: [email protected]

16. Thanks for your feedback. You have to use another formula to do that.

17. No problem. Send the file to this email: [email protected]
Thanks.

18. You’re most welcome, Sumit!

19. I will gladly help if I am able. [email protected] Thanks.

21. OK, Nancy, I am keeping at our note, we shall develop a template as you require. Thanks for your feedback.

22. I think it will handle those criteria. Thanks. If it does not, let us know your problem, we shall make a template on the basis of the criteria.

23. The best way is, please send the sheet to me at [email protected]

24. Hello,
Without seeing the worksheet, it is tough to say. Can you share the file or at least a screenshot of the data?
Thanks.

25. Best regards, Mario!

26. Thanks, James!

27. Hi Kaitlin,
Can you please share your Excel sheet with me? Here is the email: [email protected]. Thanks.

28. Thanks, Crispo, for your feedback.

29. Hi Craig!
Just use the MAX function in the first column, you will get the largest number from the column.
Best regards

30. Hi Don,
Thanks. If you need anything you can let me know, I will tweak the Template for you.
Best regards

31. Hi Sherry,
If you can send us the resources, we can help you. Thanks.

32. Can you send me the Excel sheet to this email [email protected]? I will take a look at your problem.

33. Hi Justin,
Thanks for notifying this. I will check and update the article.
Regards

34. Thanks, Mike for your nice comment.

35. If you’ve some specific problem, let us know via email, we shall try to make a blog post with your problem.

36. Hello, if you give us your complete requirements, we can build it for you. Thanks.

37. Hi Denny,
I am using Microsoft 365 (Home) and it is working on my side perfectly. Please try again.
Thanks.

38. We shall cover this topic soon.
Thanks.

39. Not yet, Walt!
But we shall start making a lot of templates in the coming months. If you need any, you can let us know.

40. Hi Jon,
I am going to add it.
Best regards

41. Hi Ahmed,
I am keeping a note of your problem, hope we shall be able to make a solution to this.
Thanks.

42. I am taking a note of your suggestion. Thanks.

43. Hi James,
I am taking note of your problem, and we shall make templates based on your criteria.
Thanks and regards
Kawser Ahmed

44. Hi Mike,
I am taking note of your problem, we shall make templates on the basis of your needs.
Thanks.

45. Hi Greg,
That is really good input from you. Hope your piece of code will help people who are in trouble. Cheers!
Best regards

46. Thanks, Pedja for your feedback.
Best regards.

47. Thanks.

48. I am keeping a note of your problem. Thanks.

49. Thanks, Uche.

50. Hi,
If we make a template for that problem, I will email you. Thanks.

51. Hi Kkrao,
It is possible for small numbers to count the top ones, but if you have good numbers in a list, you might need an automatic process. And sometimes, you might need the output to feed a system’s input, so I hope you get my point for making a formula for this.
Thanks.

52. Wayne,

53. Hi Manzis,
Thanks.

54. Kanhaiyalal, thanks for your wonderful feedback.
Best regards

55. Hi Tony,
Thanks.

56. You’re most welcome. Glad to know that it helped you.

58. You’re most welcome, Obuo!

59. A great pleasure for me. Thank you.

60. Thanks for your feedback, LuluBelle! Glad to know that it helped.

61. Thanks, Christina for your feedback. Glad to know that it helped you someway.

62. Idowu,
Best regards

63. Hi Vishnu,
Best regards

64. Hello Johmono,
You’re most welcome.
Best regards

65. FERREIRA, Thanks for your feedback!

67. Thanks, Kelly for your feedback. Glad to hear that it helped you.
Best regards

68. You’re most welcome. Glad to know that it helped you. Thanks for the feedback.

69. Thanks for your input ðŸ™‚

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

Best regards

Thanks.

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

Best regards

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

78. It is actually important ðŸ™‚ Thanks for your feedback.

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

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

81. You’re welcome, Florano!

82. Most welcome, Nilesh ðŸ™‚

83. Nice, Roger. I am glad to know that the formula helped you ðŸ™‚

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

85. Thanks Chamila for your feedback!

86. Thanks for your feedback, Mdu!

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

89. Maybe a little bit tough for the complete layman. I shall change my Phrase then ðŸ™‚

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

91. It is sent. Thank you.

92. Thanks for the suggestion ðŸ™‚ I will keep it on my list.

93. Thanks for your Prayer, Shakeel!
Best regards
Kawser

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

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

Best regards
Kawser Ahmed

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

99. Thanks for your valuable input.
Best regards
Kawser Ahmed

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

101. Thank you so much for your input, Wayne! Hope this input helps my readers ðŸ™‚
Best regards
Kawser Ahmed

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

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

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

105. Thanks, Sarabjeet Singh, for your feedback!

106. You’re welcome, Andrew ðŸ™‚

107. Thanks for your feedback ðŸ™‚

108. Thanks, Ferreira!

109. Thanks for your feedback ðŸ™‚

110. Thanks, FERREIRA for your feedback!

111. Thanks, Surya!

Thanks.

But you can contact our partner here: https://www.exceldemy.com/consulting-services/
Thanks.

114. You’re most welcome ðŸ™‚ I am glad to know that our tutorials add some value to your life.

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

116. Thanks for your feedback ðŸ™‚

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

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

119. Thanks, Ghosh for your feedback.

120. Thanks for your input, Greg.
Best regards

Thanks for the feedback.

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

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

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

Thanks.

Best regards
Kawser

127. Thanks for your feedback ðŸ™‚

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

129. You’re welcome.
Best regards

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

131. Thanks, Mittal!

132. Thank you so much for your feedback.
Best regards

134. Thank you for your valuable feedback. It’s something ðŸ™‚
Best regards

135. Yes, Robert!
Thanks for the feedback.

136. Thanks for your valuable feedback.

137. You’re most welcome, Sola.

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

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

140. Thanks, Mark.

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

142. Thank you for your feedback, Anirudh!
Best regards

143. You’re welcome.

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

145. Hi David,
Thanks.

146. Hi Mike,
Thanks.

147. It is sent. Check out your email.

148. Thanks, Emil!

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

150. You are welcome.

151. Hi Daniel,
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

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

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

154. Thanks for your feedback, George!

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

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

You’re welcome ðŸ™‚

Best regards

159. I will update you.
Best regards
Kawser

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

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

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

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

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

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

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

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

168. Thanks. Glad to know that you found it useful.

169. Thanks, Farhana for the feedback.

170. Thanks for your feedback, Ven!

171. Thanks, Menon for your valuable feedback.

172. Mike,
Kind regards

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

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

176. 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 ðŸ™‚

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

179. Check out trying. I never tried. If you face any problem, let us know ðŸ™‚

180. Thanks, Subbu!

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

182. Thanks for your feedback ðŸ™‚

183. Thanks, Piotr! Glad to know it helps.

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

185. Thanks for the feedback, Prabhudeva!

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

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

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

Thanks.

Thanks.

191. Yes. Corrected.
Thanks, Luke for the tips.

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

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

Glad to know it helped you!

196. Please check the email ðŸ™‚

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

198. It’s sent, check your email.

199. Thanks, Mohan!

200. Raja, any working file on that?

201. Thank you, Jaypogi!

202. Many thanks, Scott!

203. Thanks, Sam! I will reach it to Zhiping ðŸ™‚

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

206. The working files are uploaded. Thanks!

207. Jack, I have notified it to the writer. She will answer soon ðŸ™‚

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

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

210. Thanks Fina for sharing.
Regards

Regards

213. Cherie,
Regards

214. Borb,
Regards
Kawser

215. Kateryna,
You will get empty cells if no data is available for the filtering. What criteria did you use to filter data in intervals?

216. Waleed,
Can you upload the working files of your problems? At least a sample file? If possible send an email to this address [email protected]

217. You can do that Ahmed. Thank you.
Regards

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

219. 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 ðŸ™‚

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

221. First Rate Work, Kadeo! Take my bow ðŸ˜€

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

223. Thanks for the input, specially for the VBA part!

224. Cool ðŸ˜€

Thanks and regards

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

231. Hello Rush,
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

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

233. Hi Roger,
Thanks and regards.

234. Thanks Jan for your feedback.

235. Thanks Orlando for updating me ðŸ™‚
Regards
Kawser

236. Vikas,
Regards

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

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

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

240. It’s my pleasure Bob. Thanks for sharing.

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

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

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

244. Glad to hear that my website is helping you in a way.
It’s my pleasure Mohammed Hussain. Keep in touch ðŸ™‚