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

Introduction

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

1. Getting to Know Excel Online

• Getting started with Excel Online
• 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. Collaborating with Excel Online

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

3. Charting in Excel Online

• What you should know before charting
• Wow stakeholders with out-of-the-box charts
• Customize your work using Chart Tools
• Create powerful PivotTables
• Create engaging PivotCharts
• Analyze your data using AI

4. Using Excel at Home

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

5. Doing More with Excel Online

• Enhance your experience with Office add-ins
• Optimize the look and feel of your workbook
• Eliminate headaches with Freeze Panes
• Take care of your eyes using Zoom

6. Working Seamlessly between the Desktop and Online Apps

• The key differences between Excel desktop and the online app
• Use Excel desktop to enhance your online experience
• Maintain a seamless relationship with Excel desktop

Conclusion

• Getting the most from Excel Online