From the course: Excel: Tracking Data Easily and Efficiently
Join today to access over 24,900 courses taught by industry experts.
Challenge: Building a tracker 1 - Microsoft Excel Tutorial
From the course: Excel: Tracking Data Easily and Efficiently
Challenge: Building a tracker 1
(upbeat music) - [Instructor] Here's your challenge. In cell B3, create a dynamic dropdown list with the following details. It includes all cities except those in Goodard County, it retrieves the city motto/nickname in cell D5, and displays the result in a shape. Let me show you the data. Over here, we have cities. Anvil Bluff, New Orange, Peanut Butter, and all the way over in column G, the city's mottoes and nicknames. That's what we want to retrieve, but like Cobalt, Dragon Banks, Drexel, they should not show up in our dropdown list, but we do want Ghost River because that's in Bowtie County. We want New Orange because that's in Cork, et cetera, et cetera. All right. Now, it's your turn. Create this dropdown list.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.