15.2 Excel Decimal Data Validation
28/01/2021

Create the little dropdown give the users the exact values for them to pick from. Another type that I want to show up...

15.1 Creating an Excel Data Validation List
24/01/2021

I’m still on the Sort & Filter worksheet within the Excel102exercise file. Now I want to create a dropdown list, when users are...

14.6 Excel Function: SUBTOTAL()
17/01/2021

What the subtotal function can do for you, this is excels subtotal function. The subtotal function I’m going to F1, I started to...

14.5 Excel Function: DCOUNT()
17/01/2021

Now I want to get the counts, I want to know how many sales we’re done with the category of SUPPLIES. At J9...

14.4 Excel Function: DAVERAGE()
17/01/2021

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

14.3 Excel DSUM Function with AND Criteria
10/01/2021

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

14.2 Excel DSUM Function with OR Criteria
10/01/2021

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

14.1 Excel DSUM Function Single Criteria
03/01/2021

By utilizing the DSUM function we can add criteria to the sum we’re going to say hey excel. I want to sum up...

13.9 Removing Duplicates in Excel
02/01/2021

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

13.8 Using Conditional Formatting to Find Duplicates
02/01/2021

Something speech that I want to show of here deals with duplicate records. Now once again I’ve got the example file open and...

View more...