by Greg Harvey | Publisher: For Dummies | Release Date: August 2016 | ISBN: 9781119346401

Looking to excel with Excel 2016? Learn how to depict data with ease in under 45 minutes! Create variable data tables, set up scenarios, create, format, filter, and modify Pivot Tables. In addition, explore how to add one of three Sparkline graphs with the Quick Analysis tool.

1. Creating Summary Worksheets in Excel 2016 00:02:28
2. Creating a One-Variable Data Table in Excel 2016 00:02:36
3. Creating a Two-Variable Data Table in Excel 2016 00:02:42
4. Goal Seeking with Excel 2016 00:02:20
5. Setting Up Scenarios in Excel 2016 00:02:03
6. Creating a Pivot Table with the Quick Analysis Tool in Excel 2016 00:01:37
7. Using the Excel 2016 Recommended Pivot Tables Feature 00:01:18
8. Manually Creating Pivot Tables in Excel 2016 00:02:05
9. Formatting Pivot Tables in Excel 2016 00:01:35
10. Filtering Pivot Table Data in Excel 2016 00:02:37
11. Modifying Pivot Tables in Excel 2016 00:02:15
12. Creating Pivot Charts in Excel 2016 00:01:31
13. Using the Ribbon to Create a Chart in Excel 2016 00:01:54
14. Creating Charts with the Quick Analysis Tool in Excel 2016 00:01:12
15. Moving and Resizing Embedded Charts in Excel 2016 00:01:41
16. Customizing Chart Elements in Excel 2016 00:01:49
17. Editing the Chart Titles in Excel 2016 00:01:45
18. Creating Sparkline Graphs in Excel 2016 00:01:25
19. Adding Explanatory Text to a Chart in Excel 2016 00:02:11
20. Inserting Images in a Chart in Excel 2016 00:01:19