课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Solution: Building a tracker 1

Solution: Building a tracker 1 - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Solution: Building a tracker 1

“

(upbeat music) - [Instructor] All right, let's build this dropdown list. It has to be dynamic. It has to include all cities except those in Goddard County, retrieves the city's motto or nickname, and displays the results in a shape. Let's do it. I'm going to start by putting the source data into a table. Cursor is in the dataset, format as table. I am going to grab this orange color, table has headers, okay, scroll down right, no extra data, no empty columns or rows. Everything is great. Get rid of the filter button, that part is not great. Alright, so here, I'm just going to make this Cities, it's just a good habit to name tables. Next, I need to get the list of cities, the right cities. So I'm going to slide over here and call this Cities. And then equals filter, open parentheses. Filter what? Filter the cities, comma. Include what? Include where the county does not equal Goodard, close the double quotes,…

内容