ExcelTrainer

Latest Posts

A Gantt Chart view applied to a modern SharePoint list

Gantt Chart view in SharePoint version 2.1

This is the updated version of the Project Gantt Chart view for SharePoint Online. 2024-07-13: Code updateRead More

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