Microsoft Excel - Managing List-Based Data


Training Format: Recorded Webinar

Format Type: DVD

Speaker(s): Mike Thomas

Supporting File(s) : Download Zip (658.18 KB)

Webinar Date: Wednesday, June 12, 2019

Training Duration : 90 minutes

Training Material Download : Training Material (Password Required) (438.27 KB)

TRAINING DESCRIPTION


Untitled Document

Get Your Lists and Databases in Control With These Excel Tricks

If you think that Excel is all about working with numbers, then think again. More and more people are turning to Excel to help them to manage list-based and tabular 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.

In this 90-min session, Managing List -Based Data With Microsoft Excel by expert speaker Mike Thomas you’ll learn how to deal with and fix all these issues. You'll also learn about managing list and tabular based data in terms of sorting (into different orders), applying and saving filters (that let you display only certain items) and summarizing with Pivot Tables.

Although the training will be delivered using the latest version of Excel, this training is relevant for users of Excel 2010 and above.

Session Highlights
At the end of this webinar, participants will be able to learn the quickest and best ways to explore, visualize and sort your data:

  • Sorting a list of items into alphabetical, numerical or chronological order
  • Using List Filters to display only those items matching a given criteria (e.g. top 5 sales regions)
  • Saving a Filter for re-use
  • Converting a list into a Table
  • Creating a Table
  • The benefits of a Table-based list
  • Table Slicers - taking Filters to the next level
  • Table Formulas - using Structured References
  • Creating a Pivot Table to summarize list-based data
  • Using the VLOOKUP function to "look up" a value from a list
  • Using the COUNTIF function to compare two lists
  • Cleaning up imported/downloaded data
  • Removing duplicates from a list
  • Importing and linking to non-Excel data

Why you should attend?

If you manage list-based data in Excel and want to learn some best practice techniques for working with this type of data, this session is for you.

Who Should Attend?

There's nothing particularly advanced about the features covered in this session so 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.

Novice or expert Excel users who Any Excel user who want to know how to represent data visually..

  • Data analysts
  • Finance professionals
  • Leaders
  • Human Resource Professionals
  • Office Managers
  • Staff
  • All Excel users
Have a question? Ask your doubts at the Q&A session after the live event and get special advice pertaining to your specific situation, straight from our expert speaker.

 

ABOUT TRAINER


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. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and .. Read More >>





TRAINING OPTIONS


Quantity  

( * ) Single User Price Only.

For Multiple Users/Group, Call 1-888-409-0777.

WE ALSO RECOMMEND


Data Analysis & Quick Decision Making With Microsoft Excel
by Mike Thomas