This introductory online self-study CPE course is designed to empower professionals with the fundamental skills needed for efficient data manipulation and analysis in Excel. It covers a range of vital Excel tools and techniques, such as converting numbers formatted as text to usable numeric values and dates, and understanding the application of specific Excel text functions. Participants will learn how to effectively use functions like LEFT(), RIGHT(), and MID(), understand different concatenation functions, and apply the Text to Columns feature. The online self-study course also includes instructions on how to use the LEN function for text evaluation and the available functions for cleaning text. With step-by-step guidance and an optional exercise file, this course offers a practical approach to mastering these essential Excel skills, greatly enhancing your data analysis efficiency and accuracy.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Recognize the methods used to convert numbers formatted as text to numeric values and dates formatted as text to date values recognized by Excel
Define the LEFT(), RIGHT()and MID()functions in Excel
Recognize different concatenation functions and how to utilize them
Recognize the uses of Text to Columns
Identify how to evaluate text using the LEN function
Recognize functions available to cleantext
Major Topics
Numbers Formatted as Text
Commonly Used Text Functions
Combining a Text Function and an If Function
Other Useful Text Functions
Working with Dates