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
Category: Microsoft
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
How to Count / COUNTIF Items Across Multiple Worksheets in Excel
Microsoft Excel Tips and Tricks The method I demonstrate requires you to house all your data in Excel tables and[…]
Read more