Excel 2021 Advanced Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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.
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
Related Courses
Introduction to Data Analytics for BusinessUniversity of Colorado Boulder via Coursera Digital and the Everyday: from codes to cloud
NPTEL via Swayam Systems and Application Security
(ISC)² via Coursera Protecting Health Data in the Modern Age: Getting to Grips with the GDPR
University of Groningen via FutureLearn Teaching Impacts of Technology: Data Collection, Use, and Privacy
University of California, San Diego via Coursera