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

## How to Use Slicers to Filter a Table in Excel 2013

In this post today, we will be discussing the Slicer Feature in Excel. It is also possible to filter a table using Slicer feature. This feature is visually ...

## Text to Columns in Excel (Split Column, Text, Date, …)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in Excel. Like ...

## Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?

Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has the serial ...

## How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders in the ...

## Viewing and Scrolling Multiple Excel Workbooks at the Same Time

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and scroll multiple Excel workbooks at the ...

## How to Make Negative Numbers Red in Excel (3 Ways)

Sometimes, it is important to mark cells that have some specific values. Most often, users need to differently mark negative and positive values. In this ...

## Excel Dynamic Named Range [4 Ways]

Excel Dynamic Named Range is one of the Excel features that not so many Excel users know about. This article will make Dynamic Named Ranges closer to you. In ...

## What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you ...

## Exponential Notation in Excel & How to Turn Off Auto Scientific Notation!

This article will at first introduce you to theΒ scientific number system and number precision definition. Then you will know about the highest and lowest ...

## How to pull/extract data from a website into Excel automatically?

In this article, I shall show you how to pull or extract data from a website into Excel automatically. This is one of the most used Excel features for those ...

## How to create a database in Excel (make in 8 easy steps)

Don't know how to create a simple database in Excel? In this article, I will show how you can make a database in Excel in just simple 8 steps. Do you find ...

## Excel Array Formula Basic 2 – Breakdown of Array Formula

If youβre a regular follower of my blog, you know that I have started writing a series of articles on Excel Array Formula. In the first article, I have ...

## Excel Array Formula Basic – What is an Array in Excel?

Today, I will talk about the basics of Excel Array Formulas. Most Excel users find it one of the hardest topics to understand in Excel. There are several ...

## Excel Charts with Dynamic Title and Legend Labels

Dynamism is everywhere! Then why not with Excel? Creating dynamic charts in Excel is possible in many ways. What I am going to cover in this article ...

## Reverse Pivot Tables – Unpivot Summary Data

Excel pivot tables are beautiful! Then why do you need to reverse your pivot tables or pivoted data? Because data generated by business are not well ...

##### Browsing All Comments By: Kawser
Kawser Jul 20, 2015 at 9:22 PM

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

Kawser Jul 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.

Kawser Aug 26, 2015 at 5:18 AM

Mohammed Hussain,

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

Jan 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

Sep 24, 2020 at 11:33 PM

A great pleasure for me. Thank you.

Sep 17, 2020 at 10:56 AM

Sep 16, 2020 at 11:14 PM

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

Sep 10, 2020 at 7:38 PM

Idowu,
Best regards

Aug 25, 2020 at 10:58 PM

Hi Vishnu,
Best regards

Aug 18, 2020 at 10:32 AM

Hello Johmono,
You’re most welcome.
Best regards

Aug 17, 2020 at 11:40 PM

Apr 21, 2020 at 9:47 PM

Apr 21, 2020 at 9:44 PM

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

Apr 2, 2020 at 10:26 PM

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

Feb 12, 2020 at 8:29 PM

Jan 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

Jan 15, 2020 at 4:41 PM

Best regards

Dec 29, 2019 at 10:17 AM

Thanks.

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

Dec 9, 2019 at 1:56 PM

Dec 4, 2019 at 10:11 AM

Best regards

Nov 26, 2019 at 9:16 AM

Nov 21, 2019 at 9:37 AM

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

Nov 18, 2019 at 7:50 PM

It is actually important π Thanks for your feedback.

Oct 31, 2019 at 9:09 AM

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

Oct 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

Oct 16, 2019 at 8:33 PM

You’re welcome, Florano!

Oct 10, 2019 at 12:59 PM

Most welcome, Nilesh π

Oct 10, 2019 at 12:58 PM

Nice, Roger. I am glad to know that the formula helped you π

Oct 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?

Oct 1, 2019 at 10:30 AM

Sep 26, 2019 at 7:06 PM

Jul 25, 2019 at 6:33 PM

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

Jul 23, 2019 at 6:50 PM

Jul 18, 2019 at 6:20 PM

Maybe a little bit tough for the complete layman. I shall change my Phrase then π

Jul 15, 2019 at 8:02 PM

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

Jul 10, 2019 at 8:25 PM

It is sent. Thank you.

Jun 20, 2019 at 7:19 PM

Thanks for the suggestion π I will keep it on my list.

Jun 13, 2019 at 6:16 PM

