Author
Released
7/25/2016- Selecting data for a chart
- Creating charts with keystrokes and ribbon icons
- Selecting the right chart type
- Adding titles, labels, and gridlines
- Choosing a chart layout
- Changing a chart's location
- Adding gridlines, data tables, and trendlines
- Formatting charts
- Creating column, bar, line, pie, and scatter charts
- Changing a chart's source data
- Creating Gantt and frequency charts
- Printing and sharing charts
- Converting a chart to a graphic
Skill Level Intermediate
Duration
Views
- [Voiceover] Hi I'm Dennis Taylor, and welcome to Excel for Mac 2016: Charts and Depth. Creating charts is one of Excel's most powerful yet easy to use features. In this course, we'll be looking at the concepts under line charts, and the tools to implement those concepts. I'll show you how to create standard and useful charts, and then how to fine tune those charts with a variety of techniques. You'll see how to add greater impact to your charts with pictures and shapes, and then examine the most effective use of titles, labels, legends, axis, and grid lines.
We'll look at analytical tools that will help you make sense of chart data, and show you how to create dynamic charts to reflect fast changing business environments, and we'll give you a ton of shortcuts and tips that will make your use of this popular tool more efficient and productive. So join me in Excel for Mac 2016: Charts and Depth.
Related Courses
-
Excel for Mac 2016: Advanced Formulas and Functions
with Dennis Taylor6h 54m Intermediate
-
Introduction
-
Welcome51s
-
-
1. Create Basic Charts Quickly
-
2. Excel Chart Concepts
-
Identify chart elements3m 13s
-
Select the right chart type7m 17s
-
Use chart terminology2m 39s
-
Use Charts Ribbon tab2m 57s
-
-
3. Adjust Chart Appearances with Chart Design Tab Choices
-
4. Control Chart Element Options
-
Modify axes6m 59s
-
Link titles to content2m 28s
-
Add and edit data labels6m 57s
-
Add a data table3m 29s
-
Add error bars4m 28s
-
Work with gridlines4m 6s
-
-
5. Use Format Tab Options and Other Visual Features
-
6. Use Specific Chart Types
-
Pie charts and doughnut charts10m 53s
-
7. Change a Chart's Data Source
-
8. Specialized Excel Charts
-
Create combination charts4m 35s
-
Create Gantt charts6m 44s
-
Create frequency charts5m 43s
-
-
9. Print and Share Charts
-
Print charts5m 4s
-
-
10. In-Cell Chart Alternatives
-
11. Chart Manipulation Tools
-
Convert a chart to a graphic4m 32s
-
Conclusion
-
Goodbye30s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome