Blog

Integrate your Power BI reports in Teams

Frank Bastien
27/12/2021

We’ve watched Teams grow into a central knowledge and communication hub in most organisations. One of the perks of this software is the fact that you can share and use your reports and analyses in it. In this post, we’ll explain how you can embed your Power BI reports in Teams.

Windows: Automatically lock your PC through your smartphone

Kurt Bolsens
16/11/2021

Lock your PC automatically when you leave your desk!

If you need to leave your desk, even for just a moment, it’s a good habit to always lock your PC before you go.  For many office workers, this is already an ingrained routine because in an office environment, it’s important that no one can access what’s on your computer without permission. But even when you’re working from home, you should lock your PC when you’re away. Why? Because your status changes when your PC is locked, which is helpful for colleagues who might want to contact you through Teams or similar software.

Many experienced office workers habitually use the old keyboard shortcut CTRL + ALT + DEL, followed by ENTER. Windows 10 introduced a new way to lock your PC by pressing WINDOWS + L. But did you know that you can also automatically lock your PC through your smartphone?

Stay on top of every calendar update with Power Automate

Adil Zarkan
26/10/2021

As a Xylos Digital Coach, I’m often on the road to assist our customers. My schedule is managed by our Planning Coordinators through a system that synchronizes with my Outlook calendar. And while this method works, I’d prefer to be made aware of every new item they put on my schedule.

My colleague Kurt came up with an excellent solution: a Power Automate flow (or MS Flow) which sends out a Teams message whenever someone adds an appointment to my Outlook calendar. This flow only takes about 15 minutes to set up.

Ask your co-workers for approval with the Approvals app!

Adil Zarkan
26/10/2021

Imagine you’ve created a document that needs to be approved by 5 people. If you’re like most people, you’d probably contact these colleagues through e-mail or Teams to request their approval.

The downside of this method is that if one person doesn’t respond until 3 weeks later, you’ll have spent 3 weeks needlessly keeping this task in the back of your head, on top of everything else you’re working on.

Fortunately, Microsoft has come up with a helpful solution: the Approvals app.

You can add it to your Teams apps and pin it to request all future approvals through it. After you’ve installed the app, you can open it and view all your sent and received approval requests.

Teams: seven helpful keyboard shortcuts

Kurt Bolsens
14/10/2021

Microsoft Teams is a well-integrated part of many modern work environments - and with the right keyboard shortcuts, you can use the tool even more efficiently. In this blog post, I’ll share my 7 favourite shortcuts.

Three useful Teams tricks

Do you use Teams every day and would you like to know how you can save time in this tool? Read on to discover my favourite Teams tricks.

Power BI tip: Use folders to structure your measures

Johan Vermeire
28/09/2021

In many Power BI datasets, you’ll notice a separate table containing measures.  While this isn’t really necessary, it can be useful.

The downside is that as the number of measures grows, this table will be absolutely flooded with measures, which makes it hard to find the measure you need.

The usual solution for this problem is creating folders in the table... but at first sight, it looks like you can only create folders at the table level, not within the folders themselves.  It is possible, though - if you know how.

Bulk create Teams Meetings based on an Excel list

Frank Bastien
16/09/2021

As an HR, marketing or operational team member, you may have been confronted with situations where you need to set up individual Teams sessions for a series of colleagues.

Wouldn’t it be nice if you could just create and describe those sessions in an Excel table and use that table to create all sessions automatically in Teams at the push of a button?

Well… you can! Power Automate makes it easy to set up automations like this one.

Please do not disturb: Sheet Views in Excel

Did you know? Sheet Views have been around for a while in the online version of Excel, but now they are also being added to the Excel desktop app.

We are increasingly working together on documents. This means that we more frequently open and edit documents at the same time. Sheet Views allow different users to use their personal filtering and sorting simultaneously. And yes, without affecting your colleagues.

In fact, we’re talking about specific ‘views’ here. In order to use them, the file in question must be stored on OneDrive or SharePoint.

Confident typing? Use the AutoCorrect options.

Typing quickly - never mind touch-typing: it's not for everyone. Are there specific recurring words or phrases you need to use in written correspondence that you still haven't got the hang of? Recognising your own typing errors is bound to leave you frustrated. Good news! With AutoCorrect, you're in charge of your own Zen.

In Microsoft Office, every user can rely on an AutoCorrect file. This file is hidden somewhere deep in the C-drive, but can be accessed via the AutoCorrect options window.

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses

Xylos brands