Best regards
Kawser

Jun 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

Jun 8, 2019 at 2:22 PM

Jun 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

Jun 8, 2019 at 2:20 PM

Best regards
Kawser Ahmed

Jun 3, 2019 at 6:10 PM

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

Jun 3, 2019 at 6:09 PM

Best regards
Kawser Ahmed

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

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

May 21, 2019 at 9:54 PM

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

Apr 22, 2019 at 9:43 PM

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

Apr 22, 2019 at 9:43 PM

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

Apr 15, 2019 at 1:32 PM

Thanks, Sarabjeet Singh, for your feedback!

Apr 11, 2019 at 9:42 PM

You’re welcome, Andrew π

Mar 26, 2019 at 9:53 PM

Mar 7, 2019 at 7:58 PM

Thanks, Ferreira!

Mar 7, 2019 at 7:58 PM

Feb 27, 2019 at 6:34 PM

Feb 27, 2019 at 6:33 PM

Thanks, Surya!

Feb 27, 2019 at 6:29 PM

Thanks.

Feb 23, 2019 at 1:52 PM

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

Feb 14, 2019 at 4:26 PM

You’re most welcome π I am glad to know that our tutorials add some value to your life.

Feb 9, 2019 at 12:36 PM

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

Jan 31, 2019 at 9:25 PM

Jan 30, 2019 at 1:26 PM

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

Jan 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

Jan 19, 2019 at 8:00 PM

Jan 10, 2019 at 3:50 PM

Best regards

Jan 9, 2019 at 1:06 PM

Thanks for the feedback.

Jan 6, 2019 at 6:45 PM

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

Jan 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

Dec 29, 2018 at 3:59 PM

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

Dec 25, 2018 at 3:40 PM

Thanks.

Dec 15, 2018 at 1:59 PM

Best regards
Kawser

Dec 6, 2018 at 5:22 PM

Dec 3, 2018 at 1:13 PM

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

Nov 21, 2018 at 12:05 PM

You’re welcome.
Best regards

Nov 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

Oct 29, 2018 at 1:06 PM

Thanks, Mittal!

Oct 25, 2018 at 9:47 PM

Thank you so much for your feedback.
Best regards

Oct 9, 2018 at 6:12 PM

Oct 7, 2018 at 3:21 PM

Thank you for your valuable feedback. It’s something π
Best regards

Sep 6, 2018 at 12:23 PM

Yes, Robert!
Thanks for the feedback.

Sep 6, 2018 at 12:23 PM

Sep 5, 2018 at 1:28 PM

You’re most welcome, Sola.

Sep 4, 2018 at 6:26 PM

Sep 1, 2018 at 2:20 PM

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

Sep 1, 2018 at 2:17 PM

Thanks, Mark.

Sep 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

Aug 28, 2018 at 12:28 PM

Thank you for your feedback, Anirudh!
Best regards

Aug 8, 2018 at 10:46 AM

You’re welcome.

Aug 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

Aug 7, 2018 at 5:28 PM

Hi David,
Thanks.

Aug 7, 2018 at 5:24 PM

Hi Mike,
Thanks.

Jul 18, 2018 at 8:17 PM

It is sent. Check out your email.

Jul 17, 2018 at 2:38 PM

Thanks, Emil!

Jul 4, 2018 at 12:17 PM

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

Jun 25, 2018 at 4:16 PM

You are welcome.

Jun 25, 2018 at 11:55 AM

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

Jun 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

Jun 21, 2018 at 12:28 PM

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

Jun 21, 2018 at 12:28 PM

Jun 13, 2018 at 12:36 PM

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

Jun 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

May 31, 2018 at 10:57 AM

You’re welcome π

May 30, 2018 at 8:30 PM

Best regards

May 29, 2018 at 7:50 PM

I will update you.
Best regards
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

May 29, 2018 at 11:27 AM

Glad to hear that it was useful for you.
Regards

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.

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

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

May 8, 2018 at 1:29 PM

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

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

Apr 24, 2018 at 2:14 PM

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

Feb 22, 2018 at 11:53 AM

Thanks. Glad to know that you found it useful.

Feb 20, 2018 at 5:25 PM

Thanks, Farhana for the feedback.

Jan 28, 2018 at 11:09 AM

Dec 19, 2017 at 7:56 PM

Thanks, Menon for your valuable feedback.

Oct 25, 2017 at 3:37 PM

Mike,
Kind regards

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

Sep 11, 2017 at 12:11 PM

