ICAEW.com works better with JavaScript enabled.

Unlock the Power of Organisational Data with Data Types: Practical Techniques for Modern Excel

Author: Excel Community

Published: 18 Nov 2026

Learn practical ways to use Excel Data Types to create clearer, more reliable worksheets and support more efficient, modern Excel workflows.

Excel Data Types can make worksheets easier to build, read and keep up to date.

In this webinar, Jakob Nielson, CEO and Founder of Make Digital Solutions ApS and Principal Designer in the Excel team at Microsoft, will explore practical techniques for turning familiar Excel worksheets into richer, more reliable models using Data Types. The webinar will demonstrate how structured and refreshable data can reduce manual maintenance, make formulas easier to read, and help teams work from shared organisational information directly in Excel.

You will leave with a clearer understanding of when to use built-in Data Types, such as Stocks, Currencies and Geography, how to create custom Data Types with Power Query and with the Make Digital Solutions Data Types add-in for Excel and how these techniques can support modern Excel workflows. 

First broadcast on 18 November 2026

Webinar resources

Relevant articles and webinar recordings

Please be aware that this webinar recording has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

CPD

This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role. 

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid
Open AddCPD icon