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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »13.1 Understanding Excel List Structure
Here’s the first concept there’s actually two that I want to bring in here and make you aware of as you work with in Excel with the LISTS. Now inside the exercise pile that I have open, I’m looking at the employee records tab and on I have a simple …
Read More »