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.
Monthly Archives: September 2013
Slope Chart
How to show movement
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.
Excel Drop Down Selection and Free Form Entry
Flexible data entry
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.
Excel Templates – Why and How to Use Them
Save time and effort
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.
FORMULATEXT Function in Excel 2013
New function - great for training
The new FORMULATEXT function in Excel 2013 will make my Excel training job a little easier. It also has a formatting use.