Overview
Master Microsoft Excel 2021 from the ground up in this comprehensive beginner tutorial. Begin with the basics of navigating the user interface and quickly progress to performing calculations using formulas and functions. Learn essential skills such as sorting and filtering data, creating pivot tables, and utilizing advanced functions like IF statements. Explore database functions, get an introduction to macros, and discover how to automate common Excel tasks to boost productivity. Perfect for beginners and experienced users looking to enhance their spreadsheet skills, this tutorial covers everything from basic navigation to advanced features, helping you become proficient in organizing, analyzing, and presenting data effectively 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
Taught by
Learnit Training