David Croushore

A Man in Progress

The MS Excel Blitz Continues!

Today I picked up a lot of mini-Excel-skills, mostly concerning formatting.

For example, if you do a bunch of formatting in one place and then want to do it somewhere else, F4 does it for you (whoa! I know right?).  Similarly, while I fell in love with the format painter last year, I just learned that you can double-click it and apply the format to more than one place.  That would have saved me about 90 hours over the last year (at least).

Probably the most useful trick I picked up today was learning how to use Excel’s auto-outline function to make it easier to navigate a workbook or display it in a useful, meaningful way. 

Oh, and one more fun little nugget: for those of you who (like me) are constantly frustrated by your printer’s inability to retain its ink, it turns out that printing in the “Century” font uses 20% less ink than printing in other fonts.  Now you know (that’s half the battle).

For those who haven’t figured it out yet, I’m kind of on an Excel kick.  Still have quite a bit of Excel work to do, but I’m going to start peppering in some powerpoint and web development in the next few days. 

  1. 30daysatatime posted this
Comments
blog comments powered by Disqus