Excel SEARCH and Wildcards
Excel has recently added three regex functions to handle text patterns, but did you know the old SEARCH function can use wildcards?
(more…)Adding a Dotted Line for the Budget in Excel
When you are charting the whole year in a line chart you might want to show the actuals up to a point and then the budget from then on. The budget could also be a dotted line. Here’s a way to do that.
(more…)TRANSPOSE and TOROW Functions in Excel
When you have a vertical list that you need to make horizontal you can use the TRANSPOSE function to switch it. There is an alternative function that gives you extra options.
(more…)Shortcut to Delete a Word
This technique works best in Word, but you can also use it in Excel. There is a keyboard shortcut to delete the current word. The shortcut is Ctrl + Backspace. When creating a formula in Excel that shortcut has another use that I covered in the blog post below. Note: in Excel you may now need to use Ctrl + Shift + Backspace. Whichever works - it can be useful. https://a4accounting.com.au/keyboard-shortcut-to-return-to-the-formula/ When you are in a text box (or in…
Better MROUND Function for Excel
The MROUND function gives inconsistent results. Here is a replacement custom function that provides consistent results.
(more…)