Excel 2021 Intermediate Tutorial - Part 2 of 3

Dive into the second part of a comprehensive intermediate Excel 2021 tutorial series. Master essential features like formatting lists as tables, utilizing Flash Fill for quick data entry, and implementing custom sorting. Learn to create subtotals, use the QA Tool for data accuracy, and design impactful data charts and sparklines. Explore the power of Pivot Tables, from introduction to advanced options. Enhance data integrity with validation techniques, apply conditional formatting for visual analysis, and effectively use comments and notes. Discover how to link data across worksheets and understand privacy and protection measures in Excel. Access accompanying exercise files to practice along and reinforce your learning throughout this 1-hour 20-minute video tutorial.

Start
Introduction
Formatting Lists as Tables
Flash Fill
Custom Sorting
Subtotals
QA Tool
Data Charts
Sparklines
Introduction to Pivot Tables
Advanced Pivot Tables Options
Data Validation
Conditional Formats
Comments and Notes
Linking Data
Privacy and Protection
Conclusion