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
 
Request Replay Date:
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
90 minutes
  •  Wed, September 26, 2018
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:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Beyond Numbers: Tame Lists and Tabular Data in Excel 2010-16
    Presenter(s): Mike Thomas

 
 
 
Our Accreditation Partners
DMCA.com Protection Status