Excel`s Data Management Tools 2016 is a webinar that covers topics such as:
- Re-structure improperly grouped columnar data with Flash Fill or the Text to Columns feature
- 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
- Eliminate duplicate records from a large database
- Master the myriad ways of filtering data to display just the data you need
- Create drop-down lists to accelerate data entry, with improved accuracy and consistency
- Insert a row of subtotals in a sorted list without tediously creating new rows and formulas
- Learn valuable functions that help you understand your data - COUNTIF, SUMIF
- Convert lists into tables - gain easier data-handling and enhanced visual features
Excel`s Data Management Tools 2016 is intended for any Excel user who deals with large lists.