Working with Downloaded Text Data in Excel

SKU: CPE-07-077
Credit Hours: 2
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA

At the conclusion of this course, participants should be able to:
  1. Recognize how to convert numbers formatted as text to numeric values recognized by Excel
  2. Recognize and define Concatenate()
  3. Identify and apply text functions that capture or count characters in a text string
  4. Identify Excel functions that will convert text to a number
  5. Recognize the steps required to convert a text number with a trailing minus to a negative number
  6. Identify text functions and features such as Text to Columns that will convert text to data
  7. Identify text functions that will format text data
  8. Identify text functions that clean up text