excel 2013 level 1

Excel 2013 Level 1

Excel 2013:

Level 1

MS Excel 2013: Level 1 Page i Office of Information Technology January 2015

Table of Contents

The Excel 2013 User Interface ........................................................................................ 1

The Excel Window ....................................................................................................... 1

Excel Getting Started Window ..................................................................................... 2

File Tab .................................................................................................................... 2

The Quick Access Toolbar ....................................................................................... 4

To Access the Quick Access Toolbar tool: ........................................................... 4

The Customize the Quick Access Toolbar Tool .................................................... 5

The Ribbon .............................................................................................................. 7

Minimize the Ribbon ............................................................................................. 8

Dialog Box Launcher ............................................................................................ 9

On-demand Tabs ................................................................................................ 10

Customize the Ribbon ............................................................................................ 11

Access Customize Ribbon Tool: ......................................................................... 11

Customize the Ribbon Tool ................................................................................ 12

Status Bar .............................................................................................................. 14

Status Bar Options and Description .................................................................... 15

Exploring the Ribbon ..................................................................................................... 17

Home tab ................................................................................................................... 17

Home tab Groups ................................................................................................... 17

Insert tab .................................................................................................................... 18

Insert tab Groups ................................................................................................... 18

Page Layout tab......................................................................................................... 19

Page Layout tab Groups ........................................................................................ 19

Formulas tab .............................................................................................................. 20

Formulas tab Groups ............................................................................................. 20

Data tab ..................................................................................................................... 21

Data tab Groups ..................................................................................................... 21

Review tab ................................................................................................................. 22

Review tab Groups ................................................................................................. 22

View tab ..................................................................................................................... 23

View tab Groups ..................................................................................................... 23

Excel Options Window .................................................................................................. 24

Excel 2013:

Level 1

MS Excel 2013: Level 1 Page ii Office of Information Technology January 2015

To access the Excel Options Window: ....................................................................... 24

General Button .......................................................................................................... 25

Formulas Button ........................................................................................................ 26

Proofing Button .......................................................................................................... 27

Save Button ............................................................................................................... 28

Language Button ....................................................................................................... 29

Advanced Button ....................................................................................................... 30

Customize Ribbon Button .......................................................................................... 31

Quick Access Toolbar Button .................................................................................... 32

Excel 2013:

Level 1

MS Excel 2013: Level 1 Page 1 Office of Information Technology January 2015

The Excel 2013 User Interface

The Excel Window

The Excel 2013 Window, also known as the User Interface (UI), provides the user with all the tools needed to create, revise, and save data in a work sheet format. Within the window the user creates new work sheets, edits existing work sheets, and saves them in a digital format. It can also be used to perform calculations using formulas and functions, analyze, share, and manage information using charts and tables. The following screen shot shows the major components within the Excel Window.

File Tab Quick Access

Toolbar

Ribbon

Status Bar

Excel 2013:

Level 1


Excel Getting Started Window

Opening the Excel application, not from a saved Excel file, will display the Getting Started window. This new feature lets you:

1. Select from a list of Recent files. 2. Open Other Workbooks not in the Recent list 3. Search for online templates. 4. Choose a blank workbook, Take a tour of Excel, or select from a list of

templates.

File Tab

The File tab displays options that apply to the workbook as a whole. It contains commands to open, save, send, print, and close. It also displays a list of recently opened workbooks, the Excel Options button, and an Exit Excel button.

Clicking the File tab displays the Menu shown on the right.

Note: The Recently Workbooks and Places on the right.

Excel 2013:

Level 1


File tab Options and their Description

Option Description

Click this button to go back to application window. Note: You can also press the Esc key on the keyboard.

Four buttons provide Protect Workbook, Inspect Workbook, Versions and Browser View Options. The right hand pane diplays specific information about the open workbook.

Select a Blank Workbook or a Template. If you don’t see what youwant, try doing search at the top of the pane.

Opens a list of Recent workbooks displayed in the right pane. Displays a list of locations to browse and locate a workbook.

