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 →

Day 327 – Using CONCAT and TEXTJOIN in Microsoft Excel

 #Office365Challenge I've always been a huge fan of data clean-up formulas. LEFT, MID, RIGHT, TRIM, CONCATENATE etc. The January 2016 update had some updates around new functions and data entry. Day:  327 of 365, 38 left Tools:  Office 365, Office 2016, Excel Description: Using... Continue Reading →

Day 228 – Searching entire workbook in Excel

#Office365Challenge By now most of us know that CTRL+F brings up Search in Office. When working with Excel, it's important to know that it will only search the current sheet (by default). Day: 228 of 365, 137 left Tools: Excel Description: Searching... Continue Reading →

Day 166 Excel AutoRecover File Location

#Office365Challenge Excel allows you to set the minutes between AutoRecover saves - and also gives you the AutoRecover Location in case you've never saved that file before. Day: 166 of 365, 199 left Tools: Microsoft Office Excel Description: Excel AutoRecover File... Continue Reading →

Website Powered by

Up ↑