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
Author: Noel
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
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