ABOUT THIS EVENT

Event Category

Business & Technology

Event Overview

You create a spreadsheet or a form in Excel for someone else. Then

- You get a call that someone has typed over a formula and can't fix it.
- Your sales analysis is wrong because Chicago is also in the source data as "Chicgo" and "Chicago, IL"
- A critical deadline is missed because someone accidentally typed in a date that was 10 years ago, and the spreadsheet accepted it.

Let's spend 2 hours learning how we can control data inputs in Excel and prevent these calamities.

We take powerful control of our data quality, analysis and mental peace by creating dropdown lists, creating cells that will only accept a date within 10 days of today, and protecting formulas against accidental corruption.

If you want control over your data quality and spreadsheet integrity, come on and get to know Excel's validation features.





Here is a YouTube video showing an Inventory Control System that relies on lots of data validation. The math is easy. The input controls are what make the app useful.
- http://www.youtube.com/watch?v=Pq7wV8qWtUk

Minimum age

All ages welcome

Prerequisites

Basic familiarity with Excel will be useful. We won't be creating complex formulas. So, if you can write basic formulas, and navigate your way around Excel, you'll be ok.

Location