Excel dashboards and reports

Un très bon livre qui permet de tirer toute la quintessence Microsoft Excel dans la construction des tableaux de bord. Le livre est prévu pour la version 2013 d'Excel, mais on peut adapter ce qui est dit pour la version 2016 (et dans une moindre mesure pour la version 2010).

I am an Excel intermediate user of many years and want to brush up on my skills re: reporting for work. This is a very readable book and explains why something works/or not to aid understanding. Still only half way through but feel the benefit. Then, when you are inclined you can practise it as there are sample files available. To access these files, my experience is if the link doesn't work first time, try later and take care that you don't mistype it as I did. Highly recommend this book which is printed in a style which makes it a true working manual to annotate as you go along.

Good source of information

I purchased this for my Quality Improvement Department. We compile a great deal of patient-centered data; in fact, data for 23,000 patients. We are well versed in Excel, but this book enhanced our capabilities tremendously! We're now able to track and trend our data so much more effectively. The only down side is that other departments are coming to us and wanting us to do the same for their data! Worth every penny. The instructions are simple enough to follow and anyone with a little more than beginner's knowledge can build on their knowledge base quite quickly and produce some very meaningful reports for their business or department.

I'm going to review this now and hopefully remember to come back in another month or so after I've read the entire thing and look at some of the problems. I'm about 100 pages in right now and am giving it a 4 star review. It's a very nice book, well written, follows Tufte's paradigm of less is more. Almost looks like a copy of what I'd imagine Dashboarding for Dummies in Excel would look. 100 pages in, I'd say that this book is probably more for a beginner to a novice with some Excel experience. With that said, it's packed with many awesome charting examples that would make great references for anyone not that familiar with Excel or Dashboarding. You can use the examples to quickly create nice charts and graphs. I should state that I have a BBA and a CIS major, took Office and Advanced Excel in Business College, graduated 10 years ago. I haven't used Excel on a regular basis and never considered myself an expert in charting. I am a data programmer, work with databases and support Enterprise software. I've read much material on dashboarding over the last month. I have a high profile dashboarding project that I've undertaken at work. This book has given me some good insight into dashboarding paradigms, some good examples of clean graphs/charts so far. It's also given me a good understanding of the data underneath the chart. How to get the data setup for dashboarding. Setting up areas in the spreadsheet that are dynamic table areas which rely on more raw data placed in the spreadsheet. Connecting the dynamic areas to a particular graph on the dashboard. Ultimately I will use a product that will initially have Excel as it's foundation but will migrate into a relationship database over the next couple years. After consuming the contents of this book, will make the best effort to return and give some overall feedback of the book. For the price, it makes a great reference book and I don't regret buying the book.