Excel - Working with Downloaded Text Data

Click to enlarge

Price:	$19.99
Credits:	2.0
Prerequisite:	Basic Knowledge of Excel
Level:	None
Model:	PM09
Author:	Patricia McCarthy/Joe Helstrom
Average Rating:	Not Rated
Fields of study:	Computer Software & Application
Format:	PDF

Description Additional Images (0) Reviews (0) Related Products (0) Package Detail (0)

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
C lick here to view cancellation 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:

Continue

There are no additional images for this product.

There are no related products for this product.

No Records.

Categories

Excel - Working with Downloaded Text Data