Excel 2024: Create Your Own Data Types

July 24, 2024 - by Bill Jelen

Data types sound great, but wouldn't you like to have your own company data as a data type? Imagine if you had your company product list in a data type. You could store the SKU in a column and then extract item information using XLOOKUP or dot formulas such as =A2.Country.

There have been three solutions from Microsoft that allow you to do this. Power Query was first. Then Power BI. Then a Javascript API. I've tried them all. I want these to work just like real data types do. Here is my wish list and how PQ (Power Query), PBI (Power BI), and API (JavaScript API).

More Reading

Excel 2024: Get Historical Stock History from STOCKHISTORY »

July 23, 2024 - by Bill Jelen

In June 2020, Microsoft 365 added the new STOCKHISTORY function. It will pull historical stock data after the market has closed. The syntax is as follows:

Excel 2024: Geography, Exchange Rate & Stock Data Types in Excel »

July 22, 2024 - by Bill Jelen

In the past, Excel did not really handle data types. Yes, you could format some cells as Date or Text, but the new data types provide a whole new entry point for new data types now and in the future.

Excel 2024: Handle Plural Conditions with SUMIFS »

July 18, 2024 - by Bill Jelen

Did you notice the "S" that got added to the end of SUMIF starting in Excel 2007? While SUMIF and SUMIFS sound the same, the new SUMIFS can run circles around its elder sibling.

Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.

Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.

MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.

see more products »

Excel 2024: Create Your Own Data Types

More Reading

Featured Products