Embark on a comprehensive 2-hour tutorial designed specifically for Mac users to master Microsoft Excel. Learn the key differences between PC and Mac versions, navigate the Excel interface, and master essential functions like creating workbooks, entering data, and formulating basic calculations. Explore advanced features such as relative and absolute references, range manipulation, and window management options. Dive into practical aspects of spreadsheet creation, including headers, footers, print settings, and cell management. Benefit from five hands-on practice exercises to reinforce your learning. Download accompanying exercise files to follow along and apply your newfound skills in real-time.
Overview
Syllabus
- Introduction to Excel for Mac
- The Difference between PC and Mac Excel
- Course Overview
- Overview of the Excel window
- Mouse and Trackpad Features
- Creating a New Workbook
- Entering Text and Numbers
- Creating Basic Formulas
- Relative vs Absolute References
- Order of Operations
- Working with Ranges
- Practice Exercise 01
- Saving and Sharing Spreadsheets
- Practice Exercise 02
- Freeze Panes Option
- Split Screen Option
- Arranging Windows Option
- Practice Exercise 03
- Headers and Footers
- Print Titles
- Comments
- Page Setup Options
- Printing Workbooks
- Practice Exercise 04
- Adding and Deleting Rows, Columns, and Cells
- Changing Column and Row Widths
- Practice Exercise 05
Taught by
Simon Sez IT
