In this video, staff author Jess Stratton shows users how to navigate through and insert charts in Excel. She'll also demonstrate how to use a sparkline.
- [Instructor] Just like the last video,…let's do a quick overview of charts in Excel.…The good news is that charts is one area…where Excel excels.…Let's work with this existing chart…and then I'll show you how easy it was…to create it in the first place.…The first thing I can do and the first thing…I'll need to do is resize it.…I'm going to hold the shift key down on my keyboard…and drag inward from the corner to make it smaller.…That's a little too small.…There we go.…I can also move it around the screen a little bit.…I'll drag it upwards, okay.…
If I click anywhere inside this chart,…I can see the exact row of data…that it's getting its values from.…Watch as I click on a different value.…And the rows itself in Excel will change.…This is a good way for me to narrow down…and find out where the data's coming from.…I can also move this chart to its own sheet.…I'm going to change to the Design ribbon tab…with the chart selected, I'll click Move Chart…on the right hand side of the screen…and I'm going to move it to a brand new sheet.…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.