Excel 2016 Intermediate Tutorial

Dive into this comprehensive 2-hour 36-minute intermediate Excel 2016 tutorial to enhance your data organization and analysis skills. Learn advanced techniques such as flash fill, multi-level sorting and filtering, table formatting, and pivot table creation. Master the art of data visualization with various chart types, including sparklines and pivot charts. Explore data validation, cell protection, and file encryption for improved data integrity and security. Discover how to import data from the web, use MS Query, and implement conditional formatting. Perfect for current Excel users looking to expand their capabilities, this tutorial provides hands-on exercises and covers a wide range of topics to boost your productivity and efficiency in Excel 2016.

Start
Flash Fill
List Design & Single Level Sorting
Multi-Level Sorting
Custom Sorting
Filtering
Multi-Level Filtering
Search Filtering
Format as Table
Table Style Options
Remove Duplicates
Convert to Range
Subtotal
Multi-Level Subtotaling
Remove Subtotals
Quick Analysis Charts
Inserting Data Charts
Formatting Data Charts
Chart Templates
Sparklines
Printing Charts
Importing From Web
MS Query
Exporting Overview
Pivot Tables
Multiple-Field Pivot Tables
Drill Down Reports
Pivot Charts & Grouping Fields
Slicer Tool
Data Validation
Additional Data Validation
Cell & Sheet Protection
File Encryption
Conditional Formatting
Linking Data
Inserting Comments