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
Author: Noel
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
Excel IF Range Contains Value | How to Perform an IF Statement on a Range
Microsoft Excel Tips and Tricks I demonstrate how to create an IF formula that performs a test across a range[…]
Read more