Data Filters - QuadExcel.com

Excel Tip: How to do Calculations on a Filtered List?

Auto filter is a wonderful thing isn’t it?

Real Excel Power Users Know These 11 Tricks

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical formula and macro tricks. You, obviously, are one of the latter—or are you? Check our list of 11 essential Excel skills to prove it—or discreetly pick […]

The 10 most useful Excel keyboard shortcuts

The 10 most useful Excel keyboard shortcuts Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These 10 shortcuts will expedite the Excel tasks you perform every day. It’s great to know the resources are out there. But on a practical level, mastering 10 genuinely useful shortcuts will get you a […]

Filter/Identify Unique Values or Remove Duplicate Values

Filter/Identify Unique Values or Remove Duplicate Values In Microsoft Office Excel 2007, you have several ways to Filter for Unique Values or Remove Duplicate Values, 3 most commonly used options are listed below: 1 > To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. 2 […]