Introductory Excel for Mac Online Course | Free Online | Alison

The New Alison App has just launched Download Now

Introduction to Excel for Mac

Learn about the basics of Excel and the differences between Excel for Mac and windows in this free online

Software Tools
Free Course
This free online course on Microsoft Excel for Mac will come in handy for beginners who have just begin their journey into the world of Excel. The course is suitable for you if you are a Mac 2019 and Microsoft 365 users. By the end of this course, you will become better familiar with the differences between Excel for Mac and Excel for windows. Start this course today and get access to great amazing content on Microsoft Excel for Mac.





View course modules


This free online course on Introduction to Excel for Mac takes you from zero knowledge to a confident spreadsheet user. The course begins by explaining the use of Excel as a spreadsheet, and how to create amazing spreadsheet stuffs Excel. You will learn about the methods that can be used to overcome the challenges associated with migrating from PC to Mac. You will also learn about how to differentiate between PC and Mac versions of Excel. 

The course then describes how to enter texts and numbers into the Excel worksheet. You will be introduced to several different ways of adding content into cells in an Excel worksheet and how to create basic formulas in Excel worksheet. The course explains the concept of absolute and relative referencing and how to determine the suitable type of referencing format to be used in an Excel worksheet. 

The course the available features and their corresponding commands on Excel for Mac. You will learn how to share files in Excels. You will be introduced to the Freeze Pane feature in Excel and how it helps improve efficiency. You will learn about the arrangement of windows options available in Excel. The course also explains how headers and footers are used to give important information about the spreadsheet. Start this course today and explore the amazing options available in Excel for Mac. 

Start Course Now

Learning Outcomes

Upon successful completion of this course, you should be able to:

  • Differentiate between PC and Mac Excel
  • Describe the main Mouse and Trackpad features
  • Explain how to create a new workbook
  • Discuss how to enter text and numbers into a spreadsheet in Excel
  • Describe how to create basic formulas in Excel for Mac
  • Differentiate between Relative and Absolute References
  • Explain the Order of Operations
  • Discuss with Ranges in Excel for Mac snd how to save and share spreadsheets
  • Describe how to use Freeze Panes and Split Screen
  • Explain how to arrange your windows in Excel for MacPage Setup Options including Printing Options
  • Describe how to add and delete Rows, Columns, and Cells
  • Describe how to change Column and Row widths


All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:

Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Certificates for completed Certificate courses:

Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping

All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.


    You have received a new notification
    Click here to view them all