Text Functions

$69.00 / year

Course Overview:

This course covers Excel’s powerful Text Functions. Everything from how to manipulate text strings, join text strings, and convert text to numbers and numbers to text.

Key Topics:

  • Understand how to manipulate text and numbers in Excel.
  • Be able to find length, left-most, right-most, and middle characters of a string of characters.
  • Be able to remove spaces and hidden characters by learning about the Trim, Substitute, and Clean Functions.
  • Be able to locate text using the Search and Find Functions and learning the differences between the two.
  • Be able to change the text to numerical values.
  • How to substitute text and join cells with the concatenate functionality in Excel.
  • How to use Flash Fill to quickly manipulate text without formulas.

Who Will Benefit?

Any professional that uses Microsoft Excel and wants to create a solid foundation.