Favorites
b/training4allbyForeverloving

Excel Text Functions: Learn them in 30 Minutes!

This post was published 2 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.

Excel Text Functions: Learn them in 30 Minutes!

Duration: 33m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 247 MB
Genre: eLearning | Language: English

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
Changing Text Formatting: Useful Tips
How to Extract Text with LEFT
Combining Text with CONCAT
Combining Text: CONCAT or CONCATENATE?
Combining Text with TEXTJOIN
Extracting Text with LEFT, RIGHT, and MID
Searching and Extracting Text with MID and SEARCH
Changing Text with SUBSTITUTE
How to Convert data to Text: A Useful Tip

Interested in learning more about Excel? Check out other classes

Excel for Beginners: Learn The Essentials in 50 Minutes
Excel Efficiency Class: Keyboard Shortcuts & More in 40 Minutes
Excel Formulas You Need to Know in 30 Minutes
Excel Lookup & Reference Functions for Beginners
Excel Pivot Tables for Beginners: Learn them in 20 Minutes
Excel Date & Time Functions & Formatting in 30 Minutes

Screenshots

Excel Text Functions: Learn them in 30 Minutes!

No comments have been posted yet. Please feel free to comment first!

    Load more replies

    Join the conversation!

    Log in or Sign up
    to post a comment.