Working with Downloaded Text Data in Excel (DTMC)

Customer Rating

Rated 5 out of 5

Field of Study
Computer Software & Applications

Level
Overview

Credits
1

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

year	2021
version	01
Credits	1
Company Code	Self Study
Format	On Demand
Yellow Book Approved	0
CFP Approved	0
IRS Approved	0
CTEC Approved	0
Field of Study Credits	Computer Software & Applications (1)
Field of Study Department	Computer Software & Applications
Course Version	2021-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 text functions that will format text data Identify text functions that clean up text

Designed For:

All CPAs