Manipulating Text with Excel Functions
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.

Course Publication Date: March 28, 2020

This course is available with NO ADDITIONAL FEE if you have an active self study membership or all access membership or can be purchased for $20.00!

Author:Mill Creek Publishing
Course No:COMP-MANIP-2920
Recommended CPE:1.00
Delivery Method:QAS Self Study
Level of Knowledge:Overview
Prerequisites:Knowledge of Excel and how to create a formula and use functions
Advanced Preparation:None
Recommended Field of Study:Computer Software and Applications
  
Learning Objectives
  • Recognize different functions and how to use them to extract and join text strings.
  • Identify and apply the Flash Fill feature.
  • Recognize how to fix error messages in a worksheet.
  • Recognize how to import and clean data.
  • Recognize the different functions available to round values.

CPE Depot Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Sponsor Number: 109423

 (667ms)
CPE-WEB02 3.238.173.209 url(WWW.CPEDEPOT.COM)-domain(WWW.CPEDEPOT.COM)-anon

Search Courses

Group Plan

Group plans are convenient and cost effective!

Authors Wanted

We are looking for authors!