Tuesday, November 26, 2013

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

No comments:

Post a Comment

Preface 2nd Edition

The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS ...