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
Tag: excel
30 *Advanced* Excel Tips & Tricks to make you awesome
Microsoft Excel Tips and Tricks Time to celebrate the beauty and versatility of Excel with 30 of my favourite Excel[…]
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
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