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
Getting and Cleaning DataJohns Hopkins University via Coursera 数据结构与算法第二部分 | Data Structures and Algorithms Part 2
Peking University via edX 社会调查与研究方法 (下)Methodologies in Social Research (Part 2)
Peking University via Coursera 統計学Ⅰ:データ分析の基礎 (ga014)
University of Tokyo via gacco Fundamentos do Google para o Ensino
Fundação Lemann via Coursera