Course
Skills
Viewing and Manipulating Data in Excel 2016
Learn the most efficient ways of viewing and manipulating data in Excel 2016.
What you'll learn
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.
Table of contents
Views, Templates, Links, and Clipboard
26mins
PivotTables
46mins
- 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
16mins
Charts
25mins
Data
54mins
- 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
44mins
- 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
