Course Catalog

Sort by:
Switch to Providers Refine by: All Filters
Filter By: Clear all
Sort by Relevance
Language
System updates are being made to provide better results and help you find professional development opportunities. During this time some search functionality may be limited. Look for improved functionality in the coming months.

Lynda.com (LinkedIn Learning)

Excel 2016: Cleaning Up Your Data
Imported data isn't always pretty. In this course, Dennis Taylor explains how to take data from a system file, database, text file, or poorly designed Excel worksheet, and whip it into optimal shape. Dennis explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert dates into the desired format, and prepare data for efficient analysis. He covers adjusting column and row placement, transposing data with the REPLACE and SUBSTITUTE functions, the Text to Columns command, the new Flash Fill feature, and more.
(75)

Delivery Methods: On-Demand

2.25 PDUs
Talent Triangle
Technical 0.00 Leadership 0.00 Strategic 2.25
  • Page of 1
Loading...