Tabs

Contact Us or call 1-877-932-8228
Tabs

Tabs

Microsoft Excel is a powerful program which is used to analyze and present data, perform calculations, and much more. Microsoft Excel has hundreds of commands for working with different scenarios. To make it easier for users to find the specific commands they are looking for, commands are organized onto eight main tabs:

  1. HOME. The HOME tab includes commands for formatting worksheets, cells and data and commands for inserting and deleting columns and rows.
  2. INSERT. Use the INSERT tab to insert tables, illustrations, charts, links, sparklines, headers & footers, custom text and symbols, and more.
  3. PAGE LAYOUT. Use the PAGE LAYOUT tab to change your margins, change the page background, change the page orientation, and more.
  4. Formulas. Use the FORMULAS tab to browse and select formulas and functions, to define names, to audit formulas, and more.
  5. DATA. Use the DATA tab to access external data, to sort & filter, to access data tools, to group cells together, to add subtotals, and more.
  6. REVIEW. Use the REVIEW tab to check spelling, add comments, protect your worksheet or workbook, and more.
  7. VIEW. Use the VIEW tab to change your workbook view, show or hide gridlines, headings, the formula bar and the ruler, arrange windows, freeze panes, zoom in or out, and more.
  8. ADD-INS. You may or may not see the ADD-INS tab. This tab shows up after you install and activate your first Add-In. Add-Ins are beyond the scope of this course.Main Tabs

Note that the FILE menu is not the same as a tab. The File menu takes you to the Backstage view, where you manage, rather than make changes to, your workbook. The Backstage view is covered in the next lesson.

Tool Tabs

In addition to the main tabs, there are numerous tool tabs which include less commonly used commands. Individual tool tabs are covered in detail in our intermediate and advanced Microsoft Excel classes. For now you should know:

  • That they exist. Some of the most commonly used tool tabs are:
    • SMARTART
    • CHART
    • DRAWING
    • PICTURE
    • PIVOTTABLE
    • PIVOTCHART
    • HEADER & FOOTER
  • That they will appear when you select commands which have related tool tabs. For example, when you insert a PivotTable, two PivotTable-specific tool tabs (ANALYZE (Options in Excel 2007/2010) and DESIGN) will appear: PivotTable Tools Tabs
Next