Excel - Working with Downloaded Text Data

Excel - Working with Downloaded Text Data
Click to enlarge
Price: $12.99
Credits: 3
Prerequisite: N/A
Level: N/A
Model: PM09
Author: Patricia McCarthy/Joe Helstrom
Average Rating: Not Rated
Fields of study: Computer Science
Format: PDF


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.

This course provides step by step instruction however it does not provide any exercise files.

Course Learning Objectives


At the conclusion of this course, you should be able to:






    • 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
   

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

 

Write Review
Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad            Good

Enter the code in the box below:

There are no additional images for this product.
No Records.