Excel Tips
October 23, 2017
This is the firefighter budget problem. The people in a firehouse have been doing their budgets wrong in Excel. An amazing Power Query transformation provides the solution.
October 20, 2017
Excel - how to keep only the digits from a cell, not the letters.
October 20, 2017
In Excel, you can mix formatting in a cell. Some words can be bold and some can be red. But if you do a Find & Replace, the formatting will be lost. Here is one way to deal with that.
October 19, 2017
How to get data from a PDF file in to Excel. The dirty secret? Word.
Insert 2 Rows After Each Customer »
October 19, 2017
Janet's question: She has a large data set. Every time the customer name changes, she wants to insert *two* rows.
October 18, 2017
Bullets in Word are easy. Why aren't they easy in Excel? Today, we look at several ways to add bullets in Excel.
Multiple People Editing Workbook »
October 18, 2017
Excel - can multiple people edit the same workbook? Yes - the new feature is called coauthoring. Learn all about it here.
Upper Case Excel Data in Word »
October 17, 2017
How to change case of Excel data. Whether you have to convert to upper case, lower case, sentence case or proper case, this article will show you how to convert the case.
October 17, 2017
In Excel 2017, they introduced a new co-authoring feature. Here is the horrible downside you need to know whether you ever plan to co-author or not. If you see AutoSave lit up in the top left corner of your spreadsheet, you are in for trouble.