Home / 2021 / January

Monthly Archives: January 2021

14.6 Excel Function: SUBTOTAL()

Excel Function SUBTOTAL 6

What the subtotal function can do for you, this is excels subtotal function. The subtotal function I’m going to F1, I started to type There’s subtotal function, it’s asking me for two things. I’ll go hit the fx button, here’s argument window. It’s got two arguments, It wants to know …

Read More »

14.5 Excel Function: DCOUNT()

Excel Function DCOUNT

Now I want to get the counts, I want to know how many sales we’re done with the category of SUPPLIES. At J9 cell, I’m get a count of the sales column where the category is equal to supplies. I’m going to use the DCOUNT function because I’m going to …

Read More »

14.4 Excel Function: DAVERAGE()

Excel Function DAVERAGE

I’ve got my average sales at cell K2 and I’m just going to use my same criteria section. We can do And, Or statements exactly the same way that we did it with the DSUM. Let’s start out with the simple one and then I’ll give you an opportunity to …

Read More »

14.3 Excel DSUM Function with AND Criteria

Excel DSUM Function with AND Criteria 1

We’ve seen a single criteria where we’re getting where category is equal to rent, and we’ve included the software category. We’re giving total sales where category is equal to rents or software,  that was in your statement. Let’s take a look at utilizing an and statement inside of our criteria. …

Read More »

14.1 Excel DSUM Function Single Criteria

Excel DSUM Function Single Criteria 3

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

Removing Duplicates in Excel 3

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.7 Format a List as a Table

Format a List as a Table 4

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

Creating Subtotals in a List 2

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 »