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

Excel 2010
Mirí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