Author : | Patricia McCarthy, MBA |
Course Length : | Pages: 26 ||| Review Questions: 3 ||| Final Exam Questions: 5 |
CPE Credits : | 1.0 |
IRS Credits : | 0 |
Price : | $12.95 |
Passing Score : | 70% |
Course Type: | NASBA QAS - Text - NASBA Registry |
Technical Designation: | NonTechnical |
Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1618 |
Description : | This course covers how to manipulate data in Excel. The course focuses on Text functions, such as LEN, TEXTJOIN and SEARCH. It also examines some Math & Trig rounding functions and shows how to fix errors that result when data is imported. Flash Fill is also covered. This course is designed for intermediate users of Excel who either deal with a lot of data or are frequently downloading data. This course covers simple to advanced functions and includes new functions that are only available in Excel 2019 and/or Office 365. Functions covered include: LEFT, RIGHT, MID,LEN, FIND, CONCATENATE, CONCAT, TEXTJOIN,IFERROR, TRIM, CLEAN, UPPER, LOWER, PROPER, SUBSTITIRE, NUMBERVALUE, TIMEVALUE,DATEVALUE, ROUND, ROUNDUP, ROUNDDOWN, MROUND, FLOOR, CEILING. |
Usage Rank : | 13636 |
Release : | 2020 |
Version : | 1.0 |
Prerequisites : | Knowledge of Excel and how to create a formula and use functions. |
Experience Level : | Overview |
Additional Contents : | Complete, no additional material needed. |
Additional Links : |
Text Functions
|
Advance Preparation : | None. |
Delivery Method : | QAS Self Study |
Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
Revision Date : | 01-Mar-2024 |
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 - 1618 |
Keywords : | Computer Software & Applications, Manipulating, Text, Excel, Functions, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives
2. Identify and apply the Flash Fill feature 3. Recognize how to fix error messages in a worksheet 4. Recognize how to import and clean data 5. Recognize the different functions available to round values |
Course Contents : | Chapter 1 - Manipulating Text with Excel Functions Counting Characters LEFT(), RIGHT(), MID() COUNTING CHARACTERS in a CELL FIND() LEN() LEN() and LEFT() Flash Fill Joining Text Together Ampersand Concatenate() TEXTJOIN() LEN CONCATENATE IF- Example Review Question Error Functions IFERROR() IFNA() Importing Data TRIM() CHAR( CLEAN() Case Substitute REPLACE vs SUBSTITUTE NumberValue() VALUE() TEXT() FIXED() TIMEVALUE() and DATEVALUE() Review Question ROUNDING VALUES ROUND() ROUNDDOWN() and ROUNDUP() =MROUND() FLOOR() and CEILING () Rounding Integers EVEN() and ODD() Review Question Glossary Chapter 2 - Links for Spreadsheets Glossary |