In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into a comprehensive exploration of Microsoft Excel’s powerful text manipulation tools and functions. He’ll cover a wide range of topics, from mastering the LEFT/MID/RIGHT functions for precise text extraction to transforming text case with the UPPER/LOWER/PROPER functions. Discover the time-saving capabilities of the new TEXTBEFORE/TEXTAFTER and TEXTSPLIT functions in Microsoft 365. Learn how to efficiently use unwanted characters by using the CLEAN and TRIM functions. Dive into the intricacies of the Text to Columns Feature, where you’ll uncover techniques for handling addresses, dates, and names with ease. Additionally, explore advanced features like combining text with the CONCAT function and having Excel read text aloud to you by way of the Text to Speech Command.

Learning Objectives:
• State which XLOOKUP argument causes an alternate value to be displayed in lieu of #N/A.
• Recall the menu in Excel where the Table feature resides.
• Identify the location of the PivotTable command within Excel’s ribbon menu interface.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Upon course completion a course evaluation form is provided for your feedback.

You have 1 year from the time of purchase/enrollment to complete the course.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/