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

Learn how to use the unique features of Excel for the web, the online version of the ubiquitous spreadsheet app from Microsoft.

Introduction

• Learn how to use Excel for the web
• Using the exercise files

1. Getting to Know Excel for the Web

• Getting started with Excel for the web
• Become familiar with the basic features
• Enhance your data using formatting tools
• Create a unique look using Sheet View
• Become more efficient using keyboard shortcuts
• Correct mistakes using version history

2. Working Seamlessly between the Web and Desktop Apps

• Use Excel desktop to enhance your online experience
• Maintain a seamless relationship with Excel desktop

3. Collaborating with Excel for the Web

• Assist others using the Accessibility Checker
• Collaborate with others by sharing your work
• Create safeguards by updating permissions
• Give and receive feedback using cell comments
• Using Show Changes

4. Charting in Excel for the Web

• Wow stakeholders with engaging charts
• Customize your work using Chart Tools
• Create powerful PivotTables and PivotCharts
• Analyze your data using AI

5. Using Excel at Home

• Prepare a workbook for personal use
• Create and share a responsibility chart
• Create and share a vacation budget

Conclusion

• Getting the most from Excel for the web