Chat with us, powered by LiveChat

Working with Downloaded Text Data in Excel (DTMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Overview
Credits
1.5
Qualifies For
CPE



Price:  $9.99
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.

Additional information

Credits

1.5

Format

Self-Study Download

Company Code

Self Study

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (Non-Technical) (1)

Field of Study Department

Computer Software & Applications (Non-Technical)

Course Version

2019-01

CPE Approved

1

Pre-requistes:

None

Knowledge Level:

Overview

Major Topics:

  • Numbers Formatted as Text 
  • Using Text to Columns 
  • Commonly Used Text Functions 
  • Evaluating Text 
  • Cleaning Up Text 
  • Working with Dates 
  • New Text Functions in Excel 2016 

Learning Objectives:

  • 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 te

Designed For:

All CPAs