Excel Tips


Sum Data Alt-Entered »

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.


Find Any Digits »

October 20, 2017

Excel - how to keep only the digits from a cell, not the letters.


Replace Formatting »

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.


PDF to Excel »

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.


Bullets in Excel »

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.


Beware the AutoSave »

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.