Learning Excel Online (Microsoft 365) (2021)

Course details

With Excel for the web, you can create, view, edit, and share workbooks using your web browser. In this course, instructor Joshua Rischin starts with a quick tour of Excel for the web, showing the unique features of the online app and how it interacts with other Microsoft services such as OneDrive. Next, Joshua shows how to work seamlessly with both versions of Excel: Creating and editing workbooks, sharing workbooks, creating charts, pivot tables, and more. If your business is moving towards the cloud, then it makes sense that your software does too. Learn how to use Excel for the web and collaborate from anywhere.

Concepts

0. Introduction

01 - Learn how to use Excel for the web
02 - Using the exercise files

1. Getting to Know Excel for the Web

03 - Getting started with Excel for the web
04 - Become familiar with the basic features
05 - Enhance your data using formatting tools
06 - Create a unique look using Sheet View
07 - Become more efficient using keyboard shortcuts
08 - Correct mistakes using version history
09 - Review edits using Show Changes

2. Working Seamlessly between the Web and Desktop Apps

10 - Use Excel desktop to enhance your online experience
11 - Maintain a seamless relationship with Excel desktop

3. Collaborating with Excel for the Web

12 - Assist others using the Accessibility Checker
13 - Collaborate with others by sharing your work
14 - Create safeguards by updating permissions
15 - Give and receive feedback using cell comments

4. Charting in Excel for the Web

16 - Wow stakeholders with engaging charts
17 - Customize your work using Chart Tools
18 - Create powerful PivotTables and PivotCharts
19 - Analyze your data using AI

Conclusion

20 - Getting the most from Excel for the web

Learning Excel Online (Microsoft 365) (2021)

Authors

Joshua Rischin