Blog

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.

Use custom tooltips to create interactive BI reports

Frank Bastien
02/06/2021

When you create a report in Power BI, you can use different kinds of visuals which are designed to let you analyse data from different perspectives. There are also several methods available to distil additional information from your data, such as drill-down, drill-through, and interactivity between visualisations.

Build your own Power BI reports based on existing data sets

Frank Bastien
26/05/2021

In many organisations, Power BI reports or data sets are created centrally. For reports, this means the organisation aims to create them with a standard setup.

Power BI is a ‘Self-Service BI’ platform, a solution that was developed to give any average user the means to build their own reports and gain insight into specific analyses or questions.  Of course, Power BI offers a ‘light’ version of BI, because not everyone is knowledgeable about BI or has experience with it.

One of the things you can do with Power BI is create reports based on existing data sets. Data sets are the foundation of a report: they contain one or several data sources that have been prepared for use in a data set where needed, as well as the necessary calculations for the analyses performed on these data.

How to hide zero values in an Excel worksheet

Johan Vermeire
27/04/2021

If a worksheet contains rows upon rows of numbers, things can look quite cluttered. 

As you can see in the example above, the large number of zero values draws the eye away from the fields that contain actual data.  

One of the tricks to make the worksheet look less chaotic is by simply not showing the zero values. There are several ways to do this in Excel. 

How to ‘glue’ bits of text together

Johan Vermeire
20/04/2021

Excel has multiple functionalities that combine text from several cells into one big text. This is called ‘text concatenation’. In the examples below, we’ll assume our table includes the following columns: Street, Number, Postal Code and City.

Discover the advantages of the Azure Maps visual

Jeroen De Bruyne
16/04/2021

Power BI offers a range of beautiful visuals that help you present your data in an attractive way. Sometimes, this may lead to a choice overload: which visual fits your purpose best?

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