Data Management Best Practices in Excel®
|Audio & Reference Manual||$199.00||Add to Cart|
Learn the best ways to use these tools: Validation, Tables, Sort, Filter, Subtotal, Text to Columns, and more ...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. Managing data is becoming more important than ever as data collection is more automated and you're getting swamped with tons of data. But what can you do with all that data? You need to know how to rearrange the data (Sort), see just what you want to see (Filter), create quick summaries (Subtotals), restructure fields containing too much data (Text to Columns) and eliminate redundant records (Remove Duplicates). If you are setting up a new list, you need to become familiar with the best ways to lay out your data, how to take advantage of Excel®'s Table feature, and how to use the powerful validation tools that not only keep out bad data from the start, but also drastically reduces data entry drudgery with drop-down clickable lists.
Dennis Taylor, Taylor Associates