16.2 Excel 2019

Excel 2019...

Blog Title

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but...

16.1 Importing Data from Text Files into Excel

You may have data from other sources such as text files, CSV files databases. Whether that’s an Access database or some other database in the back end maybe it’s a web page that you want to build a pull data from. But you’ve got external data that you now want...

15.4 Dynamic Formulas by Using Excel Data Validation Techniques

I’m going to show you, how you can combine data validation lists a little drop down menu with functions inside of Excel making the function more interactive and more dynamic. I’m going to go back to the list functions worksheets, that we were on earlier, where we created the subtotal...

15.3 Adding a Custom Excel Data Validation Error

We’ve seen a few different types of data validation instead of Excel. Little picklists dropdown lists that the users can choose from. We did that on the make column and we did a decimal range value. Now we saw that if you put something in there that doesn’t fall within...

15.2 Excel Decimal 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 here is arrange a numeric range. I want to specify that within a column in this case within the Rate column. You can only put values 14.95...

15.1 Creating an Excel Data Validation List

I’m still on the Sort & Filter worksheet within the Excel102exercise file. Now I want to create a dropdown list, when users are entering the make value within these records. I want to give them a specific list of makes that they can choose: Ford, Chevy, Pontiac, Oldsmobile.. That way...

14.6 Excel Function: SUBTOTAL()

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

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

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