Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel Lists & Tables 101: Solutions for Unlocking Data-Driven Success
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
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.
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!
Purchase this On-Demand Workshop
Excel Lists & Tables 101: Solutions for Unlocking Data-Driven Success
On-Demand $199 +
applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 +
applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 +
applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
