Excel 46 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.

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

Xylos Learning
14/02/2020

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

Xylos Learning
24/01/2020

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
15/01/2020

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
08/02/2019

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
25/01/2019

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
22/01/2019

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. 

Excel VBA tip 5 : Save data in a recordset

Pieter Bollen
10/01/2019

This is the fifth 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, we’ll explain how you can save data in a recordset.

Excel VBA tip 4: Open several files and transfer data to a destination file

Pieter Bollen
04/01/2019

This is the fourth in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. This blog post is a variation on the example from our previous blog post, where we transferred data from one file to a target file: this time, we’ll transfer data from multiple files.

Excel VBA tip 3: Open a file and transfer data to a target file

Pieter Bollen
27/12/2018

This is the third post in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. This blog post teaches you how to open a file and transfer data to a target file. It’s an introduction to the next posts in this series.

Excel VBA tip 2: Add data to a table

Pieter Bollen
21/12/2018

This is the second in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. In this blog post, we’ll show you how much time you can save when adding a large number of cells to a table. 

Are you exploring Office 365 and do you have any questions about the software that need answering? Book one of our virtual workshops today. We’ll help you and your co-workers get up and running with Teams, Power BI, Power Automate, Project Online Professional, and other tools.

Discover the Office 365 workshops

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