Learning Excel for Mac 2016

Learn how to quickly become productive with Excel for Mac 2016, including how to use functions, format data, and collaborate with others.

Introduction

• Welcome
• Using the exercise files

1. Getting Started with Excel 2016

• 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

2. Modifying Worksheets

• Formatting text
• Formatting numbers
• Formatting dates and times
• Managing rows and columns
• Freezing panes
• Merging cells
• Inserting recommended charts
• Inserting pictures
• Applying themes

3. Sharing and Printing Workbooks

• Sharing workbooks using online options
• Sending workbooks as email attachments
• Printing workbooks

Conclusion

• Next steps