← Back to projects
Premium · 7 days to submit
World Wine Dashboard
Build a dashboard with drop-down lists, lookups and charts showing wine consumption by country.
This project is not translated into your language yet: the instructions stay in English.
The wine dashboard project walks you through the process of taking a large data file in Excel and turning it into a usable dashboard, complete with graphs and drop-down menu selections. The dashboard shows the amount of wine consumed by different countries over time.
Premium project
Log in or create an account to start a project and follow your progress.
How you are graded
Each project is graded out of 100; you need 70 points to pass. Some criteria are checked automatically in your workbook, the rest are judged by the AI.
- Lookup Key columnAutomaticA new first column on the data sheet joins country and year with CONCAT or &.10 pts
- List of countriesAutomaticThe dashboard lists each country once, starting at cell B30.5 pts
- Row of yearsAutomaticRow 18 of the dashboard holds the years 1980 to 2014 across columns C to AK.5 pts
- Country and year drop-downsAutomaticCells C3 (countries) and C21 (years) have drop-down lists.10 pts
- VLOOKUP trendAutomaticRow 17 looks up the wine per capita of the chosen country for each year with VLOOKUP and CONCAT.10 pts
- Handling errorsAutomaticThe lookups are wrapped in IFERROR so a missing year shows 0.5 pts
- Absolute referencesAutomaticThe formula locks the right parts of its references with $ signs so it can be dragged across.5 pts
- Top 5 countriesAutomaticLARGE returns the five highest values and VLOOKUP finds their countries.15 pts
- ChartsAutomaticA line chart for the trend and a horizontal bar chart for the top 5, with titles linked to cells.10 pts
- Final touchesAutomaticNarrow column A, grouped helper rows and no gridlines.5 pts
- Look and clarityAIClear labels, a good-looking title and charts a boss could read at a glance.20 pts