Dive into the first part of a comprehensive Excel 2021 beginner tutorial spanning 1 hour and 24 minutes. Learn essential skills including navigating the Excel interface, performing calculations, using basic functions, and mastering shortcuts. Explore features like cell styles, themes, worksheet management, and custom views. Practice inserting, moving, and cutting data while understanding compatibility checks. Gain proficiency in freezing panes, saving templates, and utilizing spell check. Conclude with print preview techniques to enhance your Excel proficiency. Access accompanying exercise files for hands-on practice throughout the tutorial.
Overview
Syllabus
Start
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
