Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel Text Functions: Learn them in 30 Minutes!

What are Text Functions in Microsoft Excel? Although Excel is mostly associated with numerical data and analysis,it's also really useful for managing text ba...
3.8
3.8/5
(6 reviews)
374 students
Created by

8.4

CourseMarks Score®

8.5

Freshness

7.1

Feedback

9.0

Content

Platform: Skillshare
Video: 33m
Language: English
Next start: On Demand

Top Text Functions courses:

Detailed Analysis

CourseMarks Score®

8.4 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

8.5 / 10
This course was last updated on 8/2020.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

7.1 / 10
We analyzed factors such as the rating (3.8/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.0 / 10
Video Score: 7.6 / 10
The course includes 33m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.4 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Table of contents

Description

What are Text Functions in Microsoft Excel?

Although Excel is mostly associated with numerical data and analysis, it’s also really useful for managing text based data. Text functions allow you to change the format of text, combine different text strings, extract parts of a text string, substitute one text string for another, and more!

Who is this class for?

This classed is designed for any Excel user (beginner to advanced) who wants to learn about text functions. Text functions are useful for a wide range of tasks and professions, although are usually not the most common functions for Excel users to learn, so if you don’t think they could be useful for you to learn, you might be surprised!

If you’re completely new to Excel, you’ll benefit from taking my ‘Excel for Beginners: Learn the Essentials in 50 Minutes’ class before taking this class.

What will I learn?

In just 30 minutes, this class covers the following topics:

  1. Changing Text Formatting: Useful Tips
  2. How to Extract Text with LEFT
  3. Combining Text with CONCAT
  4. Combining Text: CONCAT or CONCATENATE?
  5. Combining Text with TEXTJOIN
  6. Extracting Text with LEFT, RIGHT, and MID
  7. Searching and Extracting Text with MID and SEARCH
  8. Changing Text with SUBSTITUTE
  9. How to Convert data to Text: A Useful Tip

You will learn

Download the ‘Excel Text Functions’ file and complete the following activities:

  1. In the first tab, use a CONCAT formula to create the sentence: “This [product] is made of [material] and is [colour].” Reference the cells when referring to the product, material, and colour, and fill your formula down to create four sentences.
  2. In the second tab, use a LEFT function to extract the price (e.g. “$27”), and fill the formula down to get the price for all five items.
  3. In the third tab, use a TEXT function to get the full text month (e.g. “February”) for the date, and fill the formula down to get this for all the dates.
  4. Bonus task: repeat task two with a formula that uses the SEARCH and MID functions instead of LEFT.

Requirements

There is no prerequisite, anyone can begin this course.. This course is also great for beginners without any Text Functions knowledge.

This course is for

This course is suitable for beginners.

How much does the Excel Text Functions: Learn them in 30 Minutes! course cost? Is it worth it?

You can enrol in this course with a Skillshare subscription that costs $8/month, but you start with a FREE 7-day trial. You can also enrol in thousands of courses on a variety of topics with your subscription, including several Text Functions courses.

Does the Excel Text Functions: Learn them in 30 Minutes! course have a money back guarantee or refund policy?

There is no money-back guarantee with Skillshare, but you can start with a free one-week trial to learn without risk. With the subscription, you can download classes to your tablet or phone using the Skillshare app.

Are there any SCHOLARSHIPS for this course?

At the moment we couldn't find any available scholarship forExcel Text Functions: Learn them in 30 Minutes!, but you can access more than 30 thousand classes for $8/month on Skillshare, including this one!

Who is the instructor? Is Excel Classes a SCAM or a TRUSTED instructor?

Excel Classes has created 6 courses that got 132 reviews which are generally positive. Excel Classes has taught 4,862 students and received a 4.4 average review out of 132 reviews. Depending on the information available, Excel Classes is a TRUSTED instructor.
Excel teacher
Excel teacher

8.4

CourseMarks Score®

8.5

Freshness

7.1

Feedback

9.0

Content

Platform: Skillshare
Video: 33m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Excel Text Functions: Learn them in 30 Minutes! rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/excel-text-functions-learn-them-in-30-minutes/" target="_blank" title="Excel Text Functions: Learn them in 30 Minutes! on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/84.svg" width="200px" alt="Excel Text Functions: Learn them in 30 Minutes! rating"/></a>