This course on Microsoft Excel for Mac aims to help beginners learn how to use Excel on a Mac, focusing on differences from the PC version. The course covers basic Excel functions such as creating workbooks, entering data, creating formulas, working with ranges, and printing. The teaching method includes video tutorials and practice exercises. This course is intended for individuals who are new to using Excel on a Mac and prefer Mac-specific Excel training.
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
