Skip to main content
Workshop

Excel Lists & Tables 101: Solutions for Unlocking Data-Driven Success

On-demand recording

90 minutes

Summary

In this 90-minute, instructor-led training, you will learn the vast array of functionalities that Excel provides for handling lists, including techniques for importing, sorting, filtering, and converting data.  We’ll provide step-by-step guidance for transforming unorganized data into well-structured tables, enhancing your data analysis and reporting capabilities.  You’ll practice with the expert while you learn, and your questions will be answered all throughout the session!

Gain must-have skills for managing data, and join us for this hands-on training to discover how to do the following like a pro:

  • Seamlessly import data into Excel from external sources while maintaining data integrity
  • Use Excel features such as Flash Fill & advanced filtering for enhanced productivity
  • Convert raw data into structured tables for better data management & reporting
  • Sort & manage lists based on multiple criteria for improved data analysis
  • & MUCH more!

Program Highlights

Foundations of List-Based Data in Excel: From Theory to Practice

  • How to comprehend the basics of list-based data in Excel
  • Learn real-world applications & the importance of list-based data

Efficient Data Handling: Importing, Flash Fill & Tables

  • Methods for importing data from diverse sources into Excel
  • Solutions for maintaining data integrity during the import process
  • Ways to maximize the utility of Flash Fill for efficient list creation
  • Learn to convert a standard list into a table for enhanced analysis
  • Discover the advantages of employing tables instead of regular lists

Data Integrity Techniques: Sorting, Filtering & Duplicates

  • How to use advanced sorting techniques based on various criteria
  • Methods for implementing both basic & sophisticated filtering options
  • Strategies for identifying & eliminating duplicate data
  • Solutions for ensuring ongoing data consistency

Program Benefits

This hands-on webinar will empower you to go beyond basic number-crunching, dramatically improving your ability to handle data!

If you’d like this program customized for your organization, call us at 1-800-964-6033. We’re certain we can fulfill your training needs, while making it fit in your budget!

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.

  • During his career, he has produced nearly 200 written and video-based Excel tutorials. He’s also delivered hundreds of courses and webinars on a variety of Excel topics.
  • Thomas is a Fellow of The Learning and Performance Institute and has worked with and for many 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.

About the speaker

Mike Thomas

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.

You May Also Like