Blog

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?

3 quick tips in Edge Chromium

Adil Zarkan
07/04/2021

Edge Chromium was recently made a lot smarter, which means users can now get a lot more out of it!

In this post, I’ll share my three favourite new Edge Chromium features.

Know what you’re sharing with whom in OneDrive

Kurt Bolsens
25/03/2021

Security awareness in Microsoft 365 starts with the user

Before the cloud era, corporate data were managed by trained IT specialists. Then came the cloud, which has led to a major change: today, the end users themselves are largely responsible for their own data. This shift does come with a downside – it wouldn’t be the first time that someone accidentally shares a document with the entire company when only the CEO was supposed to receive it.

It’s vital that employees are well informed about saving and sharing documents via cloud applications such as OneDrive, Teams or SharePoint.

Storing files in the cloud has its advantages: you can access them anywhere and it’s cheaper, safer and more reliable.  Instead of e-mailing a file to 10 people, you can now share it and let 10 people edit it. They can even all edit the document at the same time!

But how do you make sure you don’t lose track of which files you’ve shared, and with whom?

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