YoVDO

Excel 2021 Full Course Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Cleaning Courses Pivot Tables Courses Macros Courses Data Organization Courses

Course Description

Overview

Embark on a comprehensive 3-hour 49-minute tutorial designed for beginners to experienced users seeking to enhance their Microsoft Excel 2021 skills. Master the user interface, navigate efficiently, and progress through basic calculations to advanced features. Learn to manipulate data with formulas, functions, and pivot tables. Explore intermediate tools for sorting, filtering, and data visualization. Dive into advanced topics including complex database functions, macros, and task automation. Gain practical knowledge through hands-on exercises and real-world examples, covering everything from basic spreadsheet operations to sophisticated data analysis techniques. By the end of this in-depth course, acquire the skills to efficiently organize, analyze, and present data, significantly boosting your productivity in Excel 2021.

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 Data
Johns 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