Mark Miller at EndUserSharePoint has created an 8 minute screencast that showcases my “HTML calculated column”. The video, called “SharePoint Dashboards – My Task Assignments”, is part of a series about creating dashboard pages.

The other videos of the series are also worth a look, as they’ll give you an idea of what can be done using only the SharePoint UI. What I like in Mark’s screencasts is the combination of a high level presentation with drill-downs that capture key details.

The “HTML calculated column” is a method that allows you to use SharePoint calculated columns to write HTML. It has multiple applications, and can often replace heavier customizations done through SharePoint Designer or programming. The whole series, including the method and various examples, is available on this site:
https://pathtosharepoint.wordpress.com/category/the-html-calculated-column/