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

 
 
 
Our Accreditation Partners
DMCA.com 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 service@proedtech.com. 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