Blog

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.

What does MyAnalytics have to offer people managers?

Janne Maes
06/07/2021

We’ve been working from home for more than a year. Corona fatigue has become unavoidable. Do you have any idea how your team is coping? And what about you and your relationship with the team? To get everything on track in your job as a -people- manager, there is now MyAnalytics Insights from Microsoft 365: an ultra time-efficient solution that gives you clear insights into your relationships with team members. The MyAnalytics leadership page helps you monitor productivity, engagement and well-being. This enables you to quickly make the appropriate changes where necessary.

An interactive overview in a PowerPoint presentation: the Summary Zoom

When giving a presentation, i.e. in Slide Show mode, many people tend to prepare the slides in a strict sequence. This can result in a presentation with many ‘intermediate slides’ which show the overview or agenda of the presentation.

But these intermediate overview slides are not actually necessary. You can easily switch between overview and a specific topic/slide in the presentation, without the need to manually create specific slides for this purpose.

In PowerPoint, you can use the Summary Zoom. This will result in an interactive slide with a corresponding zoom effect, which gives you an extremely easy way to move around your presentation. You're probably thinking 'that's a lot of work..'. No, not at all, it only takes a few clicks.

How to edit or delete a posted message in a Team or chat

Kurt Bolsens
21/06/2021

Woops! You’ve just noticed a glaring typo or sent wrong information in a Team or chat. Don’t panic – you can still correct the error.

How to edit Power BI visuals as a user

Frank Bastien
10/06/2021

In most organisations, reports in Power BI and on other BI platforms are created by specialists in consultation with the person who requested the report. While these reports meet most expectations, there are situations where users need or want to have their data presented in a different way. They might want to include an additional perspective that wasn’t in the original report, for example.

This need is often temporary and doesn’t require the existing report to be changed.

To accommodate this, Power BI now offers users the option to change the way visuals are displayed. This option is called ‘Personalize Visuals’. The precursor to this option, ‘Decomposition Tree’, was similar in some ways. In this blog post, I’ll shed some light on both options.

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