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
- Why Power Query can change your life
- Power Query tips and tricks live
- Power Query: creating custom functions
- Power Query: getting started with web queries
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.
- Unlock the Power of Organisational Data with Data Types: Practical Techniques for Modern Excel
- What's new in business tech & AI in the year
- AI and Excel: Clean, Create, Code & Customise
- Excel Lunch and Learn series: Fundamentals of 3-Way Financial Modelling
- What senior finance leaders need to know about Excel