Aug 3, 2017 at 8:18 PM

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

Jul 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 π

Jul 6, 2017 at 6:31 PM

Jun 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

Jun 5, 2017 at 10:13 AM

Check out trying. I never tried. If you face any problem, let us know π

Jun 4, 2017 at 1:44 PM

Thanks, Subbu!

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

Kawser Mar 3, 2017 at 6:55 PM

Kawser Feb 27, 2017 at 12:46 PM

Thanks, Piotr! Glad to know it helps.

Kawser Jan 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.

Kawser Jan 15, 2017 at 1:23 PM

Thanks for the feedback, Prabhudeva!

Kawser Dec 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.

Kawser Dec 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.

Kawser Dec 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.

Kawser Nov 23, 2016 at 10:22 AM

Thanks.

Kawser Nov 12, 2016 at 3:26 PM

Thanks.

Kawser Nov 7, 2016 at 11:10 AM

Yes. Corrected.
Thanks, Luke for the tips.

Kawser Nov 6, 2016 at 11:13 AM

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

Kawser Oct 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

Kawser Oct 29, 2016 at 10:45 AM

Kawser Oct 29, 2016 at 10:45 AM

Glad to know it helped you!

Kawser Oct 28, 2016 at 9:39 PM

Kawser Oct 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

Kawser Oct 13, 2016 at 12:56 PM

Kawser Oct 13, 2016 at 12:55 PM

Thanks, Mohan!

Kawser Oct 9, 2016 at 11:26 AM

Raja, any working file on that?

Kawser Oct 4, 2016 at 7:48 PM

Thank you, Jaypogi!

Kawser Sep 29, 2016 at 8:20 PM

Many thanks, Scott!

Kawser Sep 20, 2016 at 1:28 AM

Thanks, Sam! I will reach it to Zhiping π

Kawser Sep 15, 2016 at 11:21 AM

Kawser Sep 10, 2016 at 3:41 PM

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

Kawser Sep 10, 2016 at 3:41 PM

The working files are uploaded. Thanks!

Kawser Sep 6, 2016 at 2:03 AM

Jack, I have notified it to the writer. She will answer soon π

Kawser Aug 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.

Kawser Aug 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

Kawser Aug 21, 2016 at 3:23 PM

Thanks Fina for sharing.
Regards

Kawser Aug 16, 2016 at 3:10 AM

Regards

Kawser Aug 16, 2016 at 3:10 AM

Kawser Aug 6, 2016 at 1:28 AM

Cherie,
Regards

Kawser Aug 1, 2016 at 10:50 AM

Borb,
Regards
Kawser

Kawser Aug 1, 2016 at 10:39 AM

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

Kawser Aug 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

Kawser Aug 1, 2016 at 10:33 AM

You can do that Ahmed. Thank you.
Regards

Kawser Aug 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

Kawser Jul 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 π

Kawser Jul 16, 2016 at 1:10 PM

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

Kawser Jul 16, 2016 at 12:41 PM

First Rate Work, Kadeo! Take my bow π

Kawser Jul 16, 2016 at 12:40 PM

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

Kawser Jul 16, 2016 at 12:39 PM

Thanks for the input, specially for the VBA part!

Kawser Jul 16, 2016 at 12:38 PM

Cool π

Kawser Jul 16, 2016 at 12:37 PM

Kawser Jul 5, 2016 at 11:04 AM

Kawser Jun 11, 2016 at 12:26 PM

Kawser Jun 11, 2016 at 12:23 PM

Kawser Apr 5, 2016 at 5:15 PM

Thanks and regards

Kawser Mar 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

Kawser Feb 24, 2016 at 1:10 AM

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

Kawser Feb 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

Kawser Feb 15, 2016 at 12:07 PM

Hi Roger,
Thanks and regards.

Kawser Feb 1, 2016 at 6:37 PM

Kawser Jan 26, 2016 at 12:39 AM

Thanks Orlando for updating me π
Regards
Kawser

Kawser Jan 12, 2016 at 1:15 AM

Vikas,
Regards

Kawser Dec 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.

Kawser Dec 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 π

Kawser Dec 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.

187. Kawser Nov 29, 2015 at 11:59 AM

It’s my pleasure Bob. Thanks for sharing.

Kawser Sep 4, 2015 at 3:23 PM

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

Kawser Aug 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

Kawser Aug 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.

Kawser Aug 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 π

Kawser Feb 27, 2015 at 8:01 PM