Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will take a look at sparklines which is a type of chart used in financial applications.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016 Advanced.

In this and the next section we’re going to look at a couple of types of chart that are very often used in financial applications. Having said that, these two types of chart are very different indeed. And in fact the one we’re going to look at in this section, the Sparkline. Where it was introduced quite recently. It came in in Excel 2010. And Sparklines are unlike any of the other types of Excel Chart. Amongst the main differences are that Sparklines are not actually charts in the same way that things like Area Charts and Column Charts and so on are.

These are tiny little charts and each chart fits into a worksheet cell. So it doesn’t sort of hover over a sheet. It fits into a cell. Now in fitting into a cell a Sparkline can have other cell content in the cell as well. But the key thing about Sparklines is that they are simple, visual indicators.

Now we’re looking at a page here from Google Finance. Obviously this will be out of date by the time that you come to look at it but you’ve got some tiny little charts there. And very often in sources of financial information these tiny little charts are used to show the overall trend of something or perhaps to compare performance of one stock to another stock, that kind of thing.

So let’s take a look at how we can use Sparklines in Excel 2016.
So in order to demonstrate Sparklines I’m going to go back to the Team Sales 2015 data, the commission sheet we have here. And we’re going to draw Sparklines to show how each member of team A’s commission has progressed over the course of 2015. I’m going to put these Sparklines in column B. so let me just open up a spare column.

Let’s make that slightly wider. And then on the Insert tab to the right of the Charts area there’s actually a Sparklines group. There are three types of Sparklines, Lines, Columns and Win/Loss Sparklines. Let’s start with the Line.

Now that brings up a Create Sparklines dialog. And we basically have two selections to make. The first selection is for the data that we want to represent in the Sparklines. Now in this case that’s going to be the data from C4 to Q8. And where do we want the Sparklines to be placed? We want them to go in B4 to B8. Click on OK and there are our Sparklines.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.