Learning Excel for the web (Office 365/Microsoft 365) (2020)

Learn how to use the unique features of Excel Online, the browser version of the ubiquitous Microsoft spreadsheet app.

Introduction

• Learn how to use Excel Online
• Using the exercise files

1. Getting to Know Excel Online

• Quick tour of Excel Online
• Basic features of Excel Online
• Enhanced formatting features
• Customize your view
• Using Excel Online shortcuts
• Version management
• Using Show Changes

2. Working Seamlessly with Excel Online and Excel Desktop

• Using Excel desktop to enhance Online experience
• Preparing an Excel desktop workbook for Excel Online use
• Seamless integration between Excel desktop and Excel Online

3. Collaborating with Excel Online

• Using the Accessibility Checker
• Preparing permissions and sharing in Excel Online
• Preparing permissions and sharing in OneDrive
• Inserting and reviewing comments

4. Charting in Excel Online

• Introduction to Excel Online charts
• Excel Online chart tools
• What is structured data?
• Excel Online PivotTables and PivotCharts
• Using Excel Online Ideas (AI)
• Making the most of Office add-ins

Conclusion

• Conclusion