Welcome. Welcome Nicky. Hi for Jan. Sean has now gained great confidence in his Excel skills. He's great at manipulating his spreadsheet, finding the information that he needs, formatting in spreadsheet and printing. So, he started to experiment with his great confidence. He's known as a chart button, is a bit scared to click it, but he realizes that charts and graphs would be a great way of summarizing his data to present to his manager, other departments and even clients. So Nicky, where can Sean get started? One of the essential charts in Excel. There are so many to choose from these days. It can be a little overwhelming, but they are three basic charts that will meet most needs. The first one is called the column chart. It's a bit of a catch all, you can't go far wrong with column chart. It will present most data quite nicely. So, if you're not sure, go over the column chart. Okay. Sometimes however, we want to kind of show a breakdown. So, it might be the split of sales over the different departments. Now, for that your pie chart is excellent and it's graphically very appealing. True. One limitation however, you can only show one series of data on a pie chart. So, you can't show everything in a pie. The other chart that you see used quite a lot is the line chart, that is really excellent for tracking trends. So, if you want to show change over time, could be share price or it could be your sales, the line chart is fantastic. Thanks Nicky. Excel is great that is got a button to create charts. But let's say I've got a thousand students, they all highlight the same data, they all click the same button and all the charts look the same. They haven't really utilized Excel's functionalities. How can we start to manipulate our charts and customize them? Brilliant. Well, what we're going to start by doing is just creating a chart. Then it's quite important that they can resize and move the chart confidently, so we'll start there. But then we'll start looking at the tools for changing our charts and there's some great styles you can choose from so you get nice color variations but even some quick buttons for changing the settings and making them look really good. So, we'll start by looking at how we will change our design as a whole and then we will drill down and look at how we can change some of the specific components of the chart. The components could be like the ledger. We might want to modify the ledger. A great component to modify would be the scale. Sometimes we know our data goes in sets of 10. Excel sometimes however does a calculation and things, "Yeah. I think we'll do it in sets of seven." We need to manually modify that ledger. Yeah, absolutely. So, what else can be modified in our charts? So, the other thing, the last thing that I'm going to look at is working with colors. I know that sounds very obvious, but actually it can be very time consuming if you're sitting there manually changing 30 different bars in your charts and more problematic, again you want to keep with your corporate theme and you want to keep a nice consistent look. So, we're going to go back to looking at our styles and our themes that we introduced in the formatting section and we'll see how by just clicking on your corporate theme, you can recolor all the charts in your workbook in one go. Great. Something I've noticed though is in the latest versions of Excel, they've made a few changes to how the options appear when you want to customize your charts. Yes. Here, we should just explain to the learners with the latest versions they have changed the chart or slightly but don't be alarmed, you have all the same functionality, it's just being moved around a little bit. So, you may notice when we come up to the design of a chart design tab on the ribbon, that actually swapped it around in later versions. If you don't see it where we're pointing just look on the other side, it's probably there. The other thing you'll notice that it's different in older versions we had three ribbon tabs. The second one was called layout. That has now been moved to a little pull out to the right of the chart. So, if when you're trying to do your chance you don't see the pull out we're working with, don't panic, all those tools are up on the layout tab. Thank you Nicky. Sure. So, your key takeaways for this week are, how to create a chart, how to style a chart and how to customize the chart. We've got some great practice videos coming up that'll work you through the mechanics of this. Download the Excel workbooks we have for you. They'll just have numbers in it and text, and you'll begin to transform these charts as you work alongside these practice videos. Then take a break, relax, refresh, comeback get creative with those charts and you'll begin to impress yourselves and you'd want to impress your colleagues at work as well. So, now it's over to you.
