Infographic: Power BI – Unpivot Columns

Nested IFs and Russian Dolls

Excel Online Training When they hear the term “nested IFs”, a lot of people will visualize a structure whereby you have one parent IF statement with several IF statements nested inside it; and this

INFOGRAPHIC: Nesting VLOOKUP Functions

Combining LEFT, SEARCH and VLOOKUP

Excel Online Training To complete this tutorial, you will need to download and UnZip the following file from GoogleDrive; it contains two versions of the workbook used in the tutorial: the start version