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
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 2nd Edition
Through a series of recent breakthroughs, deep learning has boosted the entire field of machine learning. …
book
Apache Superset Quick Start Guide
Integrate open source data analytics and build business intelligence on SQL databases with Apache Superset. The …
video
Understanding Regular Expressions
The regular expression (regex) has been around for over 60 years and it's still poorly understood—and …
video
Kubernetes for the Absolute Beginners - Hands-On
Learn how to deploy Kubernetes applications effectively and kick-start your DevOps career with this interactive video …
