Excel 2016 Course: Learn Excel Text Functions- Now With CC
4.5 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,022 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course: Learn Excel Text Functions- Now With CC to your Wishlist.

Add to Wishlist

Excel 2016 Course: Learn Excel Text Functions- Now With CC

Excel 2016 tutorial course- Learn Excel text functions. Course is full English caption enabled. Jan 2016 updated.
4.5 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,022 students enrolled
Last updated 2/2016
English
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 42 mins on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand how to use common string functions in Excel
  • Understand how combining string functions can be used to clean Excel data
  • Students will gain the foundations to go and apply these functions to their own Excel work
View Curriculum
Requirements
  • Need to have Excel 2013 or Excel 2016
  • This course assumes the student has a working knowledge of Excel
Description

*Course updated January 2016- now with full English Closed Captions (subtitles!) and new Excel content added*

This bite size Udemy Excel 2016 course will show you how to use Excel string functions that are frequently used to perform operations on strings for everyday tasks such as cleaning data.

If you want to know how to use common Excel string functions then take this Udemy course.

You will learn how to extract text from strings, how to search within strings, how to replace characters in strings and much more.

Each lecture explains the Excel string function and gives examples. Excel is one of the most popular tools used today in businesses. Knowing how to use functions in it is necessary.

As with this and our other Udemy Excel courses by us (Mach 42 Productions), support is given via the discussion forums and all the Excel workbooks are provided. Remember these Excel skills are for life and will help you do better.

I look forward to seeing you on the other side!

Who is the target audience?
  • Beginners to intermediate users of Excel
  • Analysts, particularly those on the data side who regularly clean data and need a refresher
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 43:01
+
Introduction to this course
2 Lectures 02:53
+
Text functions used commonly in Excel part 1
3 Lectures 21:48

Covers how to use the len() function

Preview 04:33

Quiz on length of strings

Strings length quiz
2 questions

This lecture shows you how to find and locate text within a string.

Finding text within a string
07:50

Quiz on finding text

Finding text quiz
2 questions

This lecture covers the search() function. This is very similar to the find() function but with 2 notable differences...

Finding text within a string part 2
09:25

Quiz on searching in Excel using the search() function

Searching text quiz
3 questions
+
Text functions used commonly in Excel part 2
3 Lectures 16:57

This lecture covers a super handy way to extract characters from text

Extracting text from a string
08:12

Quiz on extracting text

Extracting text quiz
2 questions

This lecture covers how to remove excess spaces from strings

Getting rid of excess spaces
04:35

Quiz on trimming text

Trimming text quiz
2 questions

Learn how to join strings/text together:)

Preview 04:10

Quiz on joining text

Joining text quiz
2 questions
+
Wrap up section
2 Lectures 01:23

This lecture wraps up the Excel course

Wrap up lecture
00:56

Please leave some feedback!
00:27
About the Instructor
Mach 42 Productions
4.5 Average rating
453 Reviews
14,691 Students
13 Courses
Excel Consulting- 14,600+ Students

Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to develop these range of Excel courses which to date have over 14,600 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.