Pages

Tuesday, May 3, 2011

10 ways to format Excel data so that people can actually understand it

I love Excel. I really do.  I don't get to use it much on my current job, unfortunately.  I have taught Excel both in the university and in business, and I created some pretty powerful macros at previous jobs. 

I've listed the basic points below, but follow this link to read the details.



#1: Give your worksheet a good title

#2: Wake people up with color

#3: Let the format lead the eye

#4: Apply a theme

#5: Don’t cram your charts

#6: Diagrams are helpful

#7: Take advantage of conditional formatting

#8: When in doubt, spell it out

#9: Frame it

#10: Invite feedback

Monopoly Excel game
Oh yes, and while you are messing around with Excel, check out this site (
http://www.gamesexcel.com/games-excel-monopoly.html)  for a Monopoly game for Excel!

No comments:

Post a Comment