Head First Excel

Appendix A. Leftovers: The Top Ten Things (we didn’t cover)

You’ve come a long way.

But Excel is a complicated program, and there’s so much left to learn. In this appendix, we’ll go over 10 items that there wasn’t enough room to cover in this book, but should be high on your list of topics to learn about next.

#1: Data analysis

It’s one thing to be able to rock and roll inside Excel, but it’s another thing altogether to be a good data analyst. Data analysis is a broad (and hot) field that encompasses knowledge not only of Excel and other software but of higher level topics like statistics and psychology.

Crack data analysts are omnivorous and voracious thinkers when it comes to data, and if you’re interested in boning up on data analysis, might we suggest...

#2: The format painter

The format painter is one of those tools inside Excel that you’ll use all the time. The format painter provides a super-quick way to copy formatting attributes from one cell to another. Just select the cell that has the formatting you want to copy to another cell, click the Format Painter button, and then click on the cell or range where you want to apply that formatting.

If you want to apply the formatting you’ve ...