There are a number of issues that can emerge when dealing with downloaded text data in Excel. And while there are many tools available to help with this process, they are not always easy to locate and use properly. This course helps clarify how these tools should be used, and addresses common problems and solutions related to handling downloaded data in a text format. The course 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.
This course provides step-by-step instruction; however, it does not provide any exercise files.
Upon successful completion of this course, participants will be able to:
- Recognize the methods used to convert numbers formatted as text to numeric values and dates formatted as text to date values recognized by Excel
- Recognize the function of Concatenate and how to concatenate text in Excel
- Identify text functions that capture or count characters in a text string
- Identify text functions that will format, evaluate, and clean up text in Excel
Table of Contents
A Note Regarding Excel Versions in this Course
Numbers Formatted as Text
Using the Text to Columns Function
Commonly Used Text Functions
Cleaning Up Text
Working with Dates
New Text Functions in Excel 2016
Review Question Answers and Rationales
Choose Your Preferred Format
Get immediate access to a robust collection of learning and reference materials, allowing you to dive deep into the information you need. Our self-study materials are authored by top-quality, industry experts who focus on helping you grasp concepts quickly using real-life examples. Download your CPE to any device, and take it with you so you can learn when and wherever you want. Complete your CPE with an online exam, and enjoy instant grading with the option to print your certificate immediately upon passing.
Our self-study materials are authored by top-quality, industry experts. You’ll receive a bound notebook of all the course materials, shipped to you within one business day. In addition, you’ll also have full online access. Each self-study package includes a robust collection of learning and reference materials to help you cover the information efficiently and put it into practice immediately.
Experience high-quality instruction with our Self-Study Videos, available to you 24/7. With more than 80+ videos currently in the Western CPE Self-Study Video library, you can see and hear our expert instructors deliver the information you need in a dynamic way that allows you to immediately apply your learning. Unlike a live course or webcast, you can complete the course on your own time, playing and pausing as needed. Self-Study Videos allow you to complete your CPE requirements on your own time.
Back to top