Write Notes INSIDE Your Functions in Excel- 3 Amazing Bonus Tips скачать в хорошем качестве

Write Notes INSIDE Your Functions in Excel- 3 Amazing Bonus Tips

Sometimes I build complex functions with multiple levels of nesting. To make it easy to understand the concept I followed, I like to add some descriptive notes in the context of the function, for future reference, that remind me of what I did. I am not talking about adding comments to the cell, but rather regular text description, within the function itself. In this tutorial, I show you how to type any text inside a function, that does not change the result of the function. I also give you 3 Amazing Bonus Tips on how to do the same thing in PQ, or in Power BI or in VBA, so, Stay tuned until the end. Now let’s see how I do that in Excel. You can Download the Exercise File and read the Step By Step guide on my blogsite www.OfficeInstructor.com Jump to the Bonus Tips =================== Adding Note to Power Query at 07:50 Adding Comments To VBA 11:50 Adding Comments to Power BI 14:52 I referenced These Tutorials in my Video: ================================= Extracting Records using INDEX & Aggregate Functions    • Extract Records Based on a Condition   Single Cell Report using ARRAYTOTEXT, LET, BYROW and LAMBDA    • BYROW-ARRAYTOTEXT- FILTER Functions- An Ex...   Creating a MONTH Calendar For Any Date in Power Query    • Dynamic Month Calendar for Any Date - Exce...   Highlight Row and Column of Any Selected Cell    • Highlight Row and Column of the Selected C...