Wine Dashboard Lesson - Free Excel Practice Online

This free, interactive exercise teaches you Wine Dashboard Lesson in Excel through 8 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Wine Dashboard Project track and works right in your browser - no Excel install, no download, and no signup.

Practising Wine Dashboard Lesson this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Wine Dashboard Lesson lesson

1. Get started on the wine dashboard by downloading the Wine data file. Look at all this data! We want to turn it into a nice dashboard using VLOOKUPs to look up data of a specific country for a specific year, but the country column and year column are separate. How can we do a VLOOKUP with lookup values in two separate columns? Leave the answer field blank and press Check Answer to find out.
2. Add a column to the left of the "Country" column and name it "Lookup Key." In this column, use CONCAT to join the country name and the year, so that the first row is Afghanistan1980. Grab the corner of cell A2 and drag the formula all the way down to the bottom of the column. When you're done, press Check Answer to continue.
3. Copy the entire list of country names, then page over to the Dashboard worksheet and paste the list into cell B30. With the entire list still selected, use Remove Duplicates in the data tab.
4. Select the three cells which contain years in row 18, then click the handle in the lower-right corner of the cells and drag them over to the right until cell AK18. The last cell should contain the year 2014.
5. pic 5
6. pic 6
7. pic 7
8. pic 8

Wine Dashboard Lesson practice - FAQ