0
| 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 : |
Import or export text (.txt or .csv) files
|
| 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:
|
| 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 |
Login/Register