Saves the workbook in the .xlsx format by default. If the workbook was not previously saved, the Save As dialog box opens.

Saves the workbook in the .xlsx format by default. Save in other formats by clicking the Save As dialog box’s Save as type: button.

The left hand pane dispalys Print options while the right hand pane is a Print Preview of the workbook.

Share your Workbook with others by:

Posting it to OneDrive.

Sending it as an Email attachment.

Presenting it on line in a Lync Meeting or conversation.

Use this feature to:

Convert the workbook to a PDF or XPS file.

Change the file type of the workbook.

Closes the Workbook, the Excel application remains open.

Provides information about User, Connected Services, Product Information (Office version and type),and Excel.

Opens the Excel Options dialog box. Here you can select customization and preference options for Excel.

To learn more see Excel Options Dialog Box, page 24.

Excel 2013:

Level 1


The Quick Access Toolbar

The Quick Access Toolbar is your toolbar. It contains your most used Excel commands that you add. Located in the top left corner above the Ribbon, it contains three default buttons; Save, Undo and Redo, to get you started. Then you add the command buttons that you want in the order you want. You can also customize the toolbar for a specific document.

To customize the Quick Access Toolbar:

Note: The above Quick Access Toolbar has been customized.

To Access the Quick Access Toolbar tool:

Click the File tab to open the File Menu.

At the bottom of the menu, select Options. This opens the Excel Options dialog box.

In the left pane select the Quick Access Toolbar button.

The dialog box contains two sections; Choose commands from: and Customize Quick Access Toolbar:

See figure next page.

Excel 2013:

Level 1


The Customize the Quick Access Toolbar Tool

To Customize the Quick Access Toolbar:

1. Choose commands from: field.

By default, this field is set to Popular Commands. Click the field to display a list of other command categories. All Commands can be displayed as well as commands from each of the tabs on the Ribbon.

2. Commands list. Displays the icons and commands for the category selected in the Choose commands from: field.

Excel 2013:

Level 1


3. Customize Quick Access Toolbar: Field

Select from this field’s dropdown if the changes are:

For All Documents (default)

For (the currently opened workbook) only.

4. Current Quick Access Toolbar field.

This pane lists the commands currently on the Quick Access Toolbar and the order they are displayed.

5. Add>> and <<Remove buttons

Select a command in the left pane and click Add>>. The command is added to the list of commands in the right pane.

Select a command in the right pane and click <<Remove The command is removed from the list of commands in the right pane.

Tip: Double clicking a selected command will also Add or Remove it depending which list its in.

6. Move Up and Down arrow buttons

Select a command in the right pane to change its order up or down and change the display order on the Quick Access Toolbar.

7. Show Quick Access Toolbar below the Ribbon check box

Checking this box will cause the Quick Access Toolbar to display below the Ribbon.

8. Reset button Click this button to reset the Quick Access Toolbar to its default state (Save, Undo, and Redo buttons).

9. Import/Export button

Use Export to create a file of customizations or Import to reset customizations to a previous state.

Tip: Share your Quick Access Toolbar with others using Import/export.

10. OK button Once your Quick Access Toolbar is ready, click OK to save.

Excel 2013:

Level 1


The Ribbon

The Ribbon is the band that lies across the top of the program window. It provides you with access to the commands and other features of Excel.

The Ribbon consists of: 1. Tabs, 2. Groups, and 3. Commands.

1. Tabs By default, the Excel Ribbon has seven Tabs across the top.

1. Home 2. Insert 3. Page Layout 4. Formulas 5. Data 6. Review 7. View

Each Tab represents a category of commands or features.

2. Groups Each Tab is divided into subcategories called Groups. Each Group contains related commands or features.

3. Commands Commands can be in the form of buttons to execute a command, boxes to enter information, or menus of selectable Commands.

Note: Depending on the width of your display and the Excel window, how command buttons are displayed will change. Generally, it is best to keep the Excel window as wide as possible.

Excel 2013:

Level 1


Minimize the Ribbon

The Ribbon can be collapsed so only the tabs display. This provides more workspace for a workbook. To collapse the Ribbon:

