How to Use Excel 2007

Microsoft Excel is a interactive digital spreadsheet application that is included in the Microsoft Office 2007 package, the latest Windows version of Microsoft Office. The application is easy to use but has a variety of features and options, including data analysis and display. Microsoft Excel uses a grid of cells to make up its spreadsheets, the columns labeled with letters, and the rows labeled with numbers.

Things You'll Need

  • Microsoft Excel 2007
  • Computer

Instructions

    • 1

      Enter text or numbers into a cell by clicking in the cell, typing the desired text, and press "Enter." Press "Tab" to move to the next cell.

    • 2

      To insert a row of cells into your spreadsheet, select where you wish your new row to be, click the Home tab and the "Insert" button, and then click "Insert Sheet Row." Create a new column by clicking "Insert Sheet Column" under "Insert."

    • 3

      To merge multiple cells together, either vertically or horizontally, select the cells you wish to merge, and click "Merge Cells," which appears under the "Merge and Center" button in the Alignment group under the Home tab.

    • 4

      Add two or more cells together by first clicking in a cell. Type "=SUM(" (open parenthesis), and enter the cells you wish to be added together, followed by ")" (close parenthesis). For example, =SUM(F4,F5,F6) would add the values of cells F4, F5 and F6. Write a long list of cells quickly by entering the starting cell of a row or column, typing ":" (colon), and entering the ending cell, for example, F4:F13. Use calculation operators to multiply, divide, add, subtract, or exponentiate multiple cells. For example, a cell with the formula =B7/B3 would divide the value in B7 by the value in B3.

    • 5

      Use a variety of functions to fit your needs. Click the "Insert Function" button on the formula bar to pull down a long list of functions, and click the function you want. To average two or more cells, go down to AVERAGE, and type the cells you wish to average, between parentheses.

Tips & Warnings

  • Make sure that you always enter an equal sign before writing a formula in a cell.
Related Searches

References

  • Photo Credit http://www.contrib.andrew.cmu.edu/~jisukwak/Excel_2007.jpg

You May Also Like

  • How to Use Vlookup in Excel 2007

    If you use Excel frequently, sooner or later you are going to need to look up values in a table. Instead of...

  • How to Use Microsoft Office Excel 2007

    Microsoft Office Excel has lots of different applications and uses, such as making spreadsheets, budgets, and invoices. The program allows you to...

  • How to Use Macro in Excel 2007

    Excel macros are units of executable code that you can use to easily eliminate tasks in Excel 2007. The Excel macro function...

  • How to Use Excel

    Microsoft Excel is primarily used to create spreadsheets that are split up into rows and columns. Highlight headers or make text bold...

  • How to Print in Excel 2007

    Microsoft Excel is one program included in the Microsoft Office suite. While using Excel, many users waste a lot of paper printing...

  • How to Do Excel Formulas

    How to Do Excel Formulas. ... Select the function you want to use. Excel 2007 provides a list of commonly used functions...

  • How to Use Excel As a Database

    Freeze the heading row. Use the freeze pane feature so that your headings will always appear at the top of the database....

  • How to Select Visible Cells Only in Excel 2007

    In Microsoft Excel 2007, when you try to select or copy cells in a range, cells that are hidden or filtered within...

  • How to Use the Chart Wizard in Excel 2007

    Using charts in Excel creates colorful, visual displays of facts and figures which can be used in a PowerPoint or other presentation....

  • How to Filter in Excel 2007

    If you frequently use Microsoft Excel 2007, you might find yourself regularly looking at spreadsheets that contain a great deal of repeated...

  • How to Create a Form Using Mircosoft 2007 Excel

    Excel 2007 is a spreadsheet program from Microsoft, sold as part of the Office 2007 productivity suite released in late 2006. In...

  • Excel 2007 Help

    It has happened to everyone at one time or another. You are working with Microsoft Excel 2007, and you can’t figure out...

Related Ads

View Blog Post

Enter the Geek Vs Geek Giveaway and Win a Roku!