Tracy van der Schyff

Facilitating The Evolution of Human Capabilities



#Microsoft365 Day 257: How to use Data Validation in #Microsoft Excel

Data Validation in Excel: As much as I love #SharePoint or #MicrosoftForms, some things still need to happen in Excel. Should you require users to complete certain fields – then Data Validation is for you. This allows you to validate... Continue Reading →

#Microsoft365 Day 252: Creating Pivot Tables in #Microsoft Excel

There's always a first time for everything.... I've written over 700 blogs about Microsoft and guess what I've never written about - Yup! Pivot Tables. Simply can't believe it. Anyhooo - Pivot tables are a GREAT way to summarize and... Continue Reading →

#Microsoft365 Day 251: Make informed decisions with Insights in #Microsoft Excel

With the help of Insights in Excel, you can get fast, automated, insightful analysis about your data. Simply click a cell in a data range, and then click the Insights button on the Insert tab. Insights in Excel will analyze... Continue Reading →

#Microsoft365 Day 248: Speed up data capture by using Auto Fill in #Microsoft Excel

Auto Fill is a great way to very quickly populate data in series. Think days of the week, months of the year or even series of numbers. Simply drag the corner or double click to auto fill next to an... Continue Reading →

#Microsoft365 Day 247: How to use Branching Logic in #MicrosoftForms?

Here's a great feature in Microsoft Forms which will help making your Forms 'appear' shorter. Why bother people with detail that's not relevant to them? With Branching logic you can decide what the next question is based on the answer... Continue Reading →

Day 336 – Creating Map Charts in Excel

 #Office365Challenge Of course data is valuable, but being able to present it visually helps people to interpret the data much faster, and saves time. The new Map Chart in Excel is brilliant for displaying geographical data and really easy to... Continue Reading →

Up ↑