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:
- Recognize how to convert numbers formatted as text to numeric values recognized by Excel
- Recognize and define Concatenate()
- Identify and apply text functions that capture or count characters in a text string
- Identify Excel functions that will convert text to a number
- Recognize the steps required to convert a text number with a trailing minus to a negative number
- Identify text functions and features such as Text to Columns that will convert text to data
- Identify text functions that will format text data
- Identify text functions that clean up text