Calculating YTD percentages in Excel isn’t always straightforward, but in some cases you can use Excel’s most flexible function to achieve the result you need.
This post is attempting to replicate a slope chart.
I took a standard Line chart as seen in the top of this image. And then used the Design Tab option Switch Row/Column to create the slope chart at the bottom of the image.
When creating a drop down selection you usually want to restrict the user to certain entries. There are cases however when you want to allow the user to choose an option or allow them to type in their own entry.
Templates allow you to create blank sheets and blank workbooks that have customised formats as well as customised Page Setup settings, including headers and footers.
The new FORMULATEXT function in Excel 2013 will make my Excel training job a little easier. It also has a formatting use.