Tracy van der Schyff

Facilitating The Evolution of Human Capabilities



#Microsoft365 Day 243: Fix Text Case with Formulas in #SharePoint

One of my favorite formulas for data cleanup in Excel - and I didn't know I could use it in SharePoint. Winner winner chicken dinner if you ask me - this would fix a lot of that nasty Single line... Continue Reading →

Day 282 – Data Cleanup Formulas for SharePoint

#Office365Challenge To conclude my posts around calculated column formulas in SharePoint, I'd like to share my favourites for data cleanup. Day: 282 of 365, 83 left Tools: Office 365, SharePoint Description: Data Cleanup Formulas for SharePoint Audience: All Related Posts: Day 275 –... Continue Reading →

Day 146 Change the case of text in Excel

#Office365Challenge - I must admit, when I see spreadsheets or documents typed in All Caps, I get a little bit annoyed. I always say people typing in CAPS only, do it because they're lazy (excusing when the process actually calls for... Continue Reading →

The lighter side of Microsoft #1: Excel functions – fixing capitalization & removing duplicates:

The reason for starting to write this blog is that I’ve come to the realization that there are millions of people out there – not using Microsoft Office to its full potential. I give SharePoint training, as well as build... Continue Reading →

Up ↑