Excel 50 blogposts

PivotTables, functionalities, databases, graphs, Power Pivot, Power Query, ... When we hear these words, only one thing springs to mind: Excel. But the tool actually packs much more power: you can use it to boost your efficiency and productivity. Does that sound tempting? Become an Excel wizard with the inspiring tips and tricks in this blog. Our tips are useful for beginners as well as advanced users.

Bulk create Teams Meetings based on an Excel list

Frank Bastien

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.

How to hide zero values in an Excel worksheet

Johan Vermeire

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

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.

Excel: How to use cell names to block a cell in a formula

As an Excel user, you undoubtedly know that you can use the $ sign to block a row or column in a formula. This creates an ‘absolute address’. Excel offers another method to block a cell or a cell range: by naming the cell(s).

Excel: How to name one or more cells

Every Excel cell has its own address: a letter that identifies the column and a number that indicates the row. Did you know that you can rename a cell? Discover how naming cells in Excel can help you in this blog post.

Excel: Format dates with the TEXT function

Pieter Bollen

In this blog post, I’ll let you in on a date formatting trick. I’m not talking about date formatting through Format Cells, but about the date format you enter manually when using the TEXT function. 

Excel: How to lock a column in table formulas

Pieter Bollen

Can’t get enough of Excel? Good! In this blog post, we’ll teach you another Excel trick. When Microsoft introduced tables in Excel in 2007, it became impossible to use the dollar sign ($) to lock rows or columns. This isn’t much of a problem for rows, but what about columns? Read on – I’ll explain how you can still lock these.

Excel VBA tip 7: Create a recordset based on 2 different worksheets

Pieter Bollen

This is the seventh and last blog post in our series about how you can speed up data transformation in Excel VBA. In this blog post, we’ll discuss how you can merge two tables and add them to one recordset. 

Excel VBA tip 6: Use a recordset to read data from multiple files without opening them

Pieter Bollen

This is the sixth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In the previous blog post, we explained how you can save data in a recordset. This time, we’ll show you how to use this technique to open all files in a folder and transfer their data to a target file. 

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