Microsoft Excel – Advanced Filtering techniques JUNE-2019

Uncategorized June 22nd, 2019

The JUNE 2019 IIL blog features several techniques for advanced filtering Microsoft Excel spreadsheets. As an example, some special calculations between multiple cells can be defined in filtering, so that a special new column does not need to be added, in order to find targeted results

Advanced Filtering in Excel

In this blog I’ll continue the discussion from my last blog on basic filtering.  You can use advanced filtering for any of the features you use basic filtering. The advanced feature enables you to do things that can’t be done with basic filtering. For example, how would you filter this data for items in which the Sales times the Units is over 30,000,000?

© 2021 Computer Safety & News.
WordPress Theme & Icons by N.Design Studio. Provided by WPMU DEV -The WordPress Experts   Hosted by Microsoft MVPs
Entries RSS Comments RSS Log in