From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Pricing grid and drop-down list

Pricing grid and drop-down list - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Pricing grid and drop-down list

- [Instructor] We're going to create a pricing grid that is manipulated by a discount dropdown list. I need your help to make a dropdown list in B-three that includes the discounts that you see over in column K. And then, fill in C-six through G-11, multiplying, for example in C-six, multiply the 11 times the eight times the discount. Hopefully you'll write just one formula, drag it over, drag it down, and you'll be all set. Then wrap it up by adding borders to the grid. All right? Pause the video, make the grid, come back and I'll walk you through a solution. Okay, you're back. I am going to start by making the borders. I'm going to highlight here, I'm in my home tab, and I prefer light borders so I'm going to go to more borders 'cause the black lines are too dark. That's just my preference. And then let's just have a little fun, let's make 'em this pink color. I like those, okay. There is our grid. Let's make our dropdown list. I'm going to put this into a table, format as table…

Contents