To select the dialog box of Options you need to click on MS-Office Button then select Excel Options. You can change default settings such as number of iterations, font, file locations, and the file that opens on starting Excel. Changing Default SettingsĮxcel allows you to change many aspects of its behavior and how you interact with it. Tips: Press the “Alt” key to see the shortcuts to navigate through the ribbon. The super tooltip provides less description than Help, but more than an ordinary screen tip. When you point to a tool, a description called a super tooltip appears. For example, if you select text in the worksheet, and display the Font gallery, moving the pointer over each font in the gallery causes the selected text on the screen to display in that font. When you move the pointer over options on a gallery, each option is previewed on whatever is selected in the worksheet. For example, the font gallery shows the different font face options available. Each gallery displays the options under the clicked command. Using galleriesĪ gallery is an interactive list of options. A list is a collection of related commands or selections.
Some of these tools expand to display simple lists and some display galleries, as shown in Figure 1.2. When you choose a Ribbon tab, the Ribbon displays Ribbon groups that contain tools such as buttons and lists. The Ribbon is the main container for menus and tools. You interact with Excel by typing and by using the mouse to choose commands, make selections, click buttons and options. They use icons or other graphics to show the results of commands rather than the commands themselves. Gallery: Galleries might display within a Ribbon but more often are drop-down groups of commands or functions. Within each group are buttons and commands. Ribbon: Each Ribbon tab activates a Ribbon, which in turn contains groups of commands or functions. The Quick Access Toolbar can be moved below the Ribbon. You can customize the Quick Access Toolbar by adding buttons for frequently used commands. Quick Access Toolbar: Displays commands for saving the current workbook, undoing the last action, and repeating the last action. Some of these components are explained below: The components of the Excel window interact with the program or display information about what you are working on.
Components of the Excel Window Figure 1.1 Tips: Default number of sheets to open can be set to a maximum of 255. 52Ĭreating Charts using Chart Tools 54 Including Titles and Values in Charts using Chart Tools 55 Formatting charts.
51 Merging workbooks 52 Tracking changes. 49 Creating links between different software. 49Ĭreating Links between Different Worksheets. 45 Merge Scenarios from Another Worksheet 47Ĭhapter 12: Working with multiple worksheets, workbooks and applications. 43 Projecting Figures Using a Data Table 44 What-If Scenarios. 40Ĭonditional Formatting using Formula (Record Based Conditional Formatting).
38 Top/ Bottom Report 38 Group Items in a PivotTable 38Ĭonditional Formatting using Cell Values (Column Based Conditional Formatting). 37 Calculate the Percentage of the field. 31 Filtering a List using Advanced Filter. Protecting a Worksheet by using Passwords. Using Formulas in a Worksheet 10 Array Formulae. 7Ĭhapter 3: Working with Formulas and Functions. 1 Interacting with Excel 2Ĭhapter 2: Cell References and Range Names 4 Chapter 1: Introduction to Microsoft Excel 2007.
0 kommentar(er)
