Do you know what is Contextual Tabs in MS Excel?

Contextual tabs gets activated when you create SmartArt, chart, drawings, picture, header and footer, Ink, Sparkline's, timeline, slicer equation, create table, pivot charts, and pivot tables.

This contextual tabs provide additional tools to work and edit in the chart, pivot tables etc.

For example: When you create a table from the "Table" option of Insert menu, you will get a TableTools "Design" contextual tab. By the help of this Design tab you can name and resize your table, give unique table styles, insert slicers etc.

Similarly when you create Pivot table you will get a PivotTableTools contextual tab. This further contains "Analyze" and "Design" tabs which contains tools like naming pivot table, filtering data, and calculations etc.

For more details on the Contextual tab features please get in touch with me at Samrat.biswaas@gmail.com

Samrat Biswas, MOS Excel Expert 2013, ITIL V3 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316

How to Restrict the Workbook Structure in MS Excel?

Microsoft Excel provides several layers for protecting your sheet and workbook. For example, you can protect your entire workbook, or you can protect a sheet and other elements in your sheet. Or you can protect your workbook structure from deliberate deleting or un-hiding your sheets by other users.

To prevent your workbook structure, you have two different options of doing this.

1) You can visit REVIEW ribbon and click "Protect Workbook". This will open up a dialog box "Protect Structure and Windows". Select the "Structure" Checkbox and provide a password to lock your workbook structure. The password in this is optional but it is advisable to use a password to protect the structure.

2) You can visit FILE option and select the "Protect Workbook" option. This will further open up the same dialog box "Protect Structure and Windows". And rest you can follow the same instruction given above.

 

Protecting your workbook structure will not allow other users to deliberately delete, add or change the sheet in the workbook. Infact this will disable the "Right Click" features available to delete, add and move or copy, hide and unhide features.

For more details on the sheet and workbook protection features please get in touch with me at Samrat.biswaas@gmail.com

Samrat Biswas, MOS Excel 2013, ITIL V3 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316

Do you know the Benefits of Document Inspector Option in MS Excel?

Have you came across any incident when your manager informed you that you have not removed the existing spreadsheet properties while reusing an important file received from your strategic customer? And now this secret customer's name is disclosed to its competitor who is your another potential customer!!

To avoid such situation you can use the Document Inspector tool available in MS Excel. This option helps the user to check the hidden properties or personal information.

So once your document update is over, you can visit the FILE option and click "Check for Issues" option. Refer as shown below.

Then click "Inspect Document" option. This will lead you to the document inspector dialog box. In this, you can see the different properties available in the document. You can further inspect which is relevant and which is not.

Once you click the "Inspect" button, MS Excel will check all the hidden properties available in the document. This will also allow you to delete any available properties which you don't want it to include and share it with other stakeholders/ customers.

For more details on Document Inspector and its different features other than file properties like Hidden Rows and Columns, Hidden Contents and Invisible Content etc. Please get in touch with me at Samrat.biswaas@gmail.com.

Finally, I would like to share with you all that, I have cleared the Microsoft Office Specialist Certification for MS Excel 2013 Expert. This will further encourage me to write more tips and tricks of Excel which will indeed help you all again more knowledge on this. Thanks for showing your interest in this blog.

Samrat Biswas, MOS Excel 2013, ITIL V3 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
 

Happy Diwali!!

 

Wishing you a very Happy Diwali to all the viewers of this blog!!

 

Just thought to share!! The total view status of the last 3 posts I shared in this blog. Thanks to everyone for showing interest in this. I strongly believe that this posts will definitely help you in your day to day office activities. And your visits will encourage me to write more new and unique capabilities of MS Excel.

Data Extracted from LinkedIn.

 

Do you want to make your spreadsheet read-only for others? Let's know how to mark the file as Final!

 

How to recover unsaved files in MS Excel 2013?

 

What are Sparkline in Excel?

 

 

Samrat Biswas,

Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
-----------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316