Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This intermediate tutorial develops practical Excel 2021 skills through tables, Flash Fill, sorting, subtotals, charts, sparklines, PivotTables, data validation, conditional formatting, linking data, and privacy and protection features.
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