WIXLIB

F8Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keysextend the selection.SHIFT F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.CTRL F8 performs the Size command (on the Control menu for the workbook window) when a workbook is notmaximized.ALT F8 displays the Macro dialogue box to create, run, edit, or delete a macro.F9Calculates all worksheets in all open workbooks.SHIFT F9 calculates the active worksheet.CTRL ALT F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since thelast calculation.CTRL ALT SHIFT F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, includingcells not marked as needing to be calculated.CTRL F9 minimizes a workbook window to an icon.F10Turns key tips on or off.SHIFT F10 displays the shortcut menu for a selected item.ALT SHIFT F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches tothe next smart tag and displays its menu or message.CTRL F10 maximizes or restores the selected workbook window.F11Creates a chart of the data in the current range.SHIFT F11 inserts a new worksheet.ALT F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic forApplications (VBA).F12Displays the Save As dialogue box.Other useful shortcut keysKEYDESCRIPTIONARROWKEYSMove one cell up, down, left, or right in a worksheet.CTRL ARROW KEY moves to the edge of the current data region in a worksheet.SHIFT ARROW KEY extends the selection of cells by one cell.CTRL SHIFT ARROW KEY extends the selection of cells to the last nonblank cell in the same column or rowas the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When asubmenu is open or selected, these arrow keys switch between the main menu and the submenu. When aRibbon tab is selected, these keys navigate the tab buttons.DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.When a Ribbon tab is selected, these keys navigate up or down the tab group.In a dialogue box, arrow keys move between options in an open drop-down list, or between options in a groupof options.DOWN ARROW or ALT DOWN ARROW opens a selected drop-down list.BACKSPACEDeletes one character to the left in the Formula Bar.Also clears the content of the active cell.In cell editing mode, it deletes the character to the left of the insertion point.DELETERemoves the cell contents (data and formulas) from selected cells without affecting cell formats or comments.In cell editing mode, it deletes the character to the right of the insertion point.ENDMoves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.Also selects the last command on the menu when a menu or submenu is visible.CTRL END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If thecursor is in the formula bar, CTRL END moves the cursor to the end of the text.CTRL SHIFT END extends the selection of cells to the last used cell on the worksheet (lower-right corner). Ifthe cursor is in the formula bar, CTRL SHIFT END selects all text in the formula bar from the cursor positionto the end—this does not affect the height of the formula bar.ENTERCompletes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).In a data form, it moves to the first field in the next record.Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.In a dialogue box, it performs the action for the default command button in the dialogue box (the button withthe bold outline, often the OK button).ALT ENTER starts a new line in the same cell.CTRL ENTER fills the selected cell range with the current entry.SHIFT ENTER completes a cell entry and selects the cell above.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 3

ESCCancels an entry in the cell or Formula Bar.Closes an open menu or submenu, dialogue box, or message window.It also closes full screen mode when this mode has been applied, and returns to normal screen mode todisplay the Ribbon and status bar again.HOMEMoves to the beginning of a row in a worksheet.Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.Selects the first command on the menu when a menu or submenu is visible.CTRL HOME moves to the beginning of a worksheet.CTRL SHIFT HOME extends the selection of cells to the beginning of the worksheet.PAGE DOWNMoves one screen down in a worksheet.ALT PAGE DOWN moves one screen to the right in a worksheet.CTRL PAGE DOWN moves to the next sheet in a workbook.CTRL SHIFT PAGE DOWN selects the current and next sheet in a workbook.PAGE UPMoves one screen up in a worksheet.ALT PAGE UP moves one screen to the left in a worksheet.CTRL PAGE UP moves to the previous sheet in a workbook.CTRL SHIFT PAGE UP selects the current and previous sheet in a workbook.SPACEBARIn a dialogue box, performs the action for the selected button, or selects or clears a check box.CTRL SPACEBAR selects an entire column in a worksheet.SHIFT SPACEBAR selects an entire row in a worksheet.CTRL SHIFT SPACEBAR selects the entire worksheet.If the worksheet contains data, CTRL SHIFT SPACEBAR selects the current region. PressingCTRL SHIFT SPACEBAR a second time selects the current region and its summary rows. PressingCTRL SHIFT SPACEBAR a third time selects the entire worksheet.When an object is selected, CTRL SHIFT SPACEBAR selects all objects on a worksheet.ALT SPACEBAR displays the Control menu for the Microsoft Office Excel window.TABMoves one cell to the right in a worksheet.Moves between unlocked cells in a protected worksheet.Moves to the next option or option group in a dialogue box.SHIFT TAB moves to the previous cell in a worksheet or the previous option in a dialogue box.CTRL TAB switches to the next tab in dialogue box.CTRL SHIFT TAB switches to the previous tab in a dialogue box.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 4

