Excel Links – Dashboards book delayed edition
Quick update about Dashboards for Excel book:
As you may know, my first print book – Dashboards for Excel (co-authored with Jordan Goldmeier) is supposed to release today – 15th September, 2015. But unfortunately, there is some delay with the printing process, so the book is not available yet. Our publisher, Apress, tells us that it can take two more weeks.
Thanks to all of you who pre-ordered this book. I am sorry for this unexpected delay. Just few more weeks and you will be reading it. 🙂
Time for another round of Excel links
Debra at Contextures explains how to sum numbers in Excel, not just in one way, but in 7 seven different ways. Watch the video to learn more. While at it, also listen to the AweSUM podcast, which is coincidentally my 7th podcast episode.
Chris Webb tells us about the new branding changes in Excel 2016. While we all admire Microsoft for making Excel and constantly improving it, sometimes their enthusiasm to revamp things can be annoying. How else can you explain the decision to rename Power Query as “Get & Transform Data”? Anyhow, read Chirs’s page to learn more about what several things in earlier versions of Excel are called in Excel 2016
Ever wanted to search a folder full of text files (customer notes, invoices etc.) for a particular piece of text? Dick shares a nifty piece of VBA code to do just that. Read the comments on the page too for extra code ideas.
Do you know that you can use mouse to change chart data source? Check out Doug’s illustrative tutorial to learn how to edit chart data using mouse alone.
Have you ever looked at sporting league tables and wondered if they can be improved? Kaiser did and he shares a few alternatives. One of them is a variation of win-loss chart.
So that is all for now. Enjoy the links and come back for more tomorrow 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« CP044: My first dashboard was a failure!!!||Show forecast values in a different color with this simple trick [charting] »|