Working with Downloaded Text Data in Excel

Course Description:

This is an introductory course covering the basics of Excel tools and techniques dealing with downloaded data in a text format.  It covers converting numbers formatted as text to numbers usable by Excel functions, concatenation, text to Columns and specific Excel text functions to manipulate and analyze data.

Learning Objectives:

Upon successful completion of this course, participants will be able to:

·         Convert numbers formatted as text to numeric values recognized by Excel.

·         Identify and use the Trace Error button in Excel.

·         Use the Left, Right and Mid functions in Excel Define internet.

·         Concatenate text.

·         Use Text to Columns to format text.

·         Evaluate specific text data using Len and Find.

·         Clean up text using the Upper, Lower, Proper, Trim and clean functions in Excel.

·         Securely and politely send and receive email Convert dates formatted as text to dates recognized by Excel.