From the course: Excel: Data Validation in Depth

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Creating data sets from your validated data

Creating data sets from your validated data - Microsoft Excel Tutorial

From the course: Excel: Data Validation in Depth

Start my 1-month free trial Buy for my team

Creating data sets from your validated data

“

- [Instructor] Explore California set out to do something amazing, encourage state employees to start exploring California and at a discount. What they didn't realize is how popular this new program was going to be. The forms are not even out yet, and people are calling and emailing the office, ready to get started with their discounts. We talked about when you build solutions like this in Excel, they're flexible, right? Well, that's only sort of true, because when things start to scale, it gets much more difficult to manually keep track of all the data. Think about it. If a handful of people filled out this form, the process would be easy enough to manage, but if it's 7,500 people, that's an entirely different story altogether. The good news is the raw data you receive should be pretty good, because you now know you can build all types of validation to get the best data possible and make the user experience…

Contents