Overview
-
Learn how to quickly become productive with Excel for Mac 2016, including how to use functions, format data, and collaborate with others.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- What is Excel?
- Creating new workbooks and touring the user interface
- Adding text and numbers
- Adding formulas and functions
- Understanding cell references when copying and pasting
- Using Auto Fill
- Saving workbooks
- Formatting text
- Formatting numbers
- Formatting dates and times
- Managing rows and columns
- Freezing panes
- Merging cells
- Inserting recommended charts
- Inserting pictures
- Applying themes
- Sharing workbooks using online options
- Sending workbooks as email attachments
- Printing workbooks
- Next steps
