This intermediate-level Excel online self-study CPE course is designed for professionals who regularly interact with substantial data sets or need to refine imported data. Featuring a detailed walkthrough of vital text manipulation functions like LEFT, RIGHT, MID, LEN, and TEXTJOIN, the course offers an array of tools to enhance data handling capabilities. It not only introduces participants to fundamental functions but also delves into advanced features exclusive to Excel 2019 and Office 365, such as CONCAT, TEXTJOIN, and various rounding functions like ROUNDUP and ROUNDDOWN. The self-study CPE course's benefits include learning to swiftly correct import errors, clean data effectively using functions like CLEAN, UPPER, and LOWER, and mastering the Flash Fill feature for quick data adjustments. Upon completion, participants will be proficient in extracting, joining, and rounding text data, ensuring accuracy and efficiency in their Excel tasks.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Chapter 1
Recognize different functions and how to use them to extract and join text strings
Identify and apply the Flash Fill feature
Chapter 2
Recognize how to fix error messages in a worksheet
Recognize how to import and clean data
Chapter 3
Recognize the different functions available to round values
Major Topics
Counting Characters
Error Functions
Importing Data
Rounding Values
