Excel Combination Chart of Sales vs Target

If you need to chart some kinds of data to a goal like sales to a target, Excel makes this easy with the combo chart of a column chart along with a line chart (initially). The columns can be the sales and the line series will represent the target. Most times this is enough when you have a target that doesn't change much. However if there are change to the target having the line vary may not looks visually appealing. Another example in this videos that is also a combo chart is actually using the combination of two column charts but have them on different y axis.

Convert Numbers to Words in Excel

Convert numbers to words seems lot a often sought out request for Excel. One day it may be a function or even command that can be entered or clicked on the ribbon. However it's not, but there is a workaround solution that Microsoft has provided in the form of VBA. They actually posted a knowledge article (along with the code) on a function call SPELLNUMBER. Just do a web search for this text to find the Microsoft page to get the code and instructions on how to apply it. One caveat is that there will be some errors to troubleshoot through, but it wasn't so bad.

Risk Assessment Chart in Excel

In Excel, creating a risk assessment chart (aka impact / probability chart) is fairly easy. All you need is the risk assessment matrix (with a not so large scale) and about fifteen minutes of time. Once finished you can put this into your favorite presentation software (PowerPoint?) and even make this into a template for the future.