Join Joshua Rischin for an in-depth discussion in this video Using the exercise files, part of Learning Excel for the web (Office 365/Microsoft 365).
- [Instructor] To get the most out of this course, I strongly suggest following along using the exercise files that have been provided. If you need help with how to download the exercise file pack, you'll find plenty of help in the LinkedIn Learning Library. Now, you may be aware that Excel Online is designed to work seamlessly with OneDrive. The relationship between these two apps is really important to understand because every Excel Online file that you create is automatically added to your linked OneDrive account. And to ensure that Excel files open in the web-based version of the app instead of Excel Desktop, they must be opened from within OneDrive. So once you have the exercise file pack downloaded and unzipped, simply copy the folder containing the exercise files from your computer to a new folder in your OneDrive account. For the rest of this course, just make sure that you're working from within this OneDrive folder. And that's it. You're now good to go.
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Excel Essential Training (Office 365) or Learning Excel 2019.
- Using Excel Online shortcuts
- Customizing your view
- Integrating the desktop version of Excel
- Sharing workbooks in Excel Online and OneDrive
- Inserting and reviewing comments
- Creating and editing charts
- Working with PivotTables and PivotCharts