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