Select Page

Excel Video 236 Hide and Unhide

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...

Excel Video 235 Cell Styles

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...

Excel Video 234 Fee Schedule Example Part 3

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...

Excel Video 233 Fee Schedule Example Part 2

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...

Excel Video 232 Fee Schedule Example Part 1

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...