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.