New Excel 2016 Chart Types


Microsoft continues to innovate one of my favorite tools, Excel. I love charts and they just added six new types!

Treemap provides a hierarchical view of the data

Waterfall shows a running total, both positive and negative

Pareto is used to highlight your largest factor in a data set

Histogram is used to show frequency data

Box and Whisker shows distribution of data and highlights outliers

Sunburst shows hierarchical data via rings

Which one is your new favorite chart?

~ GW

Microsoft Office and Office 365


This post is going to be a placeholder for all of the great articles, videos, tutorials, and Microsoft content related to Office 365 and the Office products. I am constantly amazed in the quality of the recent changes and products. In some cases it is almost impossible to keep up with all the changes.

Microsoft OneNote for beginners – PCWorld
Office 365 Training demo – Microsoft
Office 365 Tutorial – Microsoft
Unite your team with Groups in Outlook – Microsoft
Support for live code demo in OneNote – MSPowerUser
Office 365 Redefines Knowledge Management – Sharegate
What is Office 365 Groups? – Microsoft
What is Office Delve? – Microsoft
What is OneDrive for Business? – Microsoft
10 Microsoft Office 2016 features you’ll love – CIO

~ GW



I want this… I need this. I have been a fan of network aware thermostats and other home automation devices. Two big things have kept me from investing (based on their cost, yes, it is an investment) in one of these products: no support for Windows Mobile and the location of my thermostat.

Like many, I have an older house with a single air conditioner/heater. The thermostat is located in the living room, where it ensures that space is always just as I like it. Conversely, my upstairs rooms each have their own unique biome.

This device from Ecobee has remote sensors that will sample the temperature and frequency of use of these other rooms and automatically adjust to accommodate when we are all upstairs. Brilliant!

On top of that, which is pretty awesome, they provide an open platform that has allowed developers to innovate and create a third party app that is as good as the device itself. It is about time device manufacturers realized the talent that is available for free (to them, the app does cost a couple of bucks for us)!

Now it is time to perfect my pitch to my wife…


Credit to WindowsCentral, which is where I learned about this device. The link above is to Ecobee, but you can read the WindowsCentral article here.

I am a blogger again…

It has been a few years, but I have gotten the bug to give this another try. I am on the path to a new career in Enterprise Architecture while at the same time executing the role of CTO for the federal agency where I work. This mixture has introduced me to a variety of topics and products that I want to share.

Hopefully this will become useful for others who are interested in the same areas of interest I am, which will include:

  • DevOps
  • Enterprise Architecture
  • Windows 10
  • Windows 10 Mobile
  • Office 365
  • New technologies
  • Conferences

I look forward to building a catalog of content that will help others find resources and books that I am consuming.

~ GW