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.