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.
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
