Have you always dreamed of getting into Stanford’s School of Engineering and Computer Sciences, but was too much of a loser to even try?
Well, here’s your chance! Apparently, in an experiment in distributed education, Stanford will be offering their “Introduction to Databases” course FREE to students worldwide.
» Read more: Getting into Stanford University
» Read more: How to Compress xlsx Files to the Smallest Possible Size
One of the best practices of dashboard building is to avoid overwhelming your customers with too much data at one time – especially in a chart, where they can lose sight of the primary message if focusing on inconsequential data. One of the common ways dashboard designers help focus the message of a chart is to limit the data labels to only the key points.
.
Once I have only two data labels, my eyes immediately take in the message of this chart (that we went from 11 to 53).
» Read more: Automatically Label First and Last Chart Points
The other day, I stopped into Whole Foods Market and I picked up some tasty pork ribs.
They were actually pretty good, so I looked at the label.
» Read more: Vegetarian Pork Ribs
While working on a dashboarding project here, I accidently developed a charting macro that will automatically set the series colors in a chart to match their source cell’s colors.
.
I’m not sure how useful this actually could be, but it’s charming enough to share with my 12 fans.
.
Let’s say I created this chart – and I want to apply specific coloring to each series without having to painstakingly change all the color options in each series.
» Read more: Automatically Set Chart Series Colors to Match Source Cell Colors
Well, the summer is over for many of us. I’m back to my regular blogging schedule (whatever that means).
.
For my first post back, I’d like to show you a trick I learned from charting guru, Jon Peltier.
.
Ever needed to switch the position of a chart series (color and all)?
In this example, I want to show the series in red first. I’ve already created my chart, so I just want an easy way to switch the positions of the columns.
» Read more: Quickly Change Chart Series Positions
It’s summer time – and we’re taking it easy with some Oldies but Goodies!
In this summertime series, we’re exploring some of the older Excel and Access tricks that have been around for years.
.
Today, I’ll show you an old trick that lets you enter data into many cells at once.
» Read more: Enter Data into Many Cells At Once
During the summer, blog readership will be down. So I’m saving my good Excel and Access tricks for later. Right now, I’m continuing a series called ‘Oldies but Goodies’. In this series, I’ll share some of the older Excel and Access tricks that have been around for years.
.
Today, we’ll take a look at an old AutoFilter functionality that allows you to filter for unique records.
» Read more: Filter for Unique Records in Excel
It’s summer time – and we’re taking it easy with some Oldies but Goodies.
In this summertime series, we’re exploring those old tips and tricks that are still solid gold today.
.
Today, we’ll cover the old Right-Mouse drag options. Specifically, how to Copy – Paste Special – Values with the mouse.
» Read more: Paste Special Values with the Mouse
