Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Managing List-Based Data in Excel

Price: $
Share

Summary

Duration: 90 mins

Excel 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.


Topics covered:

  • 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 attend

Learn 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.

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

REGISTRATION

Managing List-Based Data in Excel

Live event begins Thursday, May 9, 2019, 1PM (ET)

Live +
On-Demand $249
more info
You will receive access to the live event which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. 2-3 business days after the live webinar concludes you will also receive a link with unlimited access to the on-demand recording of the live session that you can revisit, review and share with colleagues.

If you can’t make it live, no worries!
You’ll receive the recording and materials after the event.

Register Now

A Note to Our Valued Attendees Impacted by COVID-19:

We understand that due to COVID-19, most people are working remotely and in multiple locations, so we're doing things a little different to accommodate such situations.

After registering, simply reply to your invite email with a list of all the folks who will need additional access links.. Please include their first name, last name, and email address.

REGISTRATION

Managing List-Based Data in Excel

Live event begins Thursday, May 9, 2019, 1PM (ET)

Live + On-Demand $199
Register Now

REGISTER NOW

Live Event

Thursday, May 9, 2019

at 1PM (ET)

Live + On-Demand $249

If you can’t make it live, no worries!
You’ll receive the recording and materials after the event.

Register Now

A Note to Our Valued Attendees Impacted by COVID-19:

We understand that due to COVID-19, most people are working remotely and in multiple locations, so we're doing things a little different to accommodate such situations.

After registering, simply reply to your invite email with a list of all the folks who will need additional access links.. Please include their first name, last name, and email address.

Live Event

Thursday, May 9, 2019

at 1PM (ET)

Live + On-Demand $199
Register Now

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In