Master advanced Excel 2021 techniques in this comprehensive tutorial designed for users of all levels. Explore essential features like formatting lists as tables, utilizing Flash Fill, and implementing custom sorting. Learn to create subtotals, use the QA Tool, and generate data charts and sparklines. Dive into pivot tables, from basic concepts to advanced options. Discover data validation techniques, apply conditional formatting, and manage comments and notes. Understand how to link data across sheets and workbooks, and implement privacy and protection measures. With practical exercises and step-by-step guidance, enhance your Excel skills to boost productivity and data analysis capabilities.
Overview
Syllabus
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
Taught by
Learnit Training
