Overview
Learn intermediate Excel skills in this tutorial, covering formatting lists, flash fill, custom sorting, subtotals, data charts, sparklines, pivot tables, data validation, conditional formats, comments, linking data, privacy, and protection. The course uses a hands-on approach with practical exercises and real-world examples. It is suitable for individuals looking to enhance their Excel proficiency beyond the basics.
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