What you’ll learn
-
Excel Text Functions and Formulas
-
Left, Mid, Right to extract text
-
Trim and Clean to Remove Unwanted Blank Spaces and non-printable characters
-
Proper, Lower, Upper for text capitalization
-
& Concatenate, Concat, Text Join
-
Difference between Substitute and Replace
-
Difference Between Find and Search
-
Len and Text
-
Isnumber Search Combination and More!
-
Extra: combination with VLOOKUP and wildcards!
-
Extra: Flashfill for replacing text functions! (this feature only exists from 2013 version onwards)
Who this course is for:
- People Learning Excel
- Beginners to Intermediate Users who want to develop their excel skills
- People learning Microsft Office tools (Word, access etc.) that want to fill their knowledge gap with excel
- Working Professionals in general as excel is needed in most professions (Accountants, Controllers, Engineers, Architects, Analysts, Managers, Human Resources Managers, Teachers, Professors etc.)
- College Graduates that need to start preparing for workplace demands
Can I download Excel Text Functions You Will Need – SMASH! course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Excel Text Functions You Will Need – SMASH! course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
