Advanced Excel - Manage Passwords


If you are using Workbook Analysis or Compare Files commands for Workbooks that are password-protected, you can avoid having to type the password each time those files are opened.

Excel 2013 has a Password Manager, which can be accessed through the Workbook Passwords Command.

Step 1 − Click on the INQUIRE tab on the ribbon.

Step 2 − Click on Workbook Passwords in the Miscellaneous Group.

Workbook Passwords

The Password Manager window opens.

Workbook Passwords Window

Step 3 − Add passwords of your Workbooks. Add password descriptions also.

Add Passwords Description

Embed Worksheet Data in a Web Page

To share a part of your worksheet on the web, you can simply embed it on your web page. Other people can then work with the data in Excel Online or open the embedded data in Excel.

Share an Excel worksheet in an online meeting

You can present your Workbook online if you have the Lync installed.

Step 1 − Close all the Workbooks that you do not want to share and keep only the Workbook you want to share Open.

Step 2 − Click on the File menu.

Step 3 − Click on the option - Share.

Step 4 − Click on Present Online.

Step 5 − Under the option - Present Online, click Present.

Step 6 − In the Share Workbook Window, pick a scheduled meeting or click Start a new Lync meeting, and then click OK.

Step 7 − To stop sharing, click Stop Sharing at the top of the screen. You can present your Workbook online if you have a Skype Account also. Microsoft is introducing Skype for Business.