You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Now, let’s create a dropdown on another sheet named Dropdown and reference Animals_List : Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet).

Once your categories are defined, create a table in Excel or Google Sheets to organize your data. Formatting the data as a table ensures that it dynamically updates when new entries are added.