Microsoft Excel

View:  
Sorted by:  

How to Automate Tasks with Macros in Excel 2007

You can use macros in Excel 2007 to save time by automating tasks that you perform frequently. A macro is a series of commands grouped together that you can run whenever you need to perform the task. [more…]

Querying an Access Database Table in Excel 2007

Excel 2007 can import data from an Access 2007 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]

How to Run an Excel 2007 Macro

After you record a macro in Excel 2007, either by using the macro recorder or by creating it in Visual Basic for Applications (VBA), you run the macro to have it carry out the commands and keystrokes that [more…]

How to Import Online Data into Excel 2007 with a Web Query

In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new [more…]

How to Add Records to an Excel 2007 Table

After you’ve created an Excel 2007 table (using the Table button on the Insert tab), you can choose from several methods for adding records to the table. Before you add records, the range must already [more…]

How to Build Excel 2007 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. The dialog box not only helps you locate the proper function for the task at hand but [more…]

Saving and Using an Excel 2007 Macro-Enabled Workbook

When you're working with macros in Excel 2007, you save and open workbooks in a new macro-enabled workbook format (.xlsm) that provides added security. When you create a macro, you must use this format [more…]

How to Print Formulas in an Excel 2007 Worksheet

A basic printing technique you may need in Excel 2007 is how to print the worksheet formulas instead of printing the calculated results of the formulas. You can check over a printout of the formulas in [more…]

Adding a Standard Header or Footer in Excel 2007

Headers and footers typically appear on every page of a report. In Excel 2007, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to [more…]

Finding Commands on the Excel 2007 Ribbon Tabs

The Ribbon in Microsoft Office Excel 2007 contains seven tabs. Contextual tabs also appear when you’re working with a particular object that you select in the worksheet, such as a graphic image, chart, [more…]

Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR

The DAY, WEEKDAY, MONTH, and YEAR date functions in Excel 2007 all return parts of the date serial number that you specify as their argument. You can access these functions on the Date & Time command button’s [more…]

Freezing Panes in an Excel 2007 Worksheet

The Freeze Panes command in Excel 2007 enables you to freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in [more…]

Choosing the Right Chart Type in Excel 2007

When you display your data visually in Excel 2007, choosing the right type of chart is just as important as deciding to use a chart at all. Different charts display the data in very different ways. Using [more…]

How to Move or Copy Excel 2007 Worksheets to Other Workbooks

In Excel 2007, you may need to move or copy a particular worksheet from one workbook to another. You can use the Move or Copy dialog box to simplify the process. To move or copy worksheets between workbooks [more…]

How to Add a Background Image to an Excel 2007 Worksheet

You can add a graphic image to the background of an Excel 2007 worksheet. The background image (sometimes called a watermark) should be very light in color or use a greatly reduced opacity in order for [more…]

Document Recovery in Excel 2007

Excel 2007 offers a document recovery feature that can help you if a computer crashes due to a power failure or some sort of operating system freeze or shutdown. Excel's AutoRecover feature saves your [more…]

Filtering an Excel 2007 Pivot Chart

Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [more…]

How to Insert Symbols and Special Characters in Excel 2007

Excel 2007 makes it easy to enter symbols, such as foreign currency indicators, as well as special characters, like trademark and copyright symbols, into Excel's cells. These symbols are available in the [more…]

Figuring Out the Excel 2007 Formula Bar

The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]

Calculating Loan Payments with Excel 2007's PMT Function

Excel 2007's PMT function calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant rate of interest. The PMT function uses the following syntax: [more…]

Working with the Comma Style in Excel 2007

The Comma Style format (also known as the thousands separator) in Excel 2007 often accompanies the Accounting number format. Like the Accounting format, the Comma format inserts commas in larger numbers [more…]

Using Functions in Excel 2007 Formulas

In Excel 2007, functions are like built-in formulas that perform simple to complex tasks. For example, the SUM function sums up numbers, the COUNT function counts, and the AVERAGE function calculates an [more…]

How to Create a Two-Variable Data Table in Excel 2007

To create a two-variable data table to perform what-if analysis in Excel 2007, you enter two ranges of possible input values for the same formula: a range of values for the Row Input Cell in the Data Table [more…]

Fixing Broken Formula Links in Excel 2007

Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot [more…]

Naming a Cell or Range in Excel 2007

Assign a descriptive name to a cell or range in Excel 2007 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of [more…]

Listings:1-2526-5051-7576-100more...

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com