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 − Cpck on the INQUIRE tab on the ribbon.

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

The Password Manager window opens.

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

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 Onpne or open the embedded data in Excel.

Share an Excel worksheet in an onpne meeting

You can present your Workbook onpne 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 − Cpck on the File menu.

Step 3 − Cpck on the option - Share.

Step 4 − Cpck on Present Onpne.

Step 5 − Under the option - Present Onpne, cpck Present.

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

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