Monday, April 22, 2013

Chart This!

Thanks to +Mike Elgan for drawing attention to the Mother Jones Chart.

http://www.motherjones.com/mojo/2013/02/chart-generational-attitudes-sushi-gay-marriage
Generational Attitudes on Sushi and Gay Marriage Correlate Almost Perfectly
Some of the data is drawn from Public Policy Polling.

Now, that Public Policy Polling page: More Food Issues That Divide America contains simple stats that would thrill any Intro to Charting with Excel 101 class.

Wednesday, April 3, 2013

Excel's poorly documented Conditional Formatting

Nearly every class I lead, I say that one could write several chapters on conditional formatting (maybe +Contextures Inc. or +John Walkenbach or +Helen Bradley  might. Chapters that have detailed examples, screenshots and so on.

One thing that has been puzzling me is how to use the very pretty and eye catching effectiveness of conditional formatting with floating reference cells. - It's obvious how to conditionally colour a range against a fixed number (e.g. 50) or a fixed cell (e.g. $B$2) but it's more useful to compare say, 1990 figures against 2013 figures, row by row.

The user interface is not obvious for doing this and I just happened to see Susan Harkins's article on Techrepublic.

To further clarify the syntax, here's my screenshot:




Community Support Forums

Microsoft used to work with Usenet forums but some years ago, decided to go their own way. Here are the official Community peer-to-peer forums:

Excel IT Pro: http://social.technet.microsoft.com/Forums/en-us/excel/threads
Word IT Pro: http://social.technet.microsoft.com/Forums/en-us/word/threads
Outlook IT Pro: http://social.technet.microsoft.com/Forums/en-us/outlook/threads
Office 2013 IT Pro: http://social.technet.microsoft.com/Forums/en-us/officeitpro/threads
Office 2010 IT Pro: http://social.technet.microsoft.com/Forums/en-us/officeitproprevious/threads
Older than Office 2010 IT Pro: http://social.technet.microsoft.com/Forums/en-us/officeitprolegacy/threads

Unofficial Google Groups Forums (formerly Usenet)
Access: https://groups.google.com/forum/?fromgroups#!forum/comp.databases.ms-access
Access: https://groups.google.com/forum/?fromgroups#!forum/microsoft.public.access
Excel: https://groups.google.com/forum/?fromgroups#!forum/microsoft.public.excel