How to create recursive functions in Excel

How to create recursive functions in Excel

Recursive function is a term for describing behavior of a function that calls itself from within its own code. This is necessary for solving a problem where the solution relies on the results from multiple instances of the same problem. In this guide, we’re...
How to unpivot data in Excel with Power Query

How to unpivot data in Excel with Power Query

How to unpivot data in Excel with Power Query Power Query is a data management tool that helps change the layout or other properties of data easily. In this guide, we’re going to show you how to unpivot data in Excel with Power Query. Download Workbook...
How to do an image lookup in Excel

How to do an image lookup in Excel

Excel’s lookup functions recently welcomed the addition of XLOOKUP and XMATCH. However, neither these new functions or the existing ones don’t support image lookup. In this guide, we’re going to show you how to make image lookup in Excel. Download Workbook...