Download Now
Cleaning Up Your Excel 2010 Data
MP4 | Video: 540p | Duration: 1:27:56 | English | Subtitles: VTT | 159.9 MB

In this course, Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis. This course helps get data from a business management system file, other database software, a text file, or a poorly designed Excel worksheet into optimal shape for working with in Excel.

Topics include:
Moving or inserting rows and columns of data with a simple dragUsing Text to ColumnsHarnessing the Find and Replace command to replace data at the character levelDealing with special characters and wildcards during searchConverting dates with text functionsConverting text data to values/numbersChecking and correcting spelling mistakesSplitting data into multiple columns via the Text to Columns featureCombining data from different columns via concatenation
Download link:

Links are Interchangeable - No Password - Single Extraction
Direct Download

Tags: Cleaning

Add Comments:
Enter Code: *