Excel's Data Management Tools in Fremont
Overview: Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. Its all the more important as data collection has become more automated and youre getting swamped with tons of data. But what can you do with all that data? You need to know how to re-arrange the data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (the exciting new Flash Fill tool and the Text to Columns feature) and eliminate redundant records. If you are setting up new lists, you need to know the powerful validation tools that keep out bad data from the start and how to drastically reduce data entry with drop-down clickable lists.