What’s New in Excel 2010Access the right tools, at the right timeNew and improved features can help you be more productive, but only if you can find themwhen you need them. Like the other Microsoft Office 2010 programs, Excel 2010 includes theMicrosoft Office Fluent interface, which consists of a customizable visual system of tools andcommands.Improved ribbonFirst introduced in Excel 2007, the ribbon makes it easy for you to find commands and featuresthat were previously buried in complex menus and toolbars. Although you could customize theQuick Access Toolbar in Excel 2007, it wasn’t possible to add your own tabs or groups to theribbon. In Excel 2010, however, you can create custom tabs and groups and rename or changethe order of the built-in tabs and groups.Microsoft Office Backstage viewClick the File tab to open Backstage view, where you create new files, open existing files, save,send, protect, preview, and print files, set options for Excel, and more.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 5

Improved conditional formattingConditional formatting makes it easy to highlight interesting cells or ranges ofcells, emphasize unusual values, and visualize data by using data bars, colorscales, and icon sets. Excel 2010 includes even greater formatting flexibility: New icon setsFirst introduced in Office Excel 2007, icon setslet you display icons for different categories of data, based onwhatever threshold you determine. For example, you can use agreen up arrow to represent higher values, a yellow sideways arrowto represent middle values, and a red down arrow to represent lowervalues. In Excel 2010, you have access to more icon sets, includingtriangles, stars, and boxes. You can also mix and match icons fromdifferent sets and more easily hide icons from view—for example,you might choose to show icons only for high profit values and omitthem for middle and lower values. More options for data barsExcel 2010 comes with newformatting options for data bars. You can apply solid fills or borders tothe data bar, or set the bar direction from right-to-left instead of left-toright. In addition, data bars for negative values appear on the oppositeside of an axis from positive values, as shown here. Other improvements When specifying criteria for conditional ordata validation rules, it's now possible to refer to values in otherworksheets in your workbook.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 6

Improved function accuracyIn response to feedback from the academic, engineering, and scientific communities, Excel2010 now includes a set of more accurate statistical and other functions. Certain existingfunctions have also been renamed to better describe what they do. Accuracy improvementsA number of functions havebeen optimized to improve accuracy. For example, Excel2010 returns more accurate results for the beta and chisquared distributions.More consistent functions Certain statistical functionshave been renamed so that they are more consistent withthe function definitions of the scientific community and withother function names in Excel. The new function names alsomore accurately describe their functionality. Workbookscreated in earlier versions of Excel will continue to workdespite these name changes, because the original functionsstill exist in a Compatibility category.Improved filter capabilitiesIn addition to slicers, which are described earlier in this article, Excel 2010 comes with newfeatures that make it easier to sort and filter data. New search filterWhen you filter datain Excel tables, PivotTables, and PivotCharts, youcan use a new search box, which helps you to findwhat you need in long lists. For example, to find aspecific product in a catalog that stocks over100,000 items, start by typing your search term, andrelevant items instantly appear in the list. You cannarrow the results further by deselecting the itemsyou don't want to see. Filter and sort regardless of locationIn anExcel table, table headers replace regularworksheet headers at the top of columns when youscroll down in a long table. AutoFilter buttons nowremain visible along with table headers in your tablecolumns, so you can sort and filter data quicklywithout having to scroll all the way back up to thetop of the table.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 7

Customising the ToolbarTo customise the Quick Access Toolbar: Click on the small down-pointing arrow at the right of the Quick Access Toolbar. Click the More Commands option, to display the Excel Options screen.www.microsofttraining.net Best STL 2013Tel: 0207 987 3777Page 8

To add a button:Select a command from the list on the left and then click the Add button, the command or optionin question will be added to the Quick Access Toolbar when you click OK.To remove a button:Select a command from the list on the right (the buttons that are currently on the Quick AccessToolbar) and

CTRL SHIFT Applies the Exponential number format with two decimal places. CTRL SHIFT # Applies the Date format with the day, month, and year. CTRL SHIFT @ Applies the Time format with the hour and minute, and AM or PM. CTRL SHIFT ! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.