I used to see the double dash (--) in Excel spreadsheets and wonder what it did. It's an essential shortcut to force Excel to treat TRUE and FALSE as the numbers 1 and 0, meaning you can easily sum or ...

Learn Dynamic Arrays with the Hash Operator in Excel In Excel, the hash (#) sign references dynamic arrays, which automatically adjust as data is added or removed. Dynamic arrays let formulas return ...

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos. Editor’s Note: This article was originally published in July 2010 and the ...

Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.