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...
Write NOTES Inside a Function in Excel – Simple steps
One of the most common questions in my youtube channel is “How to Write NOTES inside a Function in Excel” Sometimes I build complex functions with multiple levels of nesting. To make it ea...