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.

Sizing up the other Backstage View menu options

Immediately below the File menu button at the top of the menu lists the commands you use frequently to work with files Excel workbook as saving, opening and closing files. (See Book II, Chapter 1 for more to save and close files and Book II, Chapter 3, to open more of them. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

Below this file commands and the Info option, see a current command option that, when selected, displays a panel listing all Excel workbook files that you have opened for editing recently. You can use this list to quickly open a workbook that just another revision must double by its name. Some more details of advanced excel training courses in Rawalpindi are as under.

The latest option is followed by a new command, which when selected, displays a template available field. This panel shows a list of available spreadsheet templates on the left side with a preview of the layout of the currently selected on the right template. (See Book II, Chapter 1 for more information on creating and workbook templates.)

Under the new command, see the print option, which, when selected, a panel indicating print settings. This panel contains the current print settings for the document on the left side (which you can change), and a preview area that shows you on the pages of the printed worksheet report. (See Book II, Chapter

5 to Under pressure command, see more about printing worksheets, print settings panel in the Backstage view.) The Share option which, when selected, a transmission panel displays. This panel contains a list of commands used to share workbook files including e-mail to them, faxing, converting them into other more usable file types, and store them on the company SharePoint site. (See Book IV, Chapter 4, so that they convert more about email workbook files to other file formats and publish them online.)

Finally, at the bottom of the menu, see the Options button, you can choose the program settings by pressing an Exit button to change, you can choose, when you are ready to exit the program. (See Part I, Chapter 3 for more than 2010. Excel Customizing. 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.

Going behind the scenes to Excel’s Backstage View

Program selector and the Save button on the toolbar shortcut, click the File menu button (the green button rag same file name). When you click the File menu button, the new Backstage view appears. The display in this view contains a menu of options related to a column on the left side running down and, depending on the option selected files, includes some dishes both summary and more information command options. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

At first glance the File menu button may seem a tape tab may particularly in light of its rectangular shape and position immediately to the left of the Home tab of the initial tape. Note, however, that this important control file is technically a command button, which when clicked, directly to the Backstage view leads to a new screen. This screen has its own menu options, but does not contain command buttons on the tape. Some more details of advanced excel training courses in Rawalpindi are as under.

After clicking the button File menu to enter Backstage view, you can then this same button to return to normal spreadsheet view, or you can simply press the Esc key. Get the lowdown on the bulletin board:

The first time you click on the File menu, Excel select the Information option under the four menu options related files (Save, Save As, open and close) on the top of the menu and the information panel the left side of the information panel, you can find the three buttons following command:

✦ Protect book encrypt the file Excel workbook with a password to protect its content or the content of the file with a digital signature (see Book IV, Chapter 1 and 3, to learn more about the protection and the signing of his book check)
✦ Check for problems the document for hidden metadata (data file) and check the file access for people with disabilities and compatibility with previous versions of Excel (see Book IV, Chapter 3 for the use of this feature) to inspect Manage

✦ restore or delete versions draft has been saved with the AutoCorrect feature in Excel (see Book II, Chapter 1 for more information about using AutoRecover) versions
On the right side panel information, view a thumbnail preview of the original spreadsheet a list of different and various pieces of information about the file contains followed: 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.