Working with Downloaded Text Data in Excel

Price: $13.25

CPE Credits: 1.5

Category: ,

Course Number: EX07IDMC

working with downloaded text

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.  Table of Contents   This course provides step by step instruction however it does not provide any exercise files.
Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This course is written for 2010 however it also covers later versions through 2016.

Prerequisites: None

Advanced Preparation: None

Author: Patricia McCarthy

Publication: April 2011
Updated: January 2017

Format: PDF
Pages:
52

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the 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

 

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.  Table of Contents   This course provides step by step instruction however it does not provide any exercise files.
Delivery Method: Online QAS Self Study.

Level: Overview.

Version: This course is written for 2010 however it also covers later versions through 2016.

Prerequisites: None

Advanced Preparation: None

Author: Patricia McCarthy

Publication: April 2011
Updated: January 2017

Format: PDF
Pages:
52

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the 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

 

  • Great course! Price was right and the material was very thorough.

    - Alex

  • “It is rare that i can actually say that I enjoyed a CPE course but I found this one informative and very interesting, relying more on the author’s examples and not just quoting tax code!  [Healthcare Reform: The affordable Care Act Tax Provisions]

    - Thomas

  • Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

    - Draper