Excel 2016 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

If the device running Excel 2016 also has Microsoft's Skype for Business 2016 online communication software installed on it, you can present your worksheets to the other attendees as part of any online meeting that you organize.

To do this, first open the workbook you want to present at the online meeting in Excel 2016 before you select the Present Online option on the Share screen in the program's Share screen on the Backstage view (Alt+FHP). Click the Present button under the Present Online heading that appears on the right side of the Share screen.

If no Skype meeting is currently running on your computer, a Share Workbook Window dialog box then appears where you can launch one simply by clicking OK. After you close the Join Meeting Audio dialog box, your name then appears in a floating Conversation window.

To present your worksheet, highlight the Present button (the circle with a monitor icon between the Mute My Mic and Hang Up button) and then click the Present Programs item on its pop-up palette. When you select this option, a Present Programs window appears with the image of the active worksheet of the Excel workbook you're presenting. . You then click the Present button, and the Skype for Business toolbar appears pinned to the top of your computer screen with the active worksheet displayed below.

When you first present a worksheet, you have control over it. While you're in control, any menu selections or edits you make to its sheet are visible to all the other attendees of the online meeting. If you wish to give editing control to another attendee, simply choose his or her name from the Give Control drop-down menu in the Skype for Business toolbar.

You can then take back control of the worksheet by choosing Take Back Control option at the very top of the Give Control drop-down menu. When you're finished presenting the worksheet and no longer want it to be visible to the other attendees, click the Stop Presenting button on the right side of the mini-menu at the top of the presentation window.

The Skype for Business toolbar then disappears from the screen, and you return to the open workbook in Excel 2016, where you can save or abandon any editing changes made by you or by any other attendees to whom you ceded control during the time the worksheet was being presented.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

This article can be found in the category: