Category:

Course Description:

Here is an overview of the three methods: 1. Excel’s Text Formulas – We use the UPPER, LOWER and PROPER functions – as well as the TRIM function to get rid of any additional spaces in between words – also space before or after words. 2. Excel Flash Fill – The advantage of flash fill is that you don’t need formulas, the disadvantage is that it’s not dynamic. If your source data change, you have to apply flash fill again. 3. Use an ALL CAPS font. There are fonts that don’t have lower case version. They are purely all caps fonts. Office has a few available by default, but you can download and install other fonts from websites like dafont.com Course Length: 7:55 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.