Workshop Topics

  • Organizing and structuring data
  • Entering data efficiently
  • Basic data analyses (averages, changes over time, graphing, etc.)
  • Conditional formatting


  • Microsoft Office Online’s demonstration of how to use conditional formatting – This video clearly shows the process.  Note: The link works better on Windows computers than those running Mac OS X.  If you have trouble loading the video from their site, you can download it and watch it locally as a wmv format video.  (So if you’re a Mac user and lack the plug-in to watch the video online, either watch the video on a PC or get a friend to download the file and watch it on your computer using a video player such as VLC.  A frustrating process, I know.)
  • Home and Learn – This site walks you through some of the basics of conditional formatting in a supportive, conversational style.
  • How-to Geek – There’s not a lot of useful information on this site, but if you’re a visual learner, you’ll find lots of screenshots that might remind you of what we covered in our workshop.

Further Learning

  • Feeling comfortable with conditional formatting?  Ready to learn more ways to use it?  This site has some terrific examples of how to take conditional formatting even further to mask certain data when printing, highlight certain items in a list, and more.  Some of the site’s suggestions are now unnecessary due to the new features in Excel 2007 (and newer), such as creating colored shapes (which Excel now does for you with the icon options).