by Nate Moore | Jul 30, 2012 | Basics
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...
by Nate Moore | Jul 25, 2012 | Basics
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...
by Nate Moore | Jul 23, 2012 | Basics
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...
by Nate Moore | Jul 18, 2012 | Basics
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...
by Nate Moore | Jul 16, 2012 | Basics
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...
by Nate Moore | Jul 11, 2012 | Basics
Today Excel Video 274 will use Go To Special to find a cell’s precedents and dependents. We talked about precedents and dependents in Excel Video 197. Precedents and dependents are like having a crystal ball with a rear view mirror attached. Precedents are like the...
