Building Your Own Data Types: Practical Techniques for Modern Excel
Details
SESSION DETAILS
Data types are particularly useful to organize and keep handy and updated “lookup” data. This becomes extremely powerful when applied to your own data!
In the past, we had to use VLOOKUP to link between workbooks. This method is not efficient, is prone to errors in many ways, and is completely outdated.
This session introduces how Data Types work in Excel and how they can make worksheets easier to build, read, and keep current. We begin with an overview of the built-in Data Types: Stocks, Currencies, and Geography, and how they add structured and easily refreshable information directly to the grid. The session then shows how to create custom Data Types using Power Query.
You will also see a demonstration of Data Types by Make Digital Solutions, an add-in for Excel designed and built by Jakob and available in the Microsoft Marketplace, which allows you to define and use Data Types based on your own data and share those easily with your team and organization.
Throughout the session, examples will show how Data Types behave in formulas, lookups, dynamic arrays, and reports. The session ends with an invitation to share real use cases to help guide future improvements.
ABOUT THE SPEAKER
Jakob is passionate about helping people become more productive and achieve better results with spreadsheets. He is the founder and CEO of Make Digital Solutions ApS and a Principal Designer in the Excel team at Microsoft.
Find more about Jakob Nielsen's work and connect with them:
LinkedIn: https://www.linkedin.com/in/jakobnielsen/
https://www.linkedin.com/company/makedigitalsolutions
Website: https://www.makedigitalsolutions.dk/
AGENDA (Eastern Time)
5:30 PM - 5:45 PM - Introduction by Celia Alves
5:45 PM - 6:45 PM - Building Your Own Data Types: Practical Techniques for Modern Excel by Jakob Nielsen
6:45 PM - 7:00 PM - Q&A + Closing by Celia Alves
REGISTRATION
This session will be hosted on Microsoft Teams and recorded to share with others who could not attend live. You must register for the event to access the Teams Meeting link, which will become visible after you RSVP Yes.
JOINING THE EVENT
The link will be visible only if you RSVP beforehand.
During the speaker's presentation, we ask that attendees ensure they are on MUTE to avoid background noise and distractions.
Attendees can type questions and comments into the chat, which will be monitored by the event hosts.
At the end, there will be time for Q&A, where attendees can unmute their mic and even share their video to ask questions.
**NOTE: As mentioned, this event will be recorded and shared on YouTube and other social media platforms; therefore, attendee information may be visible in the recording.
We are looking forward to meeting you there!
A SPECIAL THANK YOU note to our lead sponsor: Sheetcast
