Cool Excel Tricks

by Erin McCune on March 18, 2008

in Caught My Eye, Technology

(from Chandoo.org via Lifehacker)

Impress your colleagues – and your boss! – with these very cool Excel tricks:

1) Highlighting alternative rows / columns in tables

image

2) No-nonsense project plans / gantt charts

image

3) Extreme in-cell graphs

image

4) Highlight mistakes, errors, omissions, repetitions

image

5) Create intuitive dashboards

image

Detailed, easy to follow instructions and a downloadable spreadsheet with examples available at Chandoo.org:

Want to be an Excel Conditional Formatting Rock Star? Read this
Chandoo.org
March 13, 2008

One Response to “Cool Excel Tricks”

  1. Erin,
    those are good.
    Here is a resource tool that will make your Excel charts shine.
    http://chartchooser.juiceanalytics.com/

Leave a Reply

Previous post:

Next post:

Clicky Web Analytics