Managing List-Based Data in Excel
Duration: 90 minsExcel is not all about working with numbers - it is a powerful data analysis tool. More and more people are turning to Excel to organize, manage, and retrieve list-based data.
Whether it's lists of employees, lists of equipment, lists of training courses or anything else, Excel contains a whole array of features designed to help you to manage your list-based data.
- Sort a list of items into alphabetical, numerical or chronological order
- Use List Filters to display only those items matching given criteria
- Save a Filter for re-use
- Convert a list into a Table
- The benefits of a Table-based list
- Create a Pivot Table to summarize list-based data
- Use the VLOOKUP function to "look up" a value from a list
- Use the COUNTIF function to compare two lists
Why you should attendLearn the best ways to organize your data in Excel, and maximize sorting capabilities to avoid getting lost in all your data. Clean your data, get rid of duplicates and blank cells, and format consistently to get more out of your database and prepare more effective reports.
Who should attend
All level Excel users are welcome in this session to learn how to best organize and manage your data lists in Excel.
This training will be delivered using the latest version of Excel, but is relevant for users of Excel 2010 and above.
About the Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.