There is nothing otherworldly about the Advanced Filter command in Excel: it is an advanced way to filter a range. But in the realm of online Excel forums, people speak of a mythical creature when discussing Advanced Filters: complex criteria. Normally, a

Or Criteria. To display the sales in the USA in Qtr 4 or in the UK in Qtr 1, execute the following steps.. 6. Enter the criteria shown below on the worksheet. 7. On the Data tab, in the Sort & Filter group, click Advanced, and adjust the Criteria rang

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.