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.
It’s all the more important as data collection has become 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 re-arrange the data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (using Flash Fill tool and Text to Columns features) 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.
Why should you Attend: Master the tools of Data Management – Sorting, Automatic Subtotals, and Filtering, as well as other techniques that provide clarity and quick answers so that you can understand your data better and faster.
You can do more with Microsoft Excel worksheets than just calculate data you can tackle powerful data management needs with ease too! With just a bit of know-how, you can take advantage of the power of Excel to validate data, sort data (based on content, color, or icon), insert automatic subtotals, filter the data to see just what you need to see, restructure columnar data that has been improperly grouped, eliminate duplicate records in a flash, and use powerful expanded functions to analyze the data in any list, regardless of size.
Areas Covered in the Session: