Introduced in Excel 2010, Sparklines create charts within a cell. It can help to show one figure in context with others and illustrate trends. In this example a blank column is created for the sparklines before selecting the adjacent data. In Excel 2013 the Quick Analysis feature has now brought Sparklines to the fore. Perfect […]
So many times people pick the wrong chart type for their data. There’s a time and a place for pies, and lines aren’t for everyone. Picking the right one takes a bit of thought. The Charts option in the Quick Analysis gallery, a new feature for Excel 2013, allows the user to quickly view and […]
If you’ve got a lot of data, it’s not always easy to spot trends and to easily analyse your figures. Conditional Formatting can instantly show you patterns in your data by highlighting cells that meet certain conditions. So for example you might want to flag up sales below a certain threshold in red, or bold occurrences of […]