Using the Table of Contents in Excel

When you click the Show Table of Contents button on the Help Viewer toolbar (the one with the closed book), Technical Data used in the field explained in advanced excel training courses in Rawalpindi,  a Table of Contents pane appears on the left side of the window. The Table of Contents pane contains a list of all Excel 2010 help topics arranged hierarchically in topical categories.

When you first open the Table of Contents pane, only the main help categories are shown — the subtopics are collapsed beneath the main categories, To display a subcategory, click the closed book icon in front of the topic’s name. As soon as you do this, the closed book icon becomes an open book icon, and all the subtopics for that section of pane are displayed, indented below the main topic. Some more details of advanced excel training courses in Rawalpindi are as under.

After you’ve displayed the subcategories beneath a main help topic, you can start burrowing deeper into a particular category by clicking its closed book icon. All main categories have subcategories, and some subcategories have their own subcategories. Regardless of the number of nested levels, however, you eventually come to a list of help pages, indicated by the blue question mark icon.

When you click a link with a blue question mark icon in the Table of Contents pane, Excel displays the help article in the right pane of the Help Viewer If the article has multiple sections, you can then expand all the information in the article by clicking the Show All link at the top of the article. Print the text by clicking the Print button. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join advanced excel training courses in islamabad.

Browsing Excel 2010 Help

When you first open the Excel Help window — either by clicking the Help button (the one with the question mark to the right of the last tab on the Ribbon) or by pressing F1 — the Help Viewer appears in the window. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

To display information on any topic in the Browse Excel 2010 Help list, simply click its link. For example, to get help on charting data in your spreadsheet, click the Charts link in the original list. You then click the Creating Charts link to display a list of chart-related topics in the Excel Help window. For example, to get information on creating a new chart, you’d click the link to the Create a Chart from Start to Finish topic.

Excel then displays a list of browsing topics about creating a chart from which you can choose. To display the actual help information in this pane, you click the name of the topic whose article you want to see (“Repeat specific rows or columns on every printed page,” in this example). Excel displays the text of the article in the Help Viewer. You can read the article in the Help Viewer. Or you can print a copy. Click the Print icon on the Help toolbar to open the Print dialog box and then click the Print command button in this dialog box to send the article to the default printer. Some more details of advanced excel training courses in Rawalpindi are as under.

You can click the Show All link at the top right of an article to expand all the subtopics throughout the article before printing it. If you don’t want to expand all the subtopics throughout the article, you can click individual links to expand just those sections in which you’re interested. You can find links to related articles in the See Also section at the very bottom of each article. Be sure to check these links out whenever you feel that you need more information about a topic than the article you selected gives you. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join advanced excel training courses in Islamabad.

Launching and Quitting Excel Part (B) Pinning Excel to the Windows 7 Taskbar

If your computer runs Windows 7, you can add a Microsoft Excel 2010 icon to the standard Internet Explorer, Windows Explorer, and Windows Media Player buttons on its taskbar. To do this, drag the Microsoft Excel 2010 icon that you’ve either pinned to the Windows Start menu (see “Pinning Excel to Start menu,” which immediately precedes this section) or that you’ve added as a shortcut to the Windows desktop (see the sections on adding an Excel shortcut to your Windows desktop for Windows 7, Vista, or XP that immediately follow this section for details) and drag and drop it into its desired position on the Windows 7 taskbar. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

After you pin a Microsoft Excel 2010 icon to the Windows 7 Taskbar, the button appears on the Windows taskbar each time you start your computer, and you can launch the Excel program simply by single-clicking its Quick Launch button. Some more details of advanced excel training courses in Rawalpindi  are as under.

Adding an Excel shortcut to the Windows 7 or Vista desktop:

Some people prefer having the Excel Program icon appear on the Windows desktop so that they can simply double-click the program icon to launch Excel. To create an Excel program shortcut for Windows Vista, follow these steps:

1.      Click the Start button on the Windows 7 or Vista taskbar. The Start menu opens.

2.      Click the Start Search text box on the Start menu and type excel.exe. Excel.exe is the name of the executable program file that runs Excel. After finding this file on your hard drive, you can create a desktop shortcut from it that launches the program.

3.      Right-click the file icon for the excel.exe file at the top of the Start menu and then highlight Send To on the pop-up menu and click Desktop (Create Shortcut) on its continuation menu. A shortcut named Microsoft Excel 2010 appears on your Windows desktop.

Adding an Excel shortcut to the Windows XP desktop:

If you’re running Excel 2010 on Windows XP, use the following steps to create a program shortcut for your desktop:

1.      Click the Start button on the Windows taskbar. The Start menu opens the Search item.

2.      Click Search in the lower-right corner of the Start menu. The Search Results dialog box appears.

3.      Click the All Files and Folders link in the panel on the left side of the Search Results dialog box. The Search Companion pane appears on the left side of the Search Results dialog box.

4.      Type excel.exe in the All or Part of the File Name text box. Excel.exe is the name of the executable program file that runs Excel. After finding this file on your hard drive, you can create a desktop shortcut from it that launches the program.

