课程: Excel: Tracking Data Easily and Efficiently

Introducing tables - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Introducing tables

“

- [Instructor] Tables. Tables, tables, tables. So few people use 'em, but they are so vital, especially when you're building a data tracker. A table can keep things tied together. Flexible, integrated. You're going to see tables a lot in this course, but I just want to take a moment to give you a proper introduction. Now we've got these two data sets, which are the same. I just want to do a comparison for you. Right now, all of this data is considered to be a range but now I'm going to put this data set into a table. I'm in the Home tab of the ribbon. I want to go Format as Table. Look at all beautiful options we have for colors. Let's grab this red. Table does have headers. Okay. We automatically get filter buttons. I don't like filter buttons. I feel like they're visual clutter, but if you like 'em and you use them, use them. I'm not going to come to your house and say, "Hey, what are you doing?" Okay. One thing we can do with tables in this tab is name a table. I'm going to name this RSVP. Great. Now, let's do some comparisons against here we have an array, and here we have a table. Okay. In this cell, we have a count of the people who have been invited, and we can see that. And then we have a sum of the guest count. Good. Let's do this for the table. Equals count a, open parentheses. Now I'm going to highlight that column. And look, with that black arrow pointing downward, we only get the data in that column inside the table. It doesn't go further down. Also, notice how the formula looks. We've got count A and then RSVP, which is the name of the table. And in those square brackets we have the word invited. That's the table column. Now I'm going to close parentheses and Enter. Now we have the 10. Guest count equals some, open parentheses, some right, RSVP is a table name, guess is the column name. And close parentheses, Enter. Great. Both sets of data. 10 invited, 15 guests. Now, this data set has a formula that's calculating large groups. If a group is over two people, then it puts an L in the column. Now watch this. Large group. And I'm just going to put GRP. Equal Enter. Ah, look at that. The table expanded. Now write the formula. Equals if, open parentheses the guests is greater than two. Then double quote, capital L, double quote. Otherwise, double quote, double quote to stay empty and close parentheses, enter. Did you see the table took that formula all the way down the column? We did not have to drag it down. Okay, now let's scroll down. I'm going to drag some data into our existing data sets. Now, drag this down. Alright. Wow. The table absorbed the new data. The formula extended further on down the column. Over here, no, it didn't happen. Look, we still have the 10 and 15, whereas over here we have the 20 and 34. With a range of data, you have to remember, go and drag this down. But what if you had forgotten? What if the phone rings? And if somebody telling you, "All right, yeah, your horse looks healthy, you can come on and come back and get it." Now you're ready to go and pick up your horse from the veterinarian and not thinking about this formula need to be dragged down, but the table has your back. So those are just a few highlights about tables and why they can be so important. Please use tables.

内容