Spanish
French
Italian
Brazilian Portuguese
Introduction to Excel for Mac
Learn about the basics of Excel and the differences between Excel for Mac and windows in this free online course.rs
Description
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.
Modules
Introduction to Excel
-
Introduction to Excel - Learning Outcomes
-
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
-
Introduction to Excel - Lesson Summary
Creating Workbooks
-
Creating workbooks - Learning Outcomes
-
Entering Text and Numbers
-
Creating Basic Formulas
-
Relative vs Absolute References
-
Order of Operations
-
Working with Ranges
-
Practice Exercise 01
-
Creating workbooks - Lesson Summary
Saving Workbooks
-
Saving Workbooks - Learning Outcomes
-
Saving and Sharing Spreadsheets
-
Practice Exercise 02
-
Saving Workbooks - Lesson Summary
Navigating Large Workbooks
-
Navigating Large Workbooks - Learning Outcomes
-
Freeze Panes Option
-
Split Screen Option
-
Arranging Windows Option
-
Practice Exercise 03
-
Navigating Large Workbooks - Lesson Summary
Page Setup and Print Options
-
Page Setup and Print Options - Learning Outcomes
-
Headers and Footers
-
Print Titles
-
Comments
-
Page Setup Options
-
Printing Workbooks
-
Practice Exercise 04
-
Page Setup and Print Options - Lesson Summary
Working with Rows, Columns and Cells
-
Working with Rows, Columns and Cells in Excel - Learning Outcomes
-
Adding and Deleting Rows, Columns and Cells
-
Changing Column and Row Widths
-
Practice Exercise 05
-
Working with Rows, Columns and Cells in Excel - Lesson Summary
Course assessment
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
Certification
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.
