Kategori: Microsoft Office

When we present data in a report or spreadsheet we often use some type of graph or chart to make the information clearer to understand. Unfortunately, using the wrong type of presentation can confuse the reader. Consider these data: And these two presentations: Intuitively, the second seems easier to read, but why? The first is […]

Like many others, I wrote my first DAX measures in Excel Power Pivot. It seemed so natural to add measures in the editing area associated with the fact table I never considered any other way. But while measures specify one or more tables in their code definition, there is really no restriction on “where” they […]

During a coffee break at a recent Learning Tree course, Excel Data Analysis Training, June C. commented that when she pasted results from the SQL Server Management Studio into Excel “weird things happened.” Well, June, it's actually not weird, but I definitely know what you are talking about. Microsoft Excel and Microsoft SQL Server have […]

Question: Do we still need SharePoint if we start using Teams? Short answer: Yes! SharePoint is a vital part of Teams. Long answer: A few things happen when you create a new team in Microsoft Teams. First it creates a new Microsoft 365 group (formerly Office 365 group) which contains the team of people and […]

What are Office 365 groups? First let us start with: What is Office 365 (O365)? O365 is a suite of applications hosted online by Microsoft. These applications are productivity tools for the business. One of these applications hosted in O365 is SharePoint. An Office 365 group is a set of users that can be used […]