Select Page

Excel Video 279 Excel and Word

If you’re wondering how to decide whether to create something in Excel or in Word, I have some ideas and suggestions in Excel Video 279. I usually decide whether to use Excel or Word based on whether the bulk of my work is numbers (use Excel) or words (use Word). On a...

Excel Video 278 Finding Merged Cells

Excel Video 278 has a real-world application from a client I visited in Dallas two weeks ago. They had a big spreadsheet that wouldn’t sort because of a merged cell. The problem was how to find a merged cell in a big spreadsheet. After doing all of these Go To Special...

Excel Video 277 Filling Blank Cells with Data

Excel Video 277 has another quick Go To Special shortcut to fill blank cells with data. If you download PM data or EHR data from your system, or if you download data from an outside source, this video may be very helpful for you. Sometimes data downloaded into Excel...

Excel Video 276 Finding and Deleting Blank Rows

If you’re getting extra blank rows when you download data from your software, you’re five clicks away from a solution in Excel Video 276. You’re getting used to quick shortcuts using Go To Special, so you won’t be surprised that we can do this shortcut in just five...

Excel Video 275 Finding Row Differences

I used to find differences between data in two columns the hard way until I found the trick I’ll show you in Excel Video 275. If I had a list of data in two columns and wanted to find the data that’s different in column A than column B, I used to write a formula using...