2016
Pluralsight
Diane McSorley
3:34
English
Learn the most efficient ways of viewing and manipulating data in Excel 2016. You'll learn about PivotTables, protection settings, charts, working with data and functions.
Views, Templates, Links, and Clipboard
26m 7s
Introduction 3m 20s
Worksheet Views 3m 50s
Custom Views 2m 58s
Creating Templates 7m 14s
Working with Hyperlinks 5m 18s
Using the Clipboard Pane 3m 25s
PivotTables
46m 52s
Understanding and Using PivotTables 5m 30s
Create a Simple PivotTable 3m 44s
Add Fields to a PivotTable 3m 48s
Remove Fields from a PivotTable 1m 47s
Use the Report Filter 2m 49s
Format 3m 53s
Adjust Numbers 2m 34s
Create a Calculated Field 3m 42s
Create a Calculated Item 4m 19s
Enhancements 3m 47s
Customizing PivotCharts 4m 48s
Understanding the Slicer Tool 2m 48s
Formatting the Slicer Tool 1m 59s
Multi-select Feature 1m 19s
Protection
16m 2s
Modifying Workbook Protection Settings 5m 29s
Protecting Cells in a Workbook 4m 2s
Protecting Workbook Structure 3m 11s
Understanding Protected View 3m 18s
Charts
25m 58s
Exploring Charts 4m 28s
Create a Simple Chart 2m 21s
Customizing Text 5m 6s
Formatting Chart Components 7m 28s
Creating Sparklines 1m 55s
Modifying Sparklines 3m 1s
Inserting Sparklines from Data Ranges 1m 36s
Data
54m 33s
Working with Subtotals 4m 4s
Showing Multiple Subtotals 2m 55s
Automatic Outlining 3m 52s
Custom Grouping 3m 12s
Using Scenarios 5m 11s
Using Goal Seek 2m 33s
One-click Forecasting 2m 34s
Get and Transform (Query) 4m 24s
Flash Fill 2m 54s
Text to Columns 4m 39s
Data Validation 8m 14s
One Input Data Tables 2m 40s
Two Input Data Tables 2m 46s
Consolidation 4m 31s
Functions
44m 40s
Ink Equations 4m 7s
Working with Absolute References 4m 7s
Working with Named Cells 4m 42s
Advanced Function Building 1 (step through it) 5m 45s
Advanced Function Building 2 (jump into it) 2m 42s
Advanced Function Building 3 (go for it!) 2m 50s
Advanced Function Building 4 (nested arguments) 6m 10s
Advanced Function Building 5 (nested functions) 6m 7s
Advanced Function Building 6 (I can do any function!) 5m 13s
Name a Selection 2m 52s
pluralsight.com/courses/excel-2016-data
Download File Size:915.28 MB
|
