Learn how to ensure that a spreadsheet can continue to be seamlessly used in both Excel Online and Excel desktop.
- [Instructor] Once a file has been opened and closed…in Excel Online, it is available to use…in both Excel Online and Excel Desktop.…The best way to maintain a seamless integration…between the two is to try and make all changes…in Excel Online.…If you'd like to follow along with me,…then have XOL SimpleChart open.…Let's go ahead and make a very simple change to this chart.…I'm just going to left-click on the chart to select it.…I'm going to select Gridlines,…and under Primary Horizontal Gridlines,…I'm going to select the option, Minor Gridlines…and as you can see, we have some very small gridlines…now appear in this chart.…
With the chart still selected, go back and select Gridlines,…Primary Vertical Gridlines, and select Minor Gridlines,…and you'll see that vertical gridlines…have now been included in this chart.…However, not every feature change,…such as changing chart styles, is available in Excel Online,…so let's go ahead and edit in Excel…by selecting OPEN IN EXCEL…at the top right-hand side of the screen.…
- Creating and editing workbooks
- Using Excel Online shortcuts
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating and editing charts
- Designing and creating forms
Skill Level Beginner
1. Getting to Know Excel Online
2. Working Seamlessly with Excel Online and Excel Desktop
3. Collaborating with Excel Online
4. Charting in Excel Online
5. Creating Forms with Excel Online
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.