Right click on any Tab.

From the menu that opens, select Collapse the Ribbon.

The Ribbon is minimized so only the Tabs show. Clicking on a Tab opens the Ribbon over the open workbook.

To turn off the minimize feature, reverse the above process.

Tip: Double click on the selected tab to minimize the Ribbon. Double clicking again restores the Ribbon

Excel 2013:

Level 1


Dialog Box Launcher

Not all related commands can be shown in the Group. In such cases, in the bottom right corner of the Group there is a small button with a diagonal arrow. This is called the Dialog Box Launcher. Click the button and a dialog box opens which offers more options and features.

Dialog Box Launcher Clicking the Dialog Box Launcher button opens a dialog box or a task pane. Many of the dialog boxes are recognizable from previous versions of Excel.

Excel 2013:

Level 1


On-demand Tabs

On-demand tabs are so named because they only appear on the Ribbon when an object, such as a Picture, Table, Drawing, or Chart, is selected in the work sheet. These tabs provide tools specifically for the selected object as long as the object is selected. For example, when a chart is selected, a Chart Tools tab appears. See example below.

1. Chart selected When a chart is selected, the Chart Tools Tab appears above the ribbon.

2. Chart Tools tab The Chart Tools tab appears with 2 Sub-tabs; Design and Format.

3. Design and Format sub tabs Selcting a Sub Tab changes the ribbon to reflect that tab’s Groups.

4. Sub Tab groups Each Group contains related commands for formatting the Chart.

Excel 2013:

Level 1


Customize the Ribbon

You can personalize the Ribbon with customization. The new customization feature allows you to;

Change the Order of or Turn Off existing tabs.

Create a New Tab, Add a Group or Groups to it, and add the Command Buttons you want.

Import or Export customization files from one computer to another.

Access Customize Ribbon Tool:

Click the File tab to open the File Menu.

At the bottom of the menu, click the Options button to open the Excel Options dialog box.

In the left pane of the Excel Options window, select the Customize Ribbon button.

The dialog box now contains two sections, the Choose commands from: section, and the Customize the Ribbon: section.

See figure on next page.

TIP: You can also get to the Customize the Ribbon window, by right-clicking any tab on the ribbon, and then clicking Customize the Ribbon.

Excel 2013:

Level 1


Customize the Ribbon Tool

1. Choose commands from: field.

Displays Popular Commands by default. Click the Menu button to display a list of other command categories. All Commands can be displayed as well as Macros, Groups and Commands on Tabs, and Custom Tabs and Groups.

2. Commands Pane. Displays the icons and commands for the category selected in the Choose commands from: field.

3. Customize the Ribbon: Field

Select from this field’s dropdown if the changes are:

All Tabs

Main Tabs (default)

Tool Tabs

4. Current Ribbon configuration pane.

This pane lists the Tabs, Groups, and Commands currently on the Ribbon.for the category selected in the Customize the Ribbon field.

Excel 2013:

Level 1


5. Add >> and Remove buttons

Only commands can be added to the default set of Tabs and Groups. Select a command in the left pane to add it to the right.

Commands can be added to custom made Tabs and Groups.

Note: Only Groups can be removed from the default set of Tabs. Select a group in the right pane and click Remove. The Group and its commands are removed.

6. Move Up and Down arrow buttons

Select a Tab or a Group in the right pane and move its position up or down. Postion of Commands in default groups can not be changed.

7. New Tab, New Group, and Rename buttons.

New Tab button - Creates a new tab to which you can add groups and commands.

New Group button – Creates groups on a custom tab.

Rename button – Custom Tabs and Groups can be renamed.

Select your New Group and then add Commands to it.

8. Reset button

Used to:

Reset only selected ribbon tab or

Reset all Ribbon and Quick Access Toolbar customizations.

9. Import/Export button

Use Export to create a file of customizations or Import a customizations file.

Tip: Share your Ribbon and Quick Access Toolbar with others or quickly setup the customizations on another computer using Import/export.

10. OK button Click OK to save your Ribbon customizations.

Excel 2013:

