Microsoft Excel

Sorted by:  

Powers and Roots in Excel 2007: The POWER and SQRT Functions

In Excel 2007, you use the POWER function to raise a number to a certain power, and SQRT to find the square root of a number. These functions are located with the Math & Trig functions on the Ribbon’s [more…]

Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions

Excel 2007 contains a number of built-in date functions that you can use in your worksheets. Three common date functions are TODAY, DATE, and DATEVALUE, and they can come in very handy when you're trying [more…]

Shortcuts for Moving the Cell Cursor in Excel 2007

Microsoft Office Excel 2007 offers a variety of keyboard shortcuts for selecting a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view [more…]

Printing Gridlines and Row and Column Headings in Excel 2007

In Excel 2007, you can print gridlines or row numbers and column letters on the page. Selecting these options results in a printout that closely resembles what you see on-screen. This feature is useful [more…]

Applying the Percent Style in Excel 2007

Many Excel 2007 worksheets use percentages to show interest rates, growth rates, inflation rates, and so on. When you apply the Percent Style format to a value that has already been entered in a cell, [more…]

Using Advanced Filtering in Excel 2007

You can specify complex filtering criteria in Excel 2007 and designate a specific area of your worksheet to manage your criteria selections when filtering table data by using advanced filtering methods [more…]

Formatting Chart Titles in Excel 2007

When you add chart titles, Excel 2007 uses the Calibri (Body) font for the chart title (in 18-point size) and the x- and y-axis (in 10-point size). To change the font used in a title, or to change any [more…]

Using Excel 2007’s Goal Seek Feature

The Goal Seek feature in Excel 2007 is a what-if analysis tool that enables you to find the input values needed to achieve a goal or objective. To use Goal Seek, you select the cell containing the formula [more…]

Sorting Excel 2007 Data on a Single Column

You may find data in an Excel 2007 worksheet easier to view if it’s sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]

Inserting Cells, Rows, or Columns in Excel 2007

If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several [more…]

Creating a Scenario Summary Report in Excel 2007

After using Scenario Manager to add scenarios to a table in a worksheet, you can have Excel 2007 produce a summary report. This report displays the changing and resulting values not only for all the scenarios [more…]

Printing an Excel 2007 Chart

Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]

Rotating Cell Data in Excel 2007

Use the Orientation button on the Home tab in Excel 2007 to rotate data in cells. You can rotate data clockwise, counterclockwise, or vertically. Use the Format Cells dialog box to set a more precise orientation [more…]

Changing the Default File Location in Excel 2007

When you first start using Microsoft Office Excel 2007, Excel wants to save files in the My Documents (Windows XP) or the Documents (Windows Vista) folder under your user name on your hard drive. So, for [more…]

Selecting Cells in Excel 2007

Before you can enter your worksheet data in Microsoft Office Excel 2007, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]

Fixing Capitalization with Excel 2007's UPPER, LOWER, and PROPER Functions

Excel 2007 includes several Text functions (such as UPPER, LOWER, PROPER, VALUE, TEXT, and DOLLAR) that enable you to perform operations on text entries in a worksheet. These functions are located in the [more…]

Deleting Cells and Data in Excel 2007

In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can [more…]

Rotating a 3-D Excel Chart

Admit it — 3-D charts in Excel look really cool! Working with 3-D charts in Excel requires merely a basic understanding of height, width, and depth. The 3-D View dialog box lets you change the 3-D settings [more…]

How to Insert a Hyperlink to a Different Cell in an Excel 2007 Workbook

You can insert a hyperlink in Excel 2007 that anyone can click to jump to a different cell in the current workbook. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic [more…]

How to Add Cell Borders in Excel 2007

In Excel 2007, you can add borders to certain cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group of the Home tab to add borders of varying styles and [more…]

Examining Investment Value with Excel 2007's PV and FV Functions

The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by [more…]

Using Drag and Drop in Excel 2007

Drag and drop is a mouse technique that you can use in Office Excel 2007 to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving [more…]

Working in Excel 2007’s Page Layout View

Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button [more…]

Referring to Values or Formulas in Other Cells in Excel 2007 Formulas

Linking formulas are formulas in Excel 2007 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [more…]

Customizing the Excel 2007 Quick Access Toolbar

The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar [more…]


Sign Up for RSS Feeds

Computers & Software