Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Using the Menu System

This guide will show you what the functions of the various tabs in Excel are and what tools each tab contains.

VIDEO

There are various tabs available when Excel is opened. Here are the tabs and some of their various functions.

  • Home

    • This tab contains formatting tools and command features. Many of these are used frequently, such as decimal point placement and font size.
  • Insert

    • This is the tab where things such as tables and pivot tables are placed. Charts come from here as well, and hyperlinks can be placed.
  • Page Layout

    • This tab has contains tools such as themes, margins, and page orientation.
  • Formulas

    • This tab contains formula insert functions, suggestions for various financial and logical formulas, and many other formula items.
  • Data

    • This tab contains important data tools such as Sorting and Filtering as well as the What If? Analysis.
  • Review

    • This tab contains tools such as spell check, the thesaurus, and translations.
  • View

    • This tab contains tools which customize the excel window, such as having/not having the formula bar appear, zooming in and out, or freezing rows/columns.
  • File

    • This tab brings up the “backpage” view, which brings up options such as saving or printing.

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or helpdesk@uwosh.edu




Keywords:"Excel Basics", "Page Layout", insert, formulas, data,   Doc ID:65909
Owner:William W.Group:UW Oshkosh
Created:2016-08-09 12:39 CDTUpdated:2016-12-20 11:27 CDT
Sites:UW Oshkosh
Feedback:  0   0