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
Using Show Changes
()
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
()
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
()
Glossary_LearningExcelWebOffice365.zip
(90 KB)
Ex_Files_Learning_Excel_for_the_web_2022.zip
(117 KB)