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.

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.

MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.

MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...

see more products »

Excel 2024: Create Your Own Data Types

More Reading

Featured Products