Microsoft Excel: Data Management Features (IME483T)

1.0 CPE

Manage Large Lists and Databases Effectively – Master Data Management in Microsoft Excel

According to Microsoft, up to 70% of users surveyed use Excel to maintain a database or large lists. Microsoft Excel is a powerful application for tackling your data management needs with ease – all the more important today, 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 can do more with Microsoft Excel worksheets than just calculate data. However, to be truly proficient in Excel, you must be familiar with the tools available for managing data efficiently. 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.

In this session, Excel specialist Dennis Taylor will help you master the tools of database 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. With the know-how you get from this session, you will be able to 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.

Session Highlights

• Learn the fastest, most efficient ways to sort data; sort by content, by color, or based on the order of data in a custom list; sort in random order or by re-arranging columns left-to-right.
• Re-structure improperly grouped columnar data with Flash Fill or the Text to Columns feature.
• Master the myriad ways of filtering data to display just the data you need.
• Eliminate duplicate records from a large database.
• Insert a row of subtotals in a sorted list without tediously creating new rows and formulas.
• Create drop-down lists to accelerate data entry, with improved accuracy and consistency.
• Convert lists into tables – the result, easier data-handling and enhanced visual features.
• Learn valuable functions that help you understand your data – COUNTIF, SUMIF, and more.

Who Should Attend

• Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this session.