Archive Monthly Archives: December 2017

Nested IFs and Russian Dolls

Excel Online TrainingWhen 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

Continue reading

Combining LEFT, SEARCH and VLOOKUP

Excel Online TrainingTo 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

Continue reading