by Shane Broadberry | Aug 14, 2013 | Excel Formulas, Excel Tips
New in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and... by Declan McNally | Aug 9, 2013 | Blog, Macros, Uncategorized
The range of formula within Excel is great. Most of the day to day functionality that you need is there but if you find that you need to do a different calculation that is not built in then you can create what is called a User Defined Function (UDF). If you are going... by Declan McNally | Aug 6, 2013 | Blog, Macros
Introduction The whole area of macros in Excel can be an intimidating area to start with but some things can be very straightforward. I thought it would be useful to publish some useful tips on our blog to give you a taste of what is contained in our online courses... by Shane Broadberry | Jul 27, 2013 | Blog, Excel Charts
In this sample lesson – we look at how to change a chart’s layout. [jwplayer player=”1″ mediaid=”1187″]