Author : | Patricia McCarthy, MBA |
Status : | Production |
CPE Credits : | 2.0 |
IRS Credits : | 0 |
Price : | $17.95 |
Passing Score : | 70% |
Course Type: | NASBA QAS - Text - Technical - NASBA Registry |
Primary Subject-Field Of Study: | Specialized Knowledge - Specialized Knowledge for Course Id 459 |
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.
|
Usage Rank : | 0 |
Release : | 2017 |
Version : | 1.0 |
Prerequisites : | None. |
Experience Level : | Overview |
Additional Contents : | Complete, no additional material needed. |
Additional Links : |
Working with Downloaded Text Data in Excel Western CPE
|
Advance Preparation : | None. |
Delivery Method : | Self-Study. |
Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
Revision Date : | 28-Sep-2019 |
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 - Technical - NASBA Registry - 459 |
Keywords : | Specialized Knowledge and Applications, Working, Downloaded, Text, Data, Excel, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives At the conclusion of this course, participants should be able to:
2. Recognize and define Concatenate() 3. Identify and apply text functions that capture or count characters in a text string 4. Identify Excel functions that will convert text to a number 5. Recognize the steps required to convert a text number with a trailing minus to a negative number 6. Identify text functions and features such as Text to Columns that will convert text to data 7. Identify text functions that will format text data 8. Identify text functions that clean up text |
Course Contents : | Chapter 1 - Working with Downloaded Text Data in Excel Course Learning Objectives Overview Numbers Formatted as Text Using Text to Columns Commonly Used Text Functions Review Questions Evaluating Text Cleaning Up Text Working with Dates Review Questions Glossary |