Text Editing Functions in Excel

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
I spent many years learning the mathematical formulas in Excel but I never knew about the text editing formulas. Simple functions such as “LEN” which tells you how many characters there are in a cell have proven valuable over the years. When you’re dealing with data and you’re trying to control it for post-processing, text editing functions come in very handy. In addition, when you’re trying to clean up data, these functions make it a breeze. 

TARGET AUDIENCE
For anyone that deals with large data sets, particularly with words and letters that need processing. 

STRUCTURE
This course contains less than 10 videos making it easy to complete and has a total time just over 20 minutes. 

DIFFICULTY
You will need to be familiar with how formulas structured and linked in Excel. Therefore, this course will be ideal for beginner to intermediate level users. 

COURSE OUTCOMES

  • Text length function
  • Data Trimming
  • Font Selection
  • Left and Right Trimming and Cropping
  • Find and Replace
  • Data Ordering 
  • Spell Check Function

Course Structure

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.