Comprehensive Guide to Microsoft Excel 2016 Interface and File Management

Overview of Microsoft Excel 2016 and the Interface

• Definition and Functionality:
  • Excel is a spreadsheet application created by Microsoft and presented by Goodwill Community Foundation ("creating opportunities for better life").
  • It allows users to store, organize, and analyze data efficiently.
  • Common practical applications include creating contact lists, managing budgets, generating invoices, and building custom data logs.
• Start Screen:
  • Appears by default upon launching Excel.
  • Provides quick access to recent workbooks or options to build a new document.
  • Users can choose to build a document from scratch or select a pre-designed template.
  • Selecting Blank workbook creates a clean, unformatted workbook.
• The Ribbon Interface:
  • Located at the top of the screen as a centralized cluster of tools and commands.
  • Divided into logical tabs, including Home, Insert, and Page Layout.
  • Commands inside each tab are arranged into groups. For example, the Font group on the Home tab contains commands for text formatting, including bold, italics, font color, and font size.
  • Group Expansion Arrow: Located in the bottom-right corner of specific groups; clicking this arrow opens a dialog box with additional related commands.
  • Minimizing/Hiding the Ribbon: Click the arrow icon in the upper-right corner of the screen to minimize or adjust ribbon visibility.
• Microsoft Account Integration:
  • Located in the upper-right corner of the window.
  • Allows users to view account information, update profile photos, manage account settings, or switch between user accounts.

Quick Access Toolbar and the Tell Me Feature

• Quick Access Toolbar:
  • Positioned in the upper-left corner of the application window above or beside the ribbon.
  • Provides persistent access to frequently used commands regardless of which ribbon tab is selected.
  • Default tools include Save and Undo.
  • Customization: Clicking the drop-down arrow next to the toolbar allows users to toggle additional commands. Frequently added commands include New and Quick Print.
• Tell Me Feature:
  • A search feature introduced in Excel 2016 located on the top bar.
  • Functions as a natural-language search tool to locate features or commands.
  • Users type desired actions directly into the field using plain text; Excel provides executable options, guides the user through the process, and offers relevant help resources.

Worksheet Components and Display Controls

• Core Structure of a Document:
  • The terms workbook, worksheet, and spreadsheet are used to refer to file documents within Excel.
  • Every worksheet contains individual cells arranged within vertical columns and horizontal rows.
  • The Formula Bar sits directly above the worksheet grid and is used to view, enter, and edit data, formulas, or functions within cells.
• Navigation Tools:
  • Vertical and horizontal scroll bars enable panning up, down, and side-to-side across large worksheets.
• Display and Zoom Controls:
  • Positioned in the bottom-right corner of the interface.
  • Zoom Control: Consists of a slider bar; dragging the slider zooms the view in or out. The exact numeric zoom percentage is displayed directly alongside the slider.

Worksheet View Modes and Backstage View

• Worksheet View Options (accessible via three buttons located in the bottom-right corner):
  • Normal View: The default viewing mode, ideal for basic data entry, editing, and cell navigation.
  • Page Layout View: Displays how the worksheet will look when printed on physical paper, allowing direct editing of headers and footers.
  • Page Break Preview: Displays page boundary lines, allowing manual repositioning of page breaks to format documents containing large quantities of data prior to printing.
• Backstage View:
  • Accessed by clicking the File tab on the far left of the ribbon.
  • Serves as the main operational dashboard for overall file management.
  • Left pane options include New, Open, Save, Save As, Print, Export, Share, and Options. Selecting any option populates specific management tools in the right-hand pane.

Creating, Opening, and Pinning Workbooks

• OneDrive Cloud Integration:
  • Microsoft cloud storage service integrated across Office products to enable file storage, sharing, and access across multiple devices.
  • Requires signing into Excel with an active Microsoft Account.
• Creating Workbooks:
  • Navigate to Backstage View $\rightarrow$ New.
  • Blank Workbook: Click to create a completely clean workspace.
  • Templates: Pre-designed files containing custom layouts, visual styling, and sometimes embedded formulas or formatting. Users can browse pre-installed templates or search for specific keywords, click a template thumbnail to view a preview, and click Create to initialize.
• Opening Existing Workbooks:
  • Navigate to Backstage View $\rightarrow$ Open.
  • Recent Workbooks: Displays a list of recently accessed spreadsheet files.
  • Pinning Files: Hover over a file name in the Recent list and click the pushpin icon to lock the file at the top of the list for permanent quick access. Click the icon again to unpin.
  • Alternative File Paths:
    • OneDrive: Access files stored online in cloud storage.
    • This PC: Access files stored on local computer hard drives.
    • Browse: Opens standard file navigation windows to locate specific directories, followed by clicking Open.

Saving Workbooks, Default Settings, and AutoRecovery

• Standard Save Procedures:
  • Click the Save icon on the Quick Access Toolbar.
  • If saving a new file for the first time, Excel automatically redirects to Backstage View to select a destination.
  • Select This PC or click Browse, select a local folder directory, enter a file name, and click Save.
• Save As Functionality:
  • Accessed via Backstage View $\rightarrow$ Save As.
  • Used to save a duplicate copy, save to a different directory, or rename a workbook without altering the original file.
• Setting Local Storage as Default:
  • To make local PC storage the default save location:
    1. Go to Backstage View $\rightarrow$ Options.
    2. Select Save in the left navigation pane.
    3. Check the box reading Save to Computer by default.
    4. Click OK.
• AutoRecovery System:
  • Automatically creates background backup files to prevent data loss during unexpected crashes or failure to manually save.
  • Default backup interval: Excel auto-saves recovery files every $10\,\text{minutes}$.
  • System Limitation: Files worked on for less than $10\,\text{minutes}$ prior to a crash may not generate an AutoRecovery file.
  • Recovering Files: Upon reopening Excel following an unexpected shutdown, the Document Recovery pane appears on the left side to provide access to recovered versions.

Exporting, Sharing, and Real-Time AutoSave

• Exporting Alternate File Formats:
  • Navigate to Backstage View $\rightarrow$ Export.
  • PDF Export: Converts the workbook to a PDF format. This allows recipients without Excel installed to view (but not edit) the document using free PDF reader tools.
  • Change File Type: Allows conversion to legacy file types, such as Excel 97-2003 Workbook, which is required when sharing files with users running Excel 2003 or older versions.
• Sharing Options:
  • Click the Share button located in the upper-right corner of the interface.
  • Requires uploading the workbook to OneDrive by choosing the account option.
  • Once uploaded, users can send email invitations granting recipients view or edit access.
  • Additional options at the bottom of the Share pane include attaching the file to an email or generating a shareable link.
• Office 365 AutoSave Feature:
  • Available for Office 365 subscribers when files are hosted on OneDrive.
  • Automatically saves changes to the cloud in real time as edits are made.
  • Can be toggled off or on using the AutoSave switch located in the upper-left corner of the window.
  • Operational Warning: Deactivating real-time AutoSave requires manual reliance on the Save button to protect modifications.