ExcelTrainer

Latest Posts

Long hyperlinks

Sample: Long hyperlinks

The default hyperlink column has a limited number of characters that can be used, and this will get you into…Read More

Datumtabel in Power BI aanmaken via Power Query

Datumtabellen zijn zeer belangrijk in Power BI en Excel Power Pivot. Doormiddel van datumtabel kan je datumintelligentie functies toepassen en…Read More

Sample: Link to parent documentset of a file

Using documensets is a fantastic way of organising your documents, benefits of documentsets include: This post is not about setting…Read More

Sample: Create a menu based on page titles

Recently I had to create an informative communication site with multiple pages divide in multiple “chapters”. And because of vast…Read More

Sample: Calculated columns and Column format

In this example I will be trying to get more out of a date column. So, assuming I have a…Read More

Sample: Circle in a circle

After seeing this tweet from Ruth Pozuelo, I was triggered to see if we can do something similar with column…Read More