Excel 2019...
Lorem Ipsum is simply dummy text of the printing and...
You may have data from other sources such as...
I’m going to show you, how you can combine...
We’ve seen a few different types of data validation...
Create the little dropdown give the users the exact values for them to pick from. Another type that I want to show up...
I’m still on the Sort & Filter worksheet within the Excel102exercise file. Now I want to create a dropdown list, when users are...
What the subtotal function can do for you, this is excels subtotal function. The subtotal function I’m going to F1, I started to...
Now I want to get the counts, I want to know how many sales we’re done with the category of SUPPLIES. At J9...
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...
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...
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...
By utilizing the DSUM function we can add criteria to the sum we’re going to say hey excel. I want to sum up...
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...
Something speech that I want to show of here deals with duplicate records. Now once again I’ve got the example file open and...