Blog

7 ways to save time when processing data in Excel VBA

Pieter Bollen
14/12/2018

This is the first in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In this blog post, you’ll learn how to save time by making certain cells equal to others instead of copy-pasting separate cells/ranges.

Access tip 3: how do you create a split form with several tabs?

Caro Willekens
07/12/2018

This is our third and last tip in this blog series about Access layout. Today, I'll teach you how to create split forms. Let's use the wine example in the first Access layout tip: imagine you'd like to keep track of a customer's information and order history in an organised way. A tabbed form could help tremendously.

Access tip 2: how do you require a value in an Access field?

Caro Willekens
16/11/2018

I’m back with another Access tip. This time, I’ll explain how to require information in a field in your forms. There’s a lot of information that can be collected within a company. Not all details are equally important, though, so you’ll want to make sure you do get the most important information. That’s where required fields come in handy.

3 tips for file formatting in Access

Caro Willekens
09/11/2018

Do you have some experience using Access, but feel like you could still use some tips to handle formatting? Read on for three tips that are sure to help you – and keep an eye on our blog in the next two weeks as well. The first tip is about conditional formatting.

How to link OneNote notes to PowerPoint slides

Raf Danckaert
12/10/2018

While attending a presentation or meeting, it can be a good idea to take notes. If you have the PowerPoint file, you can just type your notes in the slides or in the text pane below. But you can also take notes in OneNote and link them to your slides.

Windows 10: Save storage space with these 2 OneDrive features

Raf Danckaert
27/09/2018

‘No storage space left’ is one of the most annoying problems you could be confronted with. Of course, you could just dump everything in the cloud – but sometimes, it’s easy to have your files saved locally as well. OneDrive and OneDrive for Business have two features that can help you save storage space. Here’s how to use them.

Windows 10: Find your favourite contact in no time with People

Raf Danckaert
21/09/2018

There are probably some people in (or outside of) your company with whom you communicate more than with others, be it via Skype, e-mail or another channel. But if you need to look up their contact information every time you need them, communicating becomes a bit of a pain. Of course, you could just save them as favourites, but what if I told you there’s a faster way to contact your favourite recipients?

Forgot your password? Here’s how to retrieve it

You visited a website ages ago, made an account and saved your password. Every time you visit this website, you get logged in automatically. That’s great, but if you need to sign in on another computer, cleared your browser’s settings or accidentally logged out, you’re left scratching your head: what’s your password again?

UserVoice: Take part in decisions about your favourite Microsoft application(s)

Johan Vermeire
28/08/2018

In the past, a new version of Microsoft Office was released every few years. Office 365 is different: it only has one version, which is updated regularly. Whenever a new Office version came out, we – as trainers – were curious to see the new functionalities Microsoft had integrated into the software. It made us wonder: “What will Microsoft come up with next time?” Well, they’ve still got plenty of inspiration!

4 reasons to work with OneDrive

Caro Willekens
20/08/2018

Imagine this: you’re at home or on vacation and suddenly, you have an epiphany about a project at work. Of course, you’d want to write it down ASAP so that you don’t forget it. But did you know you can also enter your idea directly into the work document? If your document is saved to OneDrive, you can access it anywhere – even on your smartphone...

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