Learn the fundamentals of Microsoft Excel 2021 for Mac in this comprehensive beginner tutorial. Master the user interface, navigate efficiently, and perform basic calculations using formulas and functions. Explore data organization techniques, including sorting, filtering, and creating pivot tables. Advance your skills with IF functions, database functions, and an introduction to macros for task automation. Designed for novice to experienced Mac users, this tutorial covers essential topics such as entering data, managing worksheets, formatting, and printing. Gain practical knowledge to enhance your productivity and streamline your spreadsheet tasks in Excel for Mac.
Overview
Syllabus
Start
Introduction
Startup Page
Excel Interface
Help and Smart Lookup
Navigating and Selecting Cells
Entering Data
Saving
Calculations, Formulas, and Functions
AutoFill Command
Relative vs Absolute Cell Reference
Inserting Rows and Columns
Cut, Copy, and Paste
AutoFill to Fill Series
Managing Worksheets
Grouping Worksheets
Formatting Worksheets
Hiding Columns and Rows
Creating Custom Views
Spell Check
Printing Worksheets
Conclusion
Taught by
Learnit Training
