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
Tag: excel
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
Conditionally Format Based on Adjacent or Previous value
Microsoft Excel Tips and Tricks I demonstrate how to conditionally format cells based on an adjacent or previous value. This[…]
Read more