Home
0
Home
Use Landscape to see Search/Filter
Item Types:
Field of Study:
Authors:
CPE Hours:
Keyword:
Course Details

Working with Downloaded Text Data in Excel - v11 (Course Id 1838)

QAS / Registry
  Add to Cart 
Author : Joseph P Helstrom, CPA
Course Length : Pages: 27 ||| Review Questions: 6 ||| Final Exam Questions: 5
CPE Credits : 1.0
IRS Credits : 0
Price : $12.95
Passing Score : 70%
Course Type: NASBA QAS - Text - NASBA Registry
Primary Subject-Field Of Study:

Computer Software & Applications - Computer Software & Applications for Course Id 1838

Description :

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. It does provide an exercise file although most examples are simple and easy to type in on your own. In some cases, an answer sheet is also provided in the file.  

Usage Rank : 0
Release : 2021
Version : 1.0
Prerequisites : None.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None.
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 02-Jun-2021
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - Text - NASBA Registry - 1838

Keywords : Computer Software & Applications, Working, Downloaded, Text, Data, Excel, v11, CPAs, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

At the conclusion of this course, you should be able to:
  • 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
Course Contents :

Chapter 1 - Working with Downloaded Text Data in Excel

Course Learning Objectives

Overview

A Note Regarding Excel Versions in this Course

Numbers Formatted as Text

Ways to Convert Text to a Value -Text to Columns

Ways to Convert Text to a Value -=VALUE()

Ways to Convert Text to a Value – Trace Error

Ways to Convert Text to a Value – Paste Special

Text to Columns

Commonly Used Text Functions

LEFT()

MID()

RIGHT()

Concatenate Functions CONCATENATE() and CONCAT()

AMERSAND

TEXTJOIN()

Concatenation and Dates

Combining a Text Function and an IF Function

Review Questions

Evaluating Text using LEN()

Other Useful Text Functions

Upper()

PROPER()

EXACT()

FIND

Cleaning Text

TRIM()

CLEAN()

DOLLAR() and FIXED()

FIXED()

Working with Dates

Review Questions

Link for Spreadsheet

Glossary

CPE Computer Software & Applications Course: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
  
Exam completed on .

Do you want to add the course again?