My Shopping Cart
There are no items in your shopping cart.

Beyond Numbers: Tame Lists and Tabular Data in Excel 2010-16 (IME918A)

Presented by: Mike Thomas
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
90 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Import, Sort, and Filter Databases Like a Pro

If you think that Microsoft Excel is all about working with numbers, think again. More and more people are turning to Excel to help them to manage list-based and tabular data, and once you have this skill down you can create dynamic sub-lists and custom reports. Throw a simple macro into the mix, and you can automate work which previously would have taken hours.

Join Mike Thomas, an IT and Excel expert, for this step-by-step training session in which you will learn to import, download, and manage list-based and tabular-based data in Excel. You’ll uncover best practice techniques for working with data, including strategies to sort columns, rows, and lists of date-based items. You’ll find out how to filter a list to display the data you want—and then save the filter for re-use.

After attending this event, you’ll know the benefits of creating dynamic lists and tables—and how to summarize a list with pivot tables and sub-total reports. Sign up now and get ready to expand your Excel skills to better understand and analyze make magic with non-numerical information.

Session Highlights

This program will teach you how to:

  • Sort a column or row of items into order
  • Sort a list of date-based items into order
  • Filter a list to display only certain items
  • Save a filter for re-use
  • Recognize the benefits of tables
  • Summarize a list with pivot tables and subtotal reports
  • Clean up imported/downloaded data
  • Import and link to non-Excel data

Who Should Attend

Anyone who wants to be an Excel 2010-16 power user.

There's nothing particularly advanced about the features covered in this session even if all you've ever done is opened an existing Excel workbook and looked at the data. If you want to know how to manage lists in Excel, then this webinar is for you.

The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel.

About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Beyond Numbers: Tame Lists and Tabular Data in Excel 2010-16
    Presenter(s): Mike Thomas

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team