office-winner

Windows - On either side of the spacebar, outside the Alt key, is a key with the Windows logo. Holding the Windows key down and pressing another key will initiate quite a few actions. Some of the more common are listed in the table below: + F to display Find: All Files + F1 to display Help + R to display the Run command + M to minimize or restore all windows + E to display Windows Explorer + Break to display System Properties + Tab to cycle through buttons on the task bar Shift + + M to undo minimize all windows to display the Start menu and then press U to display the Turn Off Computer menu, press U again (on laptops) or press S (on desktops) to Turn Off the computer. + D to quickly get to your Desktop [Thanks Charlotte!] If your computer has XP installed and you want to lock your computer when you walk away from it use + L . OK, I won't leave you hanging. Your

  Keyboard shortcuts specific to MS Excel Escape - Esc is used to back out of situations. When you find yourself in a place where you don't want to be, try the Esc key. In PowerPoint this key will stop a running slide show. The keyboard combination Ctrl + Esc will open the Start menu. www.officewin.blogspot.com F1 - While working in an application, depressing this key will bring up the applications help menu. If there is no open application F1 will open Windows Help . www.officewin.blogspot.com F2 - Choose this key to rename a selected item. Alt + Ctrl + F2 to open a new document in MS Word Ctrl + F2 to open print preview in MS Word (this is a toggle, tap the keys again to return to the edit page) www.officewin.blogspot.com F3 - Depressing this key will display the Find: All Files dialog box. 2 - Shift + F3 will change case in MS Word. Continue to press F3 ( with the Shift key depressed) to toggle through all choices. www.officewin.blogspo

Using Equations Use this guide to help create equations in Microsoft Excel. Learn about averages, functions, and writing your own equations. Step 1 - Preparing to enter an equation - You are ready to build your own function (an equation). There is a single keystroke that informs Excel of your intention. Press the equal key (=). If you can write the equation, Excel can perform the calculation. This module will deal with four simple functions; add, subtract, multiply and divide. Step 2 - Writing an addition equation - If you were to state the process for adding the numbers in column B it would be "six plus three." The equation could be written exactly like that ( =6+3 ) and Excel would display the expected answer, 9. However that equation would be useless if the numbers in either B2 or B3 were changed. When writing your own equation, use cell addresses. =B2+B3 When writing the equation, clicking in cell B2 displays B2 in the equation. If yo

Step 1 - Enter data - One of the principal reasons for using a spreadsheet is to perform calculations. To illustrate, we will begin by adding a column of numbers. This is from a class survey about the favorite ice cream flavor of a class. Caution : If you plan to ask Excel to add a column of numbers, make sure that they are numbers. If cell B2 contained "6 students" rather than just the number 6, Excel would read the entry as a word, not a number. Step 2 - Placing a function - In the example above the total of the column of numbers would naturally go in cell B10. Before placing a function (a built in equation) make sure the selected cell is where you want the function to go. From the Insert menu select function In the Paste Function pop-up window, select the Math & Trig category and scroll to the Sum function When you choose OK, the dialog box below

TAB Moves one cell to the right in Microsoft excel worksheet. SHIFT+TAB Moves to the previous cell in a worksheet. CTRL+TAB Switches to the next tab in dialog box. CTRL+SHIFT+TAB Switches to the previous tab in a dialog box. CTRL+1 Displays Format Cells dialog box. CTRL+SHIFT+L Use for filtering the column. E.g. If you have to set a couple of filters, you don’t have to revert back to full data, to clear each filter which is time taking. So just turn-off and turn-on the filters, by pressing CTRL+SHIFT+L twice and your work is done. CTRL+Arrow keys To select a group of cells. E.g. It is really tough when it comes to dealing with large data and using mouse for navigate database. So to make your work easier just rely on CTRL+arrow key combinations all the time to select a group of cells. ALT+ES – Paste Special > Values Pasting the value.E.g. When we apply any formula and want only value, we need to use copy and then paste special value. Often to ge

Creating Charts with F11 in Microsoft Excel To illustrate, look at the screen shot, which shows sales data broken down by zone. Select a cell in the table, and press  F11 . The result : Excel opens a chart sheet, a sheet in your workbook that contains a new chart. Screenshot // Creating Charts with F11 in Microsoft Excel Make a Quick Chart with F11 Step 1 - Open MS Excel and enter data from a simple survey Step 2 - put your cursor anywhere in the data. Using the example image above put your cursor in the white or yellow area (immediately to the right of, or below, the data) Step 3 - Press the F11 key to make an instant chart. Step 4 - Add a title and names for x-axis and y-axis by right clicking in the white area surrounding the chart and selecting Chart Options. Other changes could be made to the chart but this will let you begin using the chart with your class immediately. If your cursor was anywhere else when you pressed the F11 key your

CONVERT Show All Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? Syntax CONVERT ( number , from_unit , to_unit ) Number      is the value in from_units to convert. From_unit      is the units for number. To_unit      is the units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit. WEIGHT AND MASS FROM_UNIT  OR  TO_UNIT Gram "g" Slug "sg" Pound mass (avoirdupois) "lbm" U (atomic mass unit) "u" Ounce mass (avoirdupois) "ozm" DISTANCE FROM_UNIT  OR  TO_UNIT Meter "m" Statute mile "mi" Nautical mile "Nmi" Inch "in" Foot "ft" Yard "yd" Angstrom "ang" Pica (1/72 in.) "Pica" TIME FROM_U