14.2 Excel DSUM Function with OR Criteria

We’ve got a single bit of criteria we’re summing up the total sales column where the category column is equal to “Rent”. What if you wanted to do I want to get a sum of the category for rent and or I want to get it for overhead so give...

14.1 Excel DSUM Function Single Criteria

By utilizing the DSUM function we can add criteria to the sum we’re going to say hey excel. I want to sum up the total sales but I only want to do it where the category is equal to rents, or where the categories equal to telemarketing or whatever it...

13.9 Removing Duplicates in Excel

We’ve identified the duplicates by using conditional formatting. But in many cases once you’ve identified them you then want to perform some action with those duplicates. And in this case I’m going to remove the duplicates. Remember it’s two separate steps. First you identify them using conditional formatting and in...

13.8 Using Conditional Formatting to Find Duplicates

Something speech that I want to show of here deals with duplicate records. Now once again I’ve got the example file open and I’m looking at the Employee records worksheet. In the employee records worksheet we got a list of employee information. And I just now added a couple of...

13.7 Format a List as a Table

Something the next feature I want to introduce you to here was was actually introduced into excel in the 2007 edition of Excel. Now I’m working this out of 2013 in front of you but three versions ago and the newest version which is 2016 all whole this feature This...

13.6 Creating Subtotals in a List

The next topic that I want to get into year within a proper designed well formatted list is subtotals, I’ve still got the exercise file open and I’ve gone to the Subtotals worksheet. I’ve got a simple list, it’s got a few columns. Salesperson, product units, price/unit and sales and...

13.5 Filter an Excel List Using the AutoFilter Tool

Sorting a list makes it more accessible makes it easier to find data. But you still have to search through all the data to find the specific records that you’re looking for example I’m looking at Buyers 2015 and I just sorted it by month but you know what I...

13.4 Using Custom Sorts in an Excel List

Here’s one more topic about sorting within Excel lists. Now I’ve still got the exercise file . I’m on the Buyers 2015 worksheet. I mean to give a quick little tip here in order to find really make it more accessible for the little arrows on the left hand side...

13.3 Sorting a List Using Multi-Level Sorts

The second technique that I want to talk about here in sorting the list deals with a multilevel sort, I want to sort this list by multiple columns. Now this one is is very quick as well but a few extra steps. I want to get into this list. Same...

13.2 Sorting a List Using Single Level Sort

Here’s the first tool that I want to get into within working with a list inside of Excel. And this is perhaps one of the most common tools that are used inside of a list. Now think about this what’s the purpose of a list. I’ve got a list of...