5.      Click the Search button. Windows now searches your hard disk for the Excel program file. After this file is found, its name appears on the right side of the Search Results dialog box. When this filename appears, you can click the Stop button in the left panel to halt the search. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join advanced excel training courses in rawalpindi

Launching and Quitting Excel

Excel 2010 runs under both the older Windows XP operating system and the newer Windows 7 and Vista operating systems. Because of changes made to the Start menu in Windows 7 and Vista, the procedure for starting Excel from these versions of Windows is a bit different from Windows XP. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

Starting Excel from the Windows 7 and Vista Start menu:

You can use the Start Search box at the bottom of the Windows Vista Start menu to locate Excel on your computer and launch the program in no time at all:

1. Click the Start button on the Windows taskbar to open the Windows Start menu.
2. Click the Search Programs and Files text box (called Start Search in Vista) and type the two letters ex to have Windows locate Microsoft Office Excel 2010 on your computer.
3. Click the Microsoft Office Excel 2010 option that now appears under Programs near the top of the Start menu. If you have more time on your hands, you can also launch Excel from the Windows Start menu by going through the rigmarole of clicking Start➪All Programs Microsoft Office➪Microsoft Office Excel 2010. Some more details about this field of advanced excel training courses in rawalpindi are as under.

Starting Excel from the Windows XP Start menu:

When starting Excel 2010 from the Windows XP Start menu, you follow these simple steps:

Click the Start button on the Windows taskbar to open the Windows Start menu.

 With the mouse, highlight All Programs on the Start menu and then click Microsoft Office on the Start continuation menu before choosing Microsoft Office Excel 2010 from the Microsoft Office continuation menu.

Pinning Excel to the Start menu:

If you use Excel all the time, you may want to make its program option a permanent part of the Windows Start menu. To do this, pin the program option to the Start menu:

1. Start Excel from the Windows Start menu. In launching Excel, use the appropriate method for your version of Windows as I outline earlier in this chapter. After launching Excel, Windows adds Microsoft Office 2010 to the recently used portion on the left side of the Windows Start menu.
2. Click the Start menu and then right-click Microsoft Office Excel 2010 to open its shortcut menu.
3. Click Pin to Start menu on the shortcut menu.

After pinning Excel in this manner, the Microsoft Office Excel 2010 option always appears in the upper section of the left-hand column of the Start menu. You can now launch Excel simply by clicking the Start button and then clicking this option. TSK is the best institute in Rawalpindi Islamabad who wants to join advanced excel training courses in Rawalpindi.

Adjusting to the Quick Access toolbar

When you start using for the first Excel 2010, the shortcuts bar contains only the following three buttons: Technical Data about this  field explained in  advanced excel training courses in Rawalpindi.

✦: Stores use the same file name, file format, and location of all modifications to the current workbook.

✦ Undo: Undo the last edit, format or layout change that you made.

✦ Redo: reapplied the previous edit, format or layout change that you just removed with the undo button.

The Quick Access toolbar is highly customizable, because you can easily add any Ribbon command. In addition, you are not limited to adding buttons for the commands on the tape; You can use any Excel command you want on the toolbar, the Add obscure, not evaluate an appearance on one of its tabs. (See Part I, Chapter 3, to adjust information on the Quick Launch bar.) Some more details about this field  advanced excel training courses in rawalpindi are as under.

By default, the Quick Access Toolbar directly from the file menu button and ribbon tabs. To display the toolbar below the ribbon on the formula bar, click (the drop-down button to the direct right of the toolbar is a horizontal bar above a downward triangle) on the Quick Access Toolbar Toolbar button click and then on Show Below the ribbon on the drop-down menu. This allows you to avoid pushing the name of the current workbook that is displayed on the right side toolbar.

Fooling around with the formula bar:

The formula bar displays the cell address and the contents of the current cell. The address of this cell, each indicated by the letter of the column (s), immediately followed by the line number as the first cell of each worksheet is at the intersection of column A and row 1, or cell XFD1048576, last determined in the cell A1 Excel 2010 worksheet at the intersection of column XFD and lines 1048576, the contents of the current cell are determined by the kind of input you definitely do there: text or numbers when you enter a heading or certain value, and the nuts and bolts of a formula when you enter a calculation there. The formula bar is divided into three sections:

✦ Name field: The leftmost section displays the address of the current cell address.

✦ formula bar buttons: The second, middle part only a recessed circle on the left side seems to be a rather inconspicuous button (used to narrow the field name or expand) ad by clicking Insert Function (labeled fx) on the right side until you start, or editing a cell entry. At this time, his, Cancel (X a) and the entry (a tick) buttons appear in between.

✦ cell contents: The third white area to the immediate right of the Wizard button function takes the rest of the bar and expands as needed to really appear really long cell entries that do not fit within the normal range. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad

 who wants to join advanced excel training courses in Rawalpindi.

The cell contents portion of the formula bar is really important, because it always shows the contents of the cell, even if the worksheet is not. (If you have to do with a formula, Excel displays only the calculated result in the cell in the worksheet and not the formula by which the result is derived.) You can edit the contents of the cell in this area. For the same reason, if the cell content area is empty, you know that the cell is empty.