Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

#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 250: Save time with custom formatting styles in #Microsoft Excel

The formatting possibilities in Excel are endless, and I have to admit, I most probably spend too much time trying to format cells. There are specific styles I use, so the fact that we can setup custom formatting to always... Continue Reading →

#Microsoft365 Day 249: Document and determine ROI on your solutions – #Office365 Citizen Developers (part 2)

#Microsoft365 #Office365 As part of a mini series for #CitizenDevelopers I'll be sharing tips and tricks around Business Analysis, Project and Change Management. Today we'll take a look at documenting your solutions. Yes. It's painful, I know. But I do believe... 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 →

Up ↑