Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

Category

Excel

Turn off the Start Screen in #Microsoft #Office

Are you tired of seeing that Start Screen in #MicrosoftOffice first, then you have to click on new document to open the application? Well I was as well, so here's another tip for you to save a couple of minutes... Continue Reading →

Restore corrupt files which are saved on #OneDrive or #SharePoint

AAARGHH!!!! There is nothing as frustrating as receiving that "Excel cannot open the file.... file has been corrupted." message. This happens to me occasionally, especially on those files that I edit often, across different devices and when the files have... Continue Reading →

From Talent to Skill with #Microsoft365

I meet many people who go through life thinking they don't have any talents. This couldn't be further from the truth. Our environments don't always support the development of those talents, but that doesn't mean we don't have them. I... Continue Reading →

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

Powered by WordPress.com.

Up ↑