3D Cross Tab Search using XLOOKUP

Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to create 3D Cross Tab Search using XLOOKUP function. Let’s get started   Video   Sample Data In the screenshot below, we’ve got a sales data that contains Total by Account Manager and Month. XLOOKUP Formula Our goal is to group all the […]

Continue reading

Dynamic Report using SUMIFS Across Workbooks and Sparklines

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to create a Dynamic Report using SUMIFS Across Workbooks and Sparklines. Let’s get started Video Sample Dataset In the screenshots below, we have a sample dataset that is officially formatted an an Excel Table And below, we have the Sales Report worksheet where we want to write […]

Continue reading