by Nate Moore | Feb 29, 2012 | Basics
Since Leap Day only appears once every four years, it’s a good time to discuss how to hide and unhide data in Excel Video 236. Hiding rows and columns is an easy way to clean up some of the sometimes messy calculations that go into creating a spreadsheet. You can hide...
by Nate Moore | Feb 27, 2012 | Basics
Would you like to make your spreadsheets consistently look great? Watch Excel Video 235. Today we’re talking about Cell Styles, a way to consistently format headings, input cells, good news, bad news, calculations, and more. Cell Styles are on the Home tab in the...
by Nate Moore | Feb 22, 2012 | Basics
Excel Video 234 includes a couple more tips as we analyze the sample fee schedule we’ve been working on. Watch for how the F2 key not only lets you edit the formula, but Excel also color codes the formula components so you can easily find the cells that influence the...
by Nate Moore | Feb 20, 2012 | Basics
Watch for more Excel tips as part of our fee schedule analysis example in Excel Video 233. We’ll use the division rules from Excel Video 231, format the results as a percentage, and then once we have our formulas ready, we’ll use the double-click trick to fill the...
by Nate Moore | Feb 15, 2012 | Basics
I’m taking a different approach to the next couple Excel Videos, starting with Excel Video 232. Instead of covering a specific Excel function or feature, I’m going to use several Excel features as part of sample fee schedule analysis. I hope this approach makes it...
