Excel 2016 All-in-One For Dummies. Harvey Greg

Чтение книги онлайн.

СКАЧАТЬ style="font-size:15px;">      ✔ Browser View Options to control what parts of the Excel workbook can be viewed and edited by users who view it online on the Web

      On the right side of the Info screen, you see a list of various and sundry bits of information about the file:

      ✔ Properties lists the Size of the file as well as any Title, Tags, and Categories (to help identify the file when doing a search for the workbook) assigned to it. To edit or add to the Title, Tags, or Categories properties, click the appropriate text box and begin typing. To add or change additional file properties, including the Company, Comments, and Status properties, click the Properties drop-down button and then select Show Document Panel or Advanced Properties from its drop-down menu. Select Show Document Panel to open the Document panel in the regular worksheet window where you can edit properties such as Author, Title, Subject, and Keywords and to add comments. Select the Advanced Properties option to open the workbook’s Properties dialog box (with its General, Summary, Statistics, Contents, and Custom tabs) to change and review a ton of file properties.

      ✔ Related Dates lists the date the file was Last Modified, Created, and Printed.

      ✔ Related People lists the name of the workbook’s author as well as the name of the person who last modified the file. To add an author to the workbook file, click the Add an Author link that appears beneath the name of the current author. If the workbook file is new and you’ve never saved it on disk, the words “Not Saved Yet” appear after Last Modified By.

      ✔ The Open File Location check box appears under the Related Documents heading. Select it to open the folder containing the current workbook file, where you can find associated workbook files to work with.

      ✔ The Show All Properties link, when clicked, expands the list of Properties to include text fields for Comments, Template, Status, Categories, Subject, Hyperlink Base, and Company that you can edit.

       Sizing up other File menu options

      Immediately below the Info option at the very top of the File menu, you find the commands you commonly need for working with Excel workbook files, such as creating new workbook files as well as opening, saving, and closing files. (See Book II, Chapter 1 for more on saving and closing files and Book II, Chapter 3 for more on opening them.)

      The New command immediately below Info displays a New screen, which, just like the Excel Start screen, displays a thumbnail list of all the available spreadsheet templates. (See Book II, Chapter 1 for more on creating and using workbook templates.)

      Beneath the Save As command you find the Print option that, when selected, displays a Print screen. This screen contains the document’s current print settings (that you can modify) on the left side and a preview area that shows you the pages of the printed worksheet report. (See Book II, Chapter 5 for more on printing worksheets using the Print Settings panel in the Backstage view.)

      Below the Print command you find the Share option, which displays a list of commands for sharing your workbook files online. Beneath this, you find an Export option used to open the Export screen, where you find options for converting your workbooks to other file types as well as controlling the browsing options when the workbook is viewed online in a web browser. (See Book IV, Chapter 4 for more about sharing workbook files online as well as converting them to other file formats.)

      The new Publish option enables you to save your Excel workbooks to a folder on your OneDrive for Business account and then publish it to Microsoft’s Power BI (Business Information) stand-alone application that enables you to create visual dashboards that highlight and help explain the story behind the worksheet data.

       Checking user and product information on the Account screen

      Below the Close option that is used to close a workbook file (hopefully, after saving all your edits) on the File menu, you find the Account option. You can use this option to review account-related information on the Backstage Account screen. When displayed, the Account screen gives you both user and product information.

      On the left side of the Account screen, your user information appears, including all the online services to which you’re currently connected. These services include social media sites such as Facebook, Twitter, and LinkedIn, as well as the more corporate services such as your OneDrive, SharePoint team site, and Office 365 account.

      To add an online service to this list, click the Add a Service button at the bottom and select the service to add on the Images & Videos, Storage, and Sharing continuation menus. To manage which accounts appear on the list, highlight the name and click the Remove button to take it off the list. To manage the settings for a particular service, click the Manage button and then edit the settings online.

       Use the Office Background drop-down list box that appears between your user information and the Connected Services list on the Account screen to change the pattern that appears in the background of the title bar of all your Office 2016 programs. By default, Office 2016 uses a Clouds pattern. You can change the background by selecting a new pattern from the Office Background drop-down menu on the Excel Account screen or have no pattern displayed by selecting None from the menu. Below this option, you see the Office Theme selection (Colorful by default) that sets the overall color pattern you use. Just be aware that any change you make here affects the title areas of all the Office 2016 programs you run on your device (not just the Excel 2016 program window).

      On the right side of the Account screen, you find the Product information. Here you can see the activation status of your Office programs as well as review the version number of Excel that is installed on your device. Because many Office 365 licenses allow up to five installations of Office 2016 on different devices (desktop computer, laptop, Windows tablet, and smartphone, for example), you can select the Show Additional Licensing Information link and then click the Manage Account link that appears to go online. There, you can check how many Office installations you still have available and, if need be, manage the devices on which Office 2016 is activated.

Ripping through the Ribbon

The Ribbon (shown in Figure 1-4) groups related commands together with the goal of showing you all the most commonly used options needed to perform a particular Excel task.

       Figure 1-4: Excel’s Ribbon consists of a series of tabs containing command buttons arranged into different groups.

      The Ribbon is made up of the following components:

      ✔ Tabs: Excel’s main tasks are brought together and display all the commands commonly needed to perform that core task.

      ✔ Groups: Related command buttons can be organized into subtasks normally performed as part of the tab’s larger core task.

      ✔ Command buttons: Within each group you find command buttons that you can select to perform a particular action or to open a gallery. Note that many command buttons on certain tabs of the Excel Ribbon are organized into mini-toolbars with related settings.

      ✔ Dialog Box launcher: This button is located in the lower-right corner СКАЧАТЬ