Kategori: Microsoft Office

Get the year off to a good start! Every January, we promise ourselves that we will make a better job of this year than last! So, when it comes to managing ourselves, there is no better app to start with than Microsoft Outlook. “But Outlook is as old as time!” I hear you say. Well, […]

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 […]