Using charts in an Excel spreadsheet is a great way to show data in a graphical representation, which helps us in picking up trends variances. In Excel 2016, you will find many new chart options not found in Excel 2013. In this movie, you will know how to browse new charts and create the new Box and Whisker chart from existing data in a spreadsheet.
- [Voiceover] Using charts here in Excel 2016…can allow you to visualize data and pick up on trends.…While when migrating from Excel 2013 to 2016,…you're going to notice some new charts you can choose from.…We're going to take a look at some of them now.…We'll work with this file, Chart0302.…We'll start by creating a chart,…and that means selecting the data…we want to create the chart from.…So we'll start at Location over here in Column A, Row 5,…click and drag across to Column M,…where we see the December numbers all the way down…to cover Row 9.…
Next we'll go up to Insert and from here,…you'll notice something called Recommended Charts,…and this is going to show you charts…that would work well with this data,…but to see all of your charts,…just go over here to the little drop-down arrow…in the bottom right-hand corner…of the Charts group on the ribbon.…You'll still see your recommended charts listed…for you here, and you can see charts…that work well with this data,…including one of the new ones here,…which is called Funnel.…
- Recognize the changes to the user interface.
- Describe when you would use Touch mode.
- Explain how to quickly format shapes.
- Cite how to quickly choose a chart type.
- Name the pane that opens up when a picture is added to a slide and describe what it does.
- Explain how to import your contacts, email, calendars, and more.