OfficeInstructor
Dynamic Report With Power Query and VLOOKUP – Approximate Match
When you want to create a dynamic report from multiple sources and you need an approximate match, If the VLOOKUP Cannot get the job done, Then Power Query will come for rescue. In this tutorial I crea...
Do Magic with Excel Drop Lists …Dynamic Dependent Diminishing
In this project I show you how wow your boss, colleagues and clients by creating Dynamic Dependent Diminishing drop lists. At the Basic Level, using drop lists in your worksheet makes entering data an...
