The tutorial shows how to write an IF OR statement in Excel to check for various 'this OR that' conditions. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. Excel Formula Training Formulas are the key to getting things done in Excel. On Excel for Mac, although the array of sheet names is created correctly only the last sheet in the array is saved in the selected folder.
The macro is run by different users - some using Excel 2010 for Windows and some using Excel 2011 for Mac.