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


Excel 2013: Managing Large Data (IME861P)

Presented By : Mike Thomas
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Tue, August 30, 2016
Event Description
See the sneak peek before you buy!
 
1.0 CPE

Manage Tabular Data and Lists in Excel With Ease!

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, tabular data. In many cases, they receive, download, or import data from elsewhere and before that data can be used within their business and treated as a credible source of information, it needs be seriously checked and cleaned.  There might be duplicate entries, there might be non-printing characters. There might be extra spaces. The data might need splitting up (for example with a list of names, the first name and surname of each customer might be in a single cell which is going to cause problems if you need to sort the list).

In this webinar, expert speaker Mike Thomas discusses how to deal with such problems and fix all the issues related to managing tabular data and lists in Excel. You will learn how to convert a block of data into a Table, which opens up many more possibilities when it comes to managing and working with structured data. You will develop an understanding on how to sort your list alphabetically, numerically and chronologically.

The presentation also covers how to create Filters to display just the data that matches specified criteria. It will teach you how to link Excel to an external data source such as a corporate database or a SharePoint list. And finally, you will also learn how to produce meaningful summaries from your data by using appropriate functions and generating reports.

Session Highlights:

  • Cleaning up imported/downloaded data
  • Convert a range of data into a Table
  • Sorting a tabular list
  • Filtering a tabular list to display only certain items
  • Linking Excel to an external list or data source
  • Creating a Pivot Table from a tabular list>
  • Using appropriate functions to create summaries

Who Should Attend

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals
About Our Speaker(s)

Mike Thomas, Excel Tutorial ExpertMike 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: Excel 2013: Managing Large Data
    Presenter(s): Mike Thomas

 
DMCA.com Protection Status