Things You Can Do With Excel by runout


									                                                           Other Great Things

                                 Things You Can Do Wuth Excel

                                       Stop Here
 Move F                                  Then

Copy J

            1              2
            5             10

    100               200        300         400     500          600                700     800     900    1,000

     6          Martha
     8          Mary
     3          Joy
     7          Melissa
     9          Laurie
     2          Ola
     1          Pati
     5          Linda
     4          Serita

    Jan            Feb         Mar       Apr       May          Jun            Jul         Aug     Sep     Oct      Nov          Dec

Now let's see how to customize your toolbars or create new ones.

UMD-ITSS                                                              Page 1                                              Mary Olson-Reed

                          OTHER GREAT THINGS YOU CAN DO WITH EXCEL

    1.   With A1 as the active cell, click on the spell checker button. It is to the left of the
         "scissors" Cut button. Change the misspelled "Wuth" to "With".

    2.   Put your cursor on cell A3. Point the mouse to one of the four sides of the cell (but not
         the lower right corner). The pointer shape should change to an arrow. Click and hold
         the left mouse button, and drag the cell over to cell D3. Excel will ask you if you want
         to replace the contents in the destination cell. Click the OK button. Now click the "Undo"
         button (next to the paintbrush) on the standard toolbar. The Undo button can save you
         many heartaches, in fact you can undo up to the last 16 actions performed.

    3.   Now go to cell A5. The quickest way to copy something is to use the "copy handle",
         which is located in the bottom right corner of the active cell. When you put the mouse
         pointer over the handle, the "fat plus sign" changes to a "thin plus sign". Click and hold
         the left mouse button and drag across to the right into the next few cells.

    4.   Go to cell A7 and again use the copy handle. Drag across to G7.
         Repeat with cell A8, repeat again with cell A9, and one more time with cell A10.

    5.   Before you do the same thing with cell A11, ask yourself what will happen when you
         use the copy handle and drag across. Now try it.

    6.   Now select the range of A12.B12 and again grab and pull the copy handle. Now you
         have established a pattern that Excel will recognize and repeat.
         Do the same thing using the cells A13.B13.

    7.   Notice that row 15 has a sequence of numbers, but the first one is formatted to look
         quite different. It has a black border surrounding a red background, with a green font
         color, and the number centered in the cell. Assume that you wanted the other
         numbers on that row to look the same. With your cursor on cell A15, click on the
         "format painter" button (looks like a paintbrush) on the top toolbar. Now drag across
         the range of cells B15.G15. Notice that this is not the same as using the copy button,
         (i.e. the numbers didn't change, only the formatting was copied).

    8.   Now scroll down so that you can see the set of numbers in the range of A17.A25.
         Select the range using your mouse. Now click on the "sort ascending" button on the
         top toolbar (A-Z). Now click on the "sort descending" button. Follow the same
         procedure for the names in the range B17.B25.

    9.   Row 27 has the twelve months of the year listed, stretching across to column L.
         In some cases, it might be helpful to able to see all of these columns on the screen at
         once. Locate the "Zoom Control" drop-down box that currently says 100%. Choose
         the 75% option. Then choose the 50% option. You can also type in any percentage
         that you might want, such as 70. NOTE: this zoom controlchanges the screen
         display, but it does not change the printing setup.

    10. For the following instructions, type the words as shown, but NOT the quote marks.
        On row 29, type the word "tuesday", without capitalizing the first letter.

UMD-ITSS                                            Page 2                                     Mary Olson-Reed

        On row 30, type the word "WEdnesday", and capitalize both of the first two letters.
        On row 31, type the word "acheive", and put the "e before the i" in the middle.
        On row 32, turn on Caps Lock, then type "mINNESOTA" as shown here.
        On row 33, type the words "Coca-Cola(tm)".
        Click on Tools, AutoCorrect on the main menu.
             Notice the check boxes that are available.
             In the Replace box, type in "mp", and in the With box, type "Minnesota Power"
             In the Replace box, type in "umd", and in the With box, type "University of MN-Duluth"
        Now go to row 34, and type the following: "mp employees go to umd."

    11. With this file still open, let's take a look at customizing the toolbars that appear on the
        screen. Some of the buttons may be of little or no use to you, these can be removed
        from the toolbar (you can always get them back if needed). A few other buttons that
        you do not currently have available might be of great use to you. Let's get rid of some
        of the buttons and add some others.

        NOTE: you will want to perform these customization procedures on your own computer.
        Customized toolbars are NOT saved along with a file, they become part of the Excel
        program memory and will be available only when you are working on the same computer.

UMD-ITSS                                          Page 3                                     Mary Olson-Reed

To top