Excel Text Functions You Will Need – SMASH!
Learn Functions/Formulas like Left, Trim, Clean, Proper, Substitute, Concatenate, VLOOKUP, Wildcards, Flashfill etc.
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)
-
And much more…
Requirements
-
Having excel installed any version will do (although a couple of functions are more recent and flashfill is 2013 +) 95% of the course applies to any version
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
