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.