Excel 2021 Full Course Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
Syllabus
Start
Introduction
Start Screen
Excel Interface
Zooming, Navigating, and Shortcuts
Performing Excel Calculations
Simple Excel Functions
ABS, REF, and AutoFill Functions
Checking Compatibility
Inserting, Moving, and Cutting
Cell Styles
Themes
Showing and Hiding Worksheets
Grouping Worksheets
Freeze Panes
Custom Views
Saving Templates
Spell Check
Print Preview
Conclusion
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
Introduction
Nesting Functions
Database Functions
XLOOKUP
UNIQUE
SORT and SORTBY
FILTER
LET
Consolidate
Introduction to Macros
Recording and Playing Macros
Conclusion
Taught by
Learnit Training
Related Courses
Excel 2010Miríadax Excel Avanzado
Miríadax Problem Solving with Excel
PwC via Coursera Excel: gestión de datos
Universitat Politècnica de València via edX Excel によるデータの分析と可視化
Microsoft via edX