OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
Microsoft Excel Tips and Tricks Learn about aggregate calculations with conditions and criteria. Learn about an AND Logical Test, and[…]
Read more
Category: Excel
Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
Microsoft Excel Tips and Tricks Learn how to create a Day of Week Totals Sales and Average Sales reports using[…]
Read more
Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
Microsoft Excel Tips and Tricks Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741[…]
Read more
New Look for Excel Ribbon and QAT – 2414
Microsoft Excel Tips and Tricks Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The[…]
Read more
Create an Excel Drop-Down List Including an IF STATEMENT
Microsoft Excel Tips and Tricks I demonstrate how to create a drop-down list in Excel that includes an IF Statement.[…]
Read more