Excel Tips
May 18, 2017
In today's Dueling Excel, Mike and Bill attempt to deal with Bond Dates. Say that you buy a six-month bond in the middle of the month. You need to calculate a full month's interest for months 2, 3, 4, 5, 6 but only half a month in month 1 and month 7.
May 11, 2017
How to debug an Excel VBA macro that is not working. There are amazing tools in Excel VBA that let you see the current value stored in variables as you step through code one line at a time. If you have a macro that is not working,
Workbook Opens on Missing Monitor »
May 10, 2017
An Excel workbook opens, but you can't see it! The taskbar says the workbook is open, but it is not on the screen. This recently happened to me when I opened a workbook that I last opened three years ago when I had a second monitor.
May 9, 2017
Excel VBA Macro to sort data. I don't like how the macro recorder creates extra code for sorting. Sorting in Excel VBA should be simple. One line of code, with the column to sort, which way (ascending or descending) and is there a header.
May 7, 2017
Today's trick from Lisa in Indianapolis is a faster way to filter a chart
May 5, 2017
Can Excel VLOOKUP return all results and join them with a comma in between?
May 4, 2017
A faster way to build an Excel 3D formula, also known as a spearing formula. I usually type =SUM(Jan:Dec!H10), but you can do this using the mouse.
May 3, 2017
The asterisk and question mark can be used as a wildcard in the Find dialog. But what if you actually want to find something that says 2*3 and not 2something3? There is a tricky way to tell Excel that you are really searching for an asterisk or a question mark.