1. Wrap-up
Before you go on to building your own amazing spreadsheets, let us step through what you learned.
2. Data validation
Data validation helped mitigate bad data entry.
There were many validation types that we used to aid in clean data entry, including dropdowns, text, checkboxes, and many more.
3. Regular expressions
Regular expressions are a special sequence of characters that aid in string manipulation or aggregation.
In this course, you modified strings with REGEXREPLACE and REGEXEXTRACT, and aggregated categories with REGEXMATCH.
4. Building a dynamic dashboard
After learning how to mitigate bad data entry and modify and aggregate categories, you learned to build a dynamic dashboard.
Remember, a dashboard should be easy to understand and use for both executives and clients, but should also contain actionable insights that strategists can use in the decision making process.
5. Next steps
Now, I suggest you try out different data validation options, since we only touched on a few in this course.
Challenging yourself with difficult regex tasks is a great way to improve your proficiency.
Instead of building one-off charts, try building dashboards to help streamline the decision making process.
6. Congratulations!
Congratulations on completing the course!