Viewing and Manipulating Data in Excel 2016
Learn the most efficient ways of viewing and manipulating data in Excel 2016.
Course info
Rating
Level
Intermediate
Updated
Jan 6, 2016
Duration
3h 33m
Table of contents
Views, Templates, Links, and Clipboard
Introduction
3m
Worksheet Views
4m
Custom Views
3m
Creating Templates
7m
Working with Hyperlinks
5m
Using the Clipboard Pane
3m
PivotTables
Understanding and Using PivotTables
6m
Create a Simple PivotTable
4m
Add Fields to a PivotTable
4m
Remove Fields from a PivotTable
2m
Use the Report Filter
3m
Format
4m
Adjust Numbers
3m
Create a Calculated Field
4m
Create a Calculated Item
4m
Enhancements
4m
Customizing PivotCharts
5m
Understanding the Slicer Tool
3m
Formatting the Slicer Tool
2m
Multi-select Feature
1m
Protection
Modifying Workbook Protection Settings
5m
Protecting Cells in a Workbook
4m
Protecting Workbook Structure
3m
Understanding Protected View
3m
Charts
Exploring Charts
4m
Create a Simple Chart
2m
Customizing Text
5m
Formatting Chart Components
7m
Creating Sparklines
2m
Modifying Sparklines
3m
Inserting Sparklines from Data Ranges
2m
Data
Working with Subtotals
4m
Showing Multiple Subtotals
3m
Automatic Outlining
4m
Custom Grouping
3m
Using Scenarios
5m
Using Goal Seek
3m
One-click Forecasting
3m
Get and Transform (Query)
4m
Flash Fill
3m
Text to Columns
5m
Data Validation
8m
One Input Data Tables
3m
Two Input Data Tables
3m
Consolidation
5m
Functions
Ink Equations
4m
Working with Absolute References
4m
Working with Named Cells
5m
Advanced Function Building 1 (step through it)
6m
Advanced Function Building 2 (jump into it)
3m
Advanced Function Building 3 (go for it!)
3m
Advanced Function Building 4 (nested arguments)
6m
Advanced Function Building 5 (nested functions)
6m
Advanced Function Building 6 (I can do any function!)
5m
Name a Selection
3m
Description
Course info
Rating
Level
Intermediate
Updated
Jan 6, 2016
Duration
3h 33m
Description
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.
About the author
About the author
Diane McSorley is a Microsoft Certified Trainer with expertise in teaching beginner to expert levels in multiple applications, Microsoft technical course, and CompTIA courses.
More from the author
More courses by Diane McSorley