Excel – Rich Data Types - the Key to Intelligent Spreadsheets
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded excel trainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Rich Data Types, first introduced into Excel in 2019, are a game-changer that takes Excel from being a tool that simply manipulates your data into a tool that really understands your data. Traditionally, a cell in an Excel worksheet has been limited to storing one of three data types - text, numbers, and dates. However, with the introduction of Rich Data Types, this is no longer the case. Converting a static value stored in a cell into a Rich Data Type opens up a whole new exciting world of possibilities. Imagine you have a cell that contains the name of a company or a city or a country. With a couple of mouse clicks the static text entry in that cell can be converted into an AI-powered Rich Data Type that exposes additional information such as market value and number of employees (company) or population, area, and even photographs (city/country). That additional information can be used in the formulas you write, charts you create, it can even be used to change how you sort and filter. Now apply the same principle to data inside your organization such as Products and Employees. Imagine, for example creating invoices or inventory lists replete with images from product and customer data without having to load it into Excel first. With Rich Data Types, a single cell value can have a live connected set of information you can quickly pull into your decision-making process, without needing to constantly go back to the original source to find more information.
- Understand what Rich Data Types are
- Understand how to use Rich Data Types and why they are useful
- Learn how to create your own Rich Data Types
- What are Rich Data Types
- Converting a static value into a Rich Data Type
- Property Cards
- Referencing Rich Data Type properties with formulas
- Sort and Filter Rich Data Types
- Creating Custom Rich Data Types
Course Level - Intermediate
Who Should Attend
You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
Why Should Attend
Rich Data Types is a game-changer that takes Excel from being a tool that simply manipulates your data into a tool that really understands your data. Data types allow you to bring the data you care about into the worksheet grid, in its most natural form and unleash the power of Excel to gain critical insights.