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 Graph Using Excel 2007

    Microsoft Excel 2007 has several different charts and statistical graphs that you may use to present your data in a graphical format....

  • 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....

  • Microsoft Excel 2007 Instructions

    Microsoft Excel is spreadsheet software that you can use to organize data and perform calculations. Excel can track trends, perform calculations (automatically,...

  • How to Create a Form Using Microsoft 2007 Excel

    If you need to enter a great deal of information into an Excel worksheet or are creating a table in Excel into...

  • How to Do Percentages in Excel From MS Office 2007

    Microsoft Excel 2007 enables you to manage data using various objects including tables, charts and formulas. Excel performs simple calculations such as...

  • How to Use Bullets in Excel 2007

    Bullet points indicate items in an unordered list. Microsoft Excel 2007 does not have many of the text formatting controls that you...

  • 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 Learn Microsoft Excel 2007

    Microsoft Excel 2007 is part of a Microsoft Office productivity suite release. With new releases, Microsoft often adds new features or changes...

  • 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...

  • How to Use Microsoft Excel 07

    If you have been using previous versions of Microsoft Excel, such as 2003, XP or 2000, making the transition to Microsoft Excel...

  • How to Use Excel for XP

    How to Use Windows XP Recovery Console. ... File compatibility is limited between Microsoft Office Excel 2007 and Microsoft Works.

  • 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

Check It Out

Should Microsoft Be Allowed to Force You to Upgrade?