Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

#Microsoft365 Day 244: #Office365 Groups now available in Microsoft Forms

Microsoft Forms are pretty amazing. So easy to create beautiful quizzes and surveys in a matter of minutes - AND they are responsive - looks great on mobile. It is a challenge though if you're the only owner of a... Continue Reading →

#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 →

#Microsoft365 Day 242: Calculate days between Dates with Calculated Columns in #SharePoint

Yup, still on those calculated columns in #SharePoint. So easy to use and they solve a lot o problems and save time. Today I'll show you how to calculate days between dates - the difficult and the easy way. https://youtu.be/d-J_RrZBqoo... Continue Reading →

#Microsoft365 Day 241: Create a Quiz with Microsoft Forms

A Quiz is a great idea to establish skill or understanding after training. It even works well when publishing a new Leave Policy for example. Send out a Quiz to evaluate whether people really understand what's been communicated. The difference... Continue Reading →

#Microsoft365 Day 240: Percentage Profit with Calculated Columns in #SharePoint

Wanna do some cool calculations on your data (lists) in SharePoint. Here's a great example of using Calculated Columns to work out the profit and profit percentage for you. Of course you can then write filtered views that shows profit... Continue Reading →

#Microsoft365 Day 239: Add days to a date with calculated columns in #SharePoint

Here's a real nifty way to do your revision dates in controlled document libraries - automatically. Documents might have different revision cycles, so adding days as a cycle would then calculate the date it needs to be reviewed. Yup!! OTB... Continue Reading →

Up ↑