Video description
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.Table of contents
- Creating Summary Worksheets in Excel 2016 00:02:28
- Creating a One-Variable Data Table in Excel 2016 00:02:36
- Creating a Two-Variable Data Table in Excel 2016 00:02:42
- Goal Seeking with Excel 2016 00:02:20
- Setting Up Scenarios in Excel 2016 00:02:03
- Creating a Pivot Table with the Quick Analysis Tool in Excel 2016 00:01:37
- Using the Excel 2016 Recommended Pivot Tables Feature 00:01:18
- Manually Creating Pivot Tables in Excel 2016 00:02:05
- Formatting Pivot Tables in Excel 2016 00:01:35
- Filtering Pivot Table Data in Excel 2016 00:02:37
- Modifying Pivot Tables in Excel 2016 00:02:15
- Creating Pivot Charts in Excel 2016 00:01:31
- Using the Ribbon to Create a Chart in Excel 2016 00:01:54
- Creating Charts with the Quick Analysis Tool in Excel 2016 00:01:12
- Moving and Resizing Embedded Charts in Excel 2016 00:01:41
- Customizing Chart Elements in Excel 2016 00:01:49
- Editing the Chart Titles in Excel 2016 00:01:45
- Creating Sparkline Graphs in Excel 2016 00:01:25
- Adding Explanatory Text to a Chart in Excel 2016 00:02:11
- Inserting Images in a Chart in Excel 2016 00:01:19
Product information
- Title: Excel 2016 For Dummies Depicting Data Course
- Author(s):
- Release date: August 2016
- Publisher(s): For Dummies
- ISBN: None
You might also like
video
Excel 2016 For Dummies Enhancing & Sharing Data Course
Does enhancing and sharing data with Excel 2016 interest you? In just over a half an …
video
Using Microsoft Excel 2010
Using Microsoft Excel 2010brings you over 45 media elements detailing everything from getting familiar with the …
video
Do You Know These Pivot Table Hacks in Excel
This lesson covers data analysis and visualisation and confronts the challenge of deciphering a confusing sales …
video
Microsoft Excel 2013 Data Analysis Essentials
Master data analysis with Excel 2013 on your terms with this one-of-a-kind video training course. Excel …