Dropdown Lists Made Simple | Excel Tutorial
Learn how to create dropdown lists in Excel to speed up data entry and ensure error-free spreadsheets. In this tutorial, Microsoft Certified Trainer Alison Gonzalez demonstrates how to create a basic dropdown, expand it to include all 50 states using a dynamic table, and maintain consistent product names for clean data in Power BI reports. This tutorial is perfect for anyone looking to improve their Excel workflows. The video is divided into chapters, covering the introduction and benefits, building the first dropdown, scaling to 50 states, creating a product list, and wrapping up with next steps. Connect with Pragmatic Works on various platforms for more resources and information.
Video 2m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time