Level 1


Status Bar

The File tab, Quick Access Toolbar, Ribbon, and the Workbook Area all reside in

the MS Office Window. At the bottom of the window is the Status Bar which contains

features not to be overlooked. You can customize the Status Bar to meet your needs.

Here’s how:

Some features are default and display by default. They are:

Note: Numbered features are explained in the Options Table below.

To modify the Status Bar to meet your personal needs, right click on a blank area of

the Status Bar. The Options Menu (shown here) is displayed. Features with check

marks are turned on. No check mark, turned off.

Each Status Bar Option and its Description is shown in the following table:

Excel 2013:

Level 1


Status Bar Options and Description

Option Function or Purpose

Cell Mode (#1)

Selected by default, this option displays the current cell editing mode on the left side of the status bar. One of the following modes is displayed.

Ready to indicate ready to accept input.

Enter to indicate content entry mode. It is displayed when you select a

cell and start typing, or when you press F2 twice.

Edit to indicate in-cell editing mode. It is displayed when you double-

click a cell, or when you press F2 so that you can enter or edit data in a cell.

Point to indicate formula cell selection mode. It is displayed when you

start a formula and then click the cells that you want to include in the formula.

Flash Fill Blank

Cells and

Flash Fill

Changed Cells

Displays the number of cells that were filled and the number of cells that were

skipped (left blank) after a Flash Fill operation.

Signatures Selected by default, this option indicates that the active workbook has been

digitally signed.

Information

Management Policy

Selected by default, this option indicates that Information Rights

Management (IRM) has been used to restrict permission to content in the active workbook.

Permissions

Selected by default, this option displays an icon next to the Cell Mode indicator

that you can click to view the current read and edit document permissions. This icon displays only when access to the document has been restricted (File Tab >

Info > Protect Workbook).

Caps Lock When selected, this option displays Caps Lock to indicate that CAPS LOCK is turned on.

Num Lock

When selected, this option displays Num Lock to indicate that NUM LOCK is

turned on to allow using the keys on the numeric keypad to enter numbers in the worksheet.

Scroll Lock Selected by default, this option displays Scroll Lock to indicate that SCROLL

LOCK is turned on to allow scrolling in the worksheet by using the arrow keys.

Fixed Decimal

Selected by default, this option displays Fixed Decimal to indicate that all numerical values that you enter on the worksheet will be displayed with fixed

decimals. This option is turned on when you check the Automatically insert a

decimal point check box under Editing options on the Advanced button of the Excel Options dialog box (File tab > Options button > Advanced button).

Overtype Mode

When selected, this option displays Overtype to indicate that INSERT was

pressed to activate overtype mode while editing cell contents in cell editing mode (double-click a cell or press F2).

Excel 2013:

Level 1


End Mode

Selected by default, this option displays End Mode to indicate that END

was pressed to activate end mode. Pressing END followed by an arrow

key moves the selection in the direction of the arrow key, stopping at the start and end of data, and then the start or end of the worksheet.

Macro

Recording

When selected, this option displays a button next to the Cell Mode (Ready)

indicator that you can click to start recording a macro.

Selection Mode

Selected by default, this option displays one of the following cell selection modes.

Extend Selection when you press F8 to extend the cell selection by

using arrow keys.

Add to Selection when you press SHIFT+F8 to add a nonadjacent cell

or range to a selection of cells by using the arrow keys.

Page Number

Selected by default, this option displays the page number of the selected

worksheet page and the number of pages in the worksheet when you are working in Page Layout view or Print Preview view.

Average Selected by default, this option displays the average that is calculated from

selected cells that contain numerical values.

Count Selected by default, this option displays the number of selected cells that contain data.

Numerical

Count

When selected, this option displays the number of selected cells that contain

numerical values.

Minimum When selected, this option displays the minimum numerical value in selected cells that contain numerical values.

Maximum When selected, this option displays the maximum numerical value in selected

cells that contain numerical values.

Sum Selected by default, this option displays the sum of numerical values in selected cells that contain numerical values.

Upload Status Selected by default, this option appears to not do anything.

View Shortcuts (#2)

Selected by default, this option displays the Normal view, Page Layout view,

and Page Break Preview buttons. You can click these buttons to change the current view.

Zoom (#3)

Selected by default, this option displays the Zoom level. You can click Zoom

to open the Zoom dialog box, where you can specify the percentage of magnification that you want to use.

Zoom Slider

(#4)

Selected by default, this option displays the Zoom slider with the Zoom out

and Zoom in buttons. You can then drag the slider to Zoom out and Zoom in

or use the plus and minus buttons to change the magnification of the worksheet content in 10% increments.

Excel 2013:

Level 1


Exploring the Ribbon

The Excel 2013 Ribbon is divided up in to Tabs which represent a broad category of commands. Each Tab is broken up into sub-categories called Groups. Groups contain related command represented by buttons. The Ribbon’s organization puts task-related commands in a single location. Some Groups also have a Dialog Box Launcher which provides access to even more features and options.

Tip: Making the Excel window as wide as possible maximizes the number of Command tool buttons displayed in each tab’s Groups.

Discussed below is each of the Ribbon’s default Tabs, its Groups, and the Commands in the group.

Home tab

The Home tab contains the most commonly used commands to start working with a workbook.

Note: Your Ribbon may not look like this. See the Tip above.

Home tab Groups

Clipboard Provides Cut, Copy, and Paste commands and Format Painter. Also opens the Clipboard Pane which displays text or objects on the clipboard.

Font Provides Commands for fomatting text and formatting cells.

Alignment Provides commands to align, indent, and wrap text, and merge and split cells.

Number Provides commands for Number formatting in cells.

Styles Contains commands to Conditionally Format, Format Tables, and to set cells to pre-defined Cell Styles.

Cells

Contains tools for;

Inserting cells, rows, coumns, or a new sheet.

Deleting cells, rows, coumns, or sheets.

Formating row height, column width, organize sheets, or protect and/or hide cells.

Excel 2013:

Level 1


Editing Contains tools for Editing cells, Sorting and Filtering data, and doing Find and Replace searches.

Click the Dialog Box Launcher button to open the Clipboard or Format Cells dialog box.

Insert tab

The Insert tab contains groups that enable quick insertion of objects such as Tables, Charts, and Pictures.

Insert tab Groups

Tables Provides commands to insert Tables, Pivot Tables, and Pivot Charts.

Illustrations Provides commands to insert pictures from Picture Files, Clip Art, Shapes, or SmartArt.

Charts

Provides commands for inserting a Chart and then selecting various chart styles and formatting the selected chart. Click on to open the Insert Chart dialog box.

Sparklines A Sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values or to highlight max and min values.

Filter Filter Slicers are used in conjunction with Pivot Tables. Slicers provide buttons that you can click to filter PivotTable data.

Links Povides the command to insert or remove a Hyperlink in worksheet and designate what the link points to.

Text

Insert a Text Box in the workbook. Also provides options for inserting:

Header & Footer

WordArt

Signature Line (Microsoft Digital Siganture)

Objects

Excel 2013:

Level 1


Symbols

Provides tools for inserting:

Mathematical symbols and formulas.

A large variety of Symbols and Special Characters.

Page Layout tab

The groups on the Page Layout tab contain tools for customization of workbook pages. It also provides commands for the placement of text and graphics in the workbook.

Page Layout tab Groups

Themes Click the Themes button to select pre-built themes for the workbook. Use the Theme Colors, Fonts, and Effects buttons to create custom themes for a workbook.

Page Setup

The Page Setup group provides commands to change the features of the workbook page(s):

Margins - Select built in margins or create custom Margins.

Orientation – Choose Portrait or Landscape workbook.

Size – Select pre-set paper sizes or create a custom Size.

Print Area - Select the portion of the workbook to print..

Breaks- Insert or remove a break.

Background – Used to select a background for the workbook.

Print Titles – Opens the Page Setup dialog box to select titles to repeat at the top of each work book.

Click to launch the Page Setup dialog box.

Scale to Fit

Scale to Fit provides 3 scaling features so work book prints on a selected number of pages.


Sheet Options

Provides Options for viewing or printing Gridlines and Headings.


Arrange Provides options to Order, Select, Align, Group, and Rotate objects on the workbook.

Excel 2013:

Level 1


Formulas tab

The groups of the Formulas tab contain commands for working with Formulas and Functions in the workbook.

Formulas tab Groups

Function Library

Provides access to function groups, such as AutoSum, Financial, and Logical. Each function group has numerous functions pertinant to a specific category. The Function Library also provides the Fucntion Wizard which provides convenient insertion to the workbook of functions.

Defined Names

Contains the Name Manager and provides options for creating Cell Names far a cell or range of cells and then refering to that cell range by name in formulas. Clicking on the Name Manager button opens the Name Manager dialog box.

Formula Auditing

Provides error-checking and tracing functions to ensure the integrity of formulas. It also contains the Watch Window which allows constant tracking of specific values.

Watch Window

The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets. By using the Watch Window, you don't need to scroll or go to different parts of your worksheet.

Calculation Click the Calculations button to select how calculations are made in the work book. Also, contains options for calculating only selected portions of the workbook.

Excel 2013:

Level 1


Data tab

Groups on the Data tab are used to import and export data, establish connections with external data sources, and manipulate data within worksheets.

Data tab Groups

Get External Data

Provides commands for accessing and importing data from external sources. These sources can be an Access Database, the Internet, text files, and other sources.

Connections Contains commands for managing connections to other data sources.

Sort and Filter

Provides options for sorting and filtering data and advanced data filtering options for data analysis.

Data Tools Contains options for converting text to tables, removing data duplicates, and performing data validation, consolidation, and analysis.

Outline

Provides commands for grouping and ungrouping data and inserting subtotals.

Click on the to open the Settings dialog box.

Excel 2013:

Level 1


Review tab

The Review tab’s groups contain commands for reviewing and editing the contents of a workbook by a single person or a group of people and track the changes made.

Review tab Groups

Proofing Check, modify, and enhance the text in a workbook with features such as Spelling and Grammar Check, Research, and Thesaurus.

Language Provides a translation tool for translating selected text into different languages.

Comments

Provides the ability to insert Comments about selected text. Also provides editing and navigation tools for posted Comments.

Changes Allows the author of a workbook to set previewing and editing privelages for other users. It also provides options for navigating through changes made by others and accepting or rejecting them.

Start Inking

This button turns on the Ink Tools tab on the ribbon (see below). This tab contains pens and highlighters for marking up a worksheet.

Excel 2013:

Level 1


View tab

Groups the View tab provide commands to switch between different workbook views, show or hides features, and view multiple workbooks at the same time. It also provides commands for working with Macros.

View tab Groups

Workbook Views

Provides 4 workbook viewing options: 1. Normal 2. Page Layout 3. Page Break Preview 4. Custom Views

Note: Also, find Workbook View shortcut buttons at the right end of the Status Bar.

Show

Provides options for showing or hiding:

Rulers

Gridlines

Formula Bar

Headings

Zoom Provides Zoom controls to zoom in or out on a workbook. Note: Also, find a Zoom control button and the Zoom Slider Bar at the right side of the Status Bar.

Window Use these commands when multiple workbook windows are open at once. Commands allow displaying windows in several ways.

Macros

Click this button to open:

The Macros dialog box.

The Record Macro dialog box.

Excel 2013:

Level 1


Excel Options Window

The Excel Options Window contains customization and personalization options for the Excel Window, Workbooks, and Worksheets. Personalizing your copy of Excel will make it easier to use, increasing your efficiency and effectiveness.

To access the Excel Options Window:

1. Click on the File tab to display the File Menu.

2. Select the Options button at the bottom of the File Menu.

Excel Options Window

Clicking one of the Excel Option Buttons opens that button’s Options Pane.

Following is an explanation of some of the buttons and their features.

Excel 2013:

Level 1


General Button

Use the General button to change some of the more popular options in Excel.

User Interface Options

This section allows you to:

turn on or off the Mini Toolbar. Recommendation: Leave it on.

turn on on or off Live Preview. Recommendation: Leave it on.

change Excel’s color scheme.

choose how Screen Tips are displayed.

When Creating New Workbooks

Here you can set your preferences for:

the default font and font size for new workbooks.

the default View for new workbooks.

the number of worksheets a new workbook contains. Recommendation: Set to 1.

Personalize your copy of Microsoft Office

Sets how your name will appear in all Office applications. For example, as the author of a workbook.

Start Options

Options for:

Choosing files for Excel to openby defautlt.

Notification if Excel isn’t the default spreadsheet program.

Show the Start screen each time Excel starts.

Excel 2013:

Level 1


Formulas Button

Use the Formulas button to change options related to Formula Calculation, Working with formulas, Error Checking and, Error Checking Rules.

Calculation options Sets your preferences for how a workbook handles calculations.

Working with formulas Here you can set options for referencing cells in formulas.

Error Checking Use this section to turn off and on background error checking and the highlight color for errors.

Error checking rules Set your preference for 9 error checking rules by turning them on or off.

Excel 2013:

Level 1


Proofing Button

The Proofing button provides options to change auto correction and spelling settings.

Auto Correct options

Click the AutoCorrect Options button to open the AutoCorrect dialog box. Use this to cutomize the auto correction features. Note: Changes here will also be made in the other Office applications. Tip: Use this feature to auto correct long phrases. For instances, type bbn and it becomes Banner Basics and Navigation.

When correcting spelling in Microsoft Office programs

Provides preference options for auto correction of spelling. Click on the Custom Dictionaries… button to create custom dictionaries. Note: Changes here will also be made in the other Office applications.

Excel 2013:

Level 1


Save Button

Here you can set your default preferences for how workbooks are saved and the default location where workbook files are saved.

Save Workbooks

Set the default Format for saving Excel files and default Location where files are saved. Set how often Excel auto saves (AutoRecover) the workbook and the location of the AutoRecover file.

AutoRecover exceptions for: Used to turn on or off AutoRecover for a selected workbook.

Offline editing options…. Choose the Save location for checked out files and set the location of Server drafts.

Preserve visual appearance….

Previous versions of Excel may not have your chosen workbook colors. This provides the ability to ensure your chosen colors will be seen when the file is opened in any previous Excel version.

Excel 2013:

Level 1


Language Button

Here you can change your language preference for the Editing, Display and Help, and ScreenTips, of your Microsoft Office applications

Choose Editing Languages The default editing language is English. You can add other languages and then use different languages for dictionaries, grammar checking, and sorting.

Choose Display and Help Options

Here, choose your preferred language for Displays and when using Help. It also provides a link to Office.com where you can download more language options.

Choose Screen Tip Language

Holding your mouse pointer over buttons and other features in Excel will dispaly a Screen Tip. Use this option choose the Screen Tip display language. It also provides a link to Office.com where you can download more language options.

Excel 2013:

Level 1


Advanced Button

The Advanced button is used to access many, advanced options for customizing Excel.

There are too many to discuss here but it is well worth your time to go through them and become familiar with the available options and preference settings.

The Advanced Options sections are:

Editing Options

Cut, Copy, and Paste Options

Imaging, Size, and Quality Options

Print

Chart Options

Display Options

Display Options for this Worksheet

Formulas Options

When Calculating This Workbook Options

General Options

Excel 2013:

Level 1


Customize Ribbon Button

New in Office 2013 you can now customize the ribbon to better meet your needs.

Instructions for using this Customize the Ribbon Tool are found by clicking here or turning to Page 5 in this manual.

Excel 2013:

Level 1


Quick Access Toolbar Button

The Quick Access Toolbar button opens the Customize the Quick Access Toolbar

Window. With this tool, you can customize the Quick Access Toolbar and Keyboard

Shortcuts to meet your specific needs.

Instructions for using this Customize the Quick Access Toolbar utility are found by clicking here or turning to Page 4 in this manual.