Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

Excel 2016: Cleaning Up Your Data torrent

Discussion in 'Others' started by Sonia, Mar 27, 2017.

Share This Page

  1. Sonia Freak Member

    Sonia
    Joined:
    Jun 12, 2015
    Messages:
    3,503
    Likes Received:
    129
    Torrent Info URL

    http://https://www.lynda.com/Excel-...ng page:1 s:relevance sa:true producttypeid:2


    Torrent Description
    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.
    Topics include:
    Moving and inserting rows and columns of data with a simple drag
    Replacing data at the character level
    Converting dates with text functions
    Converting text data to values
    Using the CONCAT and TEXTJOIN functions to combine data
    Splitting data into columns via the Text to Columns feature
    Using Flash Fill for faster combining and splitting
    Checking and correcting spelling mistakes
     

    Attached Files:

    etcohod likes this.

Users Who Have Read This Thread (Total: 0)

Top