Okay, in this worksheet here, you'll see that we have a blank row separating a header, which is fine. But at the bottom, what we have here is we've got a total row and some information here. So that's not part of the table. So what you're going to want to do in this scenario here is either delete, or insert blank rows, so that they're going to be after it. So there's going to be some kind of a definitive boundary here. So now with that in mind, let me create a quick table Ctrl T. Click OK. And now we're off the bat there.

Okay. So I can recognize that I've got a duplicate column here. So one way to get rid of a column that you don't need to so right click, and there's an opportunity to remove that delete table column. That's different than an entire column because it didn't interfere with anything above or below that that data set stay the same here. Okay. The other thing I want to talk about real quick here is sometimes in the table, you might see that your dates are not filtered, not brought over as actual dates, I see a Z, and that's going to be a problem.

If I later want to do a pivot table and group this by months, it's not recognized as a date. So I can create a quick column here, I'll just call it date format, proper one. And all the trick you can do is multiply the date by one times one. And then those are all correct. They look weird, but those are the date formats for that. I can just change it over to the short date format here.

Now, I know that this is correct, because I've got oldest to newest, newest, oldest. So that is, that is great. And I also can see this breakdown here in the event that I wanted to see, for example, April. I could do that. Over here though. I wouldn't be able to do that so easily, right because it wasn't properly formatted.

So when I want to select, I can click on the little black arrow above, Copy that, control C. And I'm going to come over here and right click the values over top of it. Just quick format here. And when when I have that in place, then I know that I can remove this twice there, delete table columns. Pretty cool here. Awesome. Okay, so the other thing that I want to share with you is sometimes you might start to see that you've got duplicates.

That's hard to see that I'm going to select this column here, go to the conditional formatting and then select highlight cell rules, duplicate values. And that will be really handy to see any duplicates there. So if that's the scenario that you're facing, think we have duplicates, show that and then discover what the problem is and fix it accordingly. If I were to change this, so once we determined that this should have been 890, let's say 896. The formatting does disappear on that. Okay, let's say I want to see how much Kirk Bowman had.

So, okay, so we have Kirk. And then I want to add all these up, and so go to Table Tools design tab, total row. They can calculate right there from that scenario. They're awesome.