Dropdown List

Congratulations on reaching the final section! 🎉 Here, we'll build an interactive report that will automatically calculate various metrics for each bakery individually. As we develop, we'll use AI to speed up and simplify our work. In the video, I'm using Copilot because it's designed for Microsoft 365 Office, but using the paid version of ChatGPT also provides accurate answers. We'll also create a similar dashboard using Power BI—all in just one video! 😊

In this chapter, we will add dates from the table so that they update and extend automatically. Additionally, we will create a dropdown list with extended bakery names and IDs, along with the corresponding managers displayed in a separate cell.

Here's a detailed guide if you need step-by-step instructions with a video.

In this chapter, we use the following functions (each name is clickable and links to the respective chapter with explanations of how the function works):

• TRANSPOSE
• SORT
• UNIQUE