Excel 2013: Insert Timeline for Grouping Dates
Quick & dirty update! AWW WOW! Excel 2013 allows the addition of a timeline into Pivot Charts! (not included with Excel for Mac) Let's say you have a lot of dates and want to see graphic summaries grouped by month or year. Before 2013, that called for a pivot...
Excel & the Clouds: Cirrus, Thunder & Mushroom
Getting Excel embedded in a web page, living in the almighty cloud is a challenge, and isn’t always a good idea. Let’s discuss!
Excel Dashboard: Good, Bad & Ugly
The image below is an Excel Dashboard section generated from 847 rows and 11 columns of data related to classroom and book sales. In the range D1:N5 we summarize Monthly Sales Totals by Sales Rep. So much easier to look at this instead of scrolling around in the...
Excel Dashboards for Simpler Data Entry & Analysis
Excel Dashboards are good visual summaries but there are 2 tangential benefits: they simplify data entry and ad hoc reporting.
Generate Data Using Excel: RAND & RANDBETWEEN
Here is a behind-the-scenes peek at how to generate data to make tutorials or test solutions for a client. We use: RAND, RANDBETWEEN & date formatting in this screencast to make 102 rows of bogus call center information.
Formula Triggers & Absurd Results?
QUESTION Rowka asked "how do I make this formula smaller?" =IF(AND(E11>=K7,E11<=N7,F11>=K7,F11<=N7,G11>=K7,G11<=N7),"PASS","FAIL") Translation of the Formula: If tests 1 thru 3 are within acceptable ranges, then say "PASS" otherwise, say "FAIL" Keep...
2013: Performance, Cheeky & Triage
Tomorrow is the first day of 2013. 10 February 2013 is the first day of the Chinese New Year, the Year of the Snake. Have you reflected in the victories and lessons of 2012, and what 2013 will bring? The Snake represents calm, prosperity and good luck. There's also...
4 Ways To Avoid Krampus & Crap Data in 2013
2013 is the year to face up to and handle the crap data hurt our businesses. Here are 4 steps to getting insight and peace. Step #1: Face It.
Excel Workshops: Formulas/Dashboards
21DEC12: Excel Workshop: It was great! On Wednesday 19DEC12 12 students met at Chicago's Holiday Club to learn about Excel formulas. We had a good time! The Holiday Club provides a great venue in their back room. Their waitress, Emma has been our assistant both times...
#5 of the Top 5 Excel Functions to Know: SUMIFS
And here we are at the 5th of the Top 5 Excel Functions to Know! SUMIFS is in the Top 5 because when you're working with numbers and need to do analysis or summaries, SUMIFS makes it so easy to see details that you need to see. We didn't always have this. SUMIFS was a...
#4 of the Top 5 Functions: IFERROR
#4 in the List of Top 5 Functions: IFERROR Q: What do an acrobat and Excel's IFERROR function have in common? A: An acrobat and an Excel user who employs IFERROR are both expressing: it's risky but I know what I'm doing and I do it with elegance IFERROR is in...
Client-Developer Relationship Part 2
We revisit the Client-Developer Relationship after a post by Chris Penn warns that experts have to be on guard against catering to other developers.