If you have tried to change the data source for a Pivot Table and received a message saying 'to change the data source first disconnect the filter controls' you may have struggled to understand what it is saying.
A common requirement in Excel is to identify positive and negative numbers. This is usually to apply a different calculation to it e.g. a positive (credit) bank balance earns say 5% but a negative bank balance (debit or overdraft) incurs an interest charge of 10%.
If you are familiar with resizing columns or rows to fit the text in Excel, but do the step to each individual row or column, this is a quick way to resize all columns to fit text in Excel at the same time.
...In earlier versions you could close the workbooks in such a way that you end up with a grey screen (Excel open but no open workbooks) and you could open a new workbook from there. Two ways to achieve the same things in Excel 2013 and up i.e. close the workbook but not Excel...