• The most sweeping update to the U.S. tax code in more than 30 years.
  • Our webinars bring you the convenience of a live CPE seminar experience to your home, office or any of your favorite handheld devices.
  • 24/7 customer support! by phone, text, email and online. Enjoy the peace of mind you deserve. we're here for you when you need it. 
  • Our advanced e learning website keeps you in CPE compliance. All course progress is auto saved in your CPE cloud and accessible 24/7 from your phone, tablet, or desktop pc with  internet access. 
  • 1
  • 2
  • 3
  • 4

Working Downloaded Text Data in Excel

Instructional MethodAdvanced PreparationProgram PrerequisitesField Of Study Interactive Self Study NONE This course assumes a Basic to Intermediate Excel knowledge. Specialized Skill & Computer Knowledge Experience LevelCourse IDCPE CreditsAuthor Intermediate JH-110 1 Joseph P Helstrom, ...Read more
  • Description
Instructional Method Advanced Preparation Program Prerequisites Field Of Study
Interactive Self Study NONE This course assumes a Basic to Intermediate Excel knowledge. Specialized Skill & Computer Knowledge
Experience Level Course ID CPE Credits Author
Intermediate JH-110 1 Joseph P Helstrom, CPA

Working 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.
Topics Covered:
Numbers Formatted as Text
Using Text to Columns
Commonly used Text Columns
Evaluating Text
Cleaning Up Text
Working with Dates
Learning Objectives:
• 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
• 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
• Convert dates formatted as text to dates recognized by Excel


CPE Customer Support Available 24/7

 Call or Text Message 813.638.5985
 Email CPE365@Gmail.com