You'll get the most out of Excel by seamlessly switching between the desktop and online apps. In this video, learn how to use Excel desktop features to enhance your Excel Online experience.
- [Instructor] Did you know that Excel files created using Excel Online are automatically able to be used in both Excel Online and Excel Desktop? And whilst Excel Online doesn't have the same features as Excel Desktop, if you also have the Desktop version of Excel, did you know that it's easy to enhance your Excel Online experience? Now, I suggest you have XOL Enhance open to follow along with me. The first thing that you'll notice is we have a dataset and we have a chart. This was created a little bit earlier. Now, if we go ahead and select the chart, and then under Chart Tools, click on Chart, we don't have an option to change the chart design but this is something that we may actually wish to do. Now, Excel Online doesn't have the full features to apply a number of different chart designs but Excel Desktop has. And if you have Excel Desktop, all you need to do is go ahead and click on Open in Desktop App and once the dialog box appears, select Open Excel. And in just a few moments, Excel Desktop will open, allowing you to make a number of additional changes that aren't possible in Excel Online. Okay, with Excel Desktop open, go ahead and select the chart once more and you'll see that we now have an option called Chart Design. Now, I'm going to go ahead and select this chart design here that has the wonderful graduated shading as the background and I'm going to actually just click on the cross to the top right-hand side of the screen. And when prompted, I'm going to select Resume editing here, which allows us to keep using the file in Excel Online. And have a look at this. The chart design that we selected in Excel Desktop has been automatically applied to Excel Online. To double check that this feature has been retained, let's actually close XOL Enhance and in OneDrive, let's reopen the file. As you can see, the chart design that we applied using Excel Desktop has been retained in Excel Online. And that is just one way that you can use Excel Desktop to enhance your Excel Online experience.
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