XLOOKUP

Impressive Chart with Chart Title Drop List

Download the eBook   Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the ...

Dependent Drop List – No Preparation Table

Creating dependent Drop List without Any Preparation Table What is a dependent drop List? It’s a drop List where the items change based upon your selection from another drop List. In our example we ha...

Excel Dice Rolling Game

Roll the Dice… Using Functions and Macro Dice rollers are needed for lots of games … If you want to have one always at hand then nothing can match the Excel dice roller which allows you to...

XLOOKUP vs INDEX & MATCH for a Dynamic Chart

Xlookup to create a Dynamic Chart First time ever… Chart Title drop List In this tutorial I show you how to use the new XLOOKUP function to create a dynamic chart in Excel that switches data depending...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.