Microsoft Excel 2010

1. Microsoft Excel 2010 Lesson 1: Understanding Microsoft Office Excel 2010

2. What is Excel? • An electronic spreadsheet program that is used for storing, organizing, and manipulating data • Data is organized in rows and columns Columns run vertically Rows run horizontally Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

3. Excel Ribbon Tab Ribbon • Excel Ribbon contains tabs (Home, Insert, etc.) that hold most Excel features • Can be minimized to make more space for the worksheet • ScreenTips (displayed at right) show name/description of icon • Contextual tabs (shown below) are temporary tabs that appear on the Ribbon when you’re working on specific tasks

4. Using the Ribbon • The Dialog Box Launcher has a range of additional options and commands • Located at the bottom right corner of many groups • Keyboard shortcuts can be activated by clicking the Alt key Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

5. Create a New Workbook or Worksheet • Workbook: • Click File, click New, click Blankworkbook and then click Create, or • press Ctrl+N • Worksheet: • Click on the Insert worksheet icon, found at the bottom of the Excel worksheet Insert worksheet icon Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

6. Quick Access Toolbar • A Customizable toolbar that contains a set of commands that are frequently used by the user • Located at top left of Excel screen • Can be customized • Click on the icon to add frequently used commands to the toolbar, OR • Right-click an icon from any given tab, and then click Add to Quick Access Toolbar on the shortcut menu. Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

7. Saving Workbooks • Click File, Save As, to save with a new file name • Click File, Save, to save all changes in the document • The / \ < > * ? " | : ; characters may not be used when naming a workbook • To change to a different file type (such as an earlier version of Excel, PDF, etc.), click on the down pointing arrow beside Save as type Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

8. Excel 2010 Screen Close File Quick Access Ribbon Title Maximize/Restore Tab Toolbar Bar Minimize Name Box Insert Function Formula Bar Help Workbook Name Active Column Cell Headings Row Headings Scroll Bars Tab Scrolling Buttons Sheet Tabs Status Bar View Buttons Zoom Slider Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

9. Copying/Cutting Cell Content • Copy • Click Copy (found in the Clipboard group on the Home tab), or • Press Ctrl+C, or • Right-click selected item and then click Copy • Copied items are placed on the Clipboard • The Clipboard holds up to 24 items and can be accessed by clicking on the Dialog Box Launcher in the Clipboard group Cut • Click Cut (found in the Clipboard group on the Home Tab), or • Press Ctrl+X, or • Right-click selected item and then click Cut Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

10. Paste Options • Paste • Click Paste (found in the Clipboard group on the Home tab), or • Press Ctrl+V, or • Right-click selected item and then click Paste • Paste Special • Allows you to choose how data is pasted • Paste Special is found by clicking on the arrow for Paste, then select Paste Special Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

11. Paste Options (cont’d…) • Paste with Live Preview • Allows the user to preview how the data will be pasted without actually pasting it • Found on the Home tab, in the Clipboard group, by clicking the down arrow under Paste • Preview by scrolling over the different paste options • Options include pasting formulas, formatting options (including borders), transposing data, pasting values, and pasting pictures Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

12. Modifying Worksheet Tabs • Rename a tab by double clicking on the sheet name, or by right-clicking and selecting Rename • Differentiate worksheet tabs by adding color to them • When a worksheet is active, the color will appear as a line below the sheet name • When a worksheet is NOT active, the color will take up the entire background of the sheet name • To add color to a worksheet tab, select the worksheet tab and then: • On Home tab, in the Cells group, click Format and click Tab Color, or • right-click the worksheet tab and click Tab Color. Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

13. Find & Replace Cell Content • Data can be easily found and replaced using Excel’s Find & Select Feature • Data can be searched for by using a search string as well as matching the case of the data or matching the entire contents of the cell • On the Home tab, in the Editing group, click Find & Select, then click Find or Replace Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

14. Copying or Moving Worksheets • To copy or move a worksheet: • Right-click sheet tab to be moved or copied and click Move or Copy, or • Click and drag sheet tab to new location Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

15. Excel Terms • Active Cell — The cell ready for data entry. • Alignment — When data is entered into a cell, the default alignment is labels to the left and values to the right. • Cell — Intersection of a row and column and is identified by a cell reference. • Cell range — A selected group of cells that form a rectangle (B2:B12, C5:F15) • Cell reference — Identifies a cell; The column letter and the row number. Example: B12 • Column — Identified by letters that appear at the top of the spreadsheet. (Vertical) • Formula — Equations with symbols for math operations. Example =B6+B7+B8+B9 Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series

16. Excel Terms (cont’d…) • Function — Special formulas that do not use operators to calculate a result. i.e. A shortcut formula. Example: sum(A6:A9) • Label — Text, symbols, dates, or numbers not used in calculations. • Rows — Identified by numbers on the left side of the spreadsheet. (Horizontal) • Spreadsheet — A program that allows you to use rows and columns of data to manage, predict, and present information. • Value — A number entered into a spreadsheet cell that will be used for calculations. • Workbook – Excel file containing one or more worksheets • Worksheet – Asingle spreadsheet within a workbook that contains rows and columns of data Developed by Jennifer Tyndall for ExplorNetMSITA Workshop Series