Student resources from recent courses

The list below is of courses taught recently in which questions came up or additional points needed to be made. Click through to see the conclusion of each question.

February 2021

Learning Tree course D140 VBA Outside Excel

Building a filter in Word VBA to trap inappropriate words and warn the user before printing.

November 2020

Learning Tree course D126 PowerQuery and Excel

How to use various features of Excel’s PowerQuery Extract, Transform and Load tool to load in four tables from different sources and merge them together. (Video)

March 2018

Learning Tree course 1256 Tableau; Birmingham, UK

Information and a form to apply for Learning Tree’s ‘Proctored Exam’.

Return here for a blog on Tableau LOD (Level Of Detail) expressions – coming soon!

July 2018

Learning Tree course 1256 Tableau; Herndon, VA, USA

How to convert dates in Tableau so that they use Fiscal Years rather than ordinary calendar years.

Other resources