Awaiting product image

Working with Downloaded Text Data in Excel (DTMC)

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


Price:  $ 9.99

Additional information

Credits

Yes
Format

On Demand
Field of Study Department

Computer Software and Applications
CPE Approved

Yes

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 the methods used to convert numbers formatted as text to numeric values and dates formatted as text to date values recognized by Excel
  • Define the LEFT(), RIGHT() and MID() functions in Excel
  • Recognize different concatenation functions and how to utilize them
  • Recognize the uses of Text to Columns
  • Identify how to evaluate text using the LEN function
  • Recognize functions available to clean text

Designed For:

All CPAs

Customer Reviews

Based on 3 reviews
100%
(3)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
P
Pamela N. (Wilmington, US)
Useful course

This course was very helpful and I have already found myself using what I learned to prepare, sort, and filter tables in Excel.

J
Jennifer S. (Foster, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

L
Lauren V.D. (Montgomery Village, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

Follow by Email
Facebook
Twitter
LinkedIn
Share