Using the NAME Function in Excel 97, 2000, 2002, 2003, and 2007

March 1, 2009

in applications,computer hardware,privacy & security,Windows

by David Hakala

Excel formulas may require a lot of arguments. It can be hard to remember that “12*4” means 12 monthly payments for four years. It might be easier to read your formula if that argument read, “12Months*Years”. Well, you can give arguments and cells easily remembered names in Excel.
Click to continue reading…

How to Create Charts in Excel 2007

in applications

Create charts in Microsoft Excel to add information and visual interest to your worksheets and presentations.

Read the full article

Change the Behavior of the Enter Key in Excel 97, 2000, 2002, 2003, and 2007

in applications

The Enter key in Microsoft Excel normally drops the cursor down to the next cell in the column, but by adding some code you can get the enter key to move to the cell location you choose.

Read the full article

Create new Worksheet from Master Using Macro in Excel 97, 2000, 2002, 2003, and 2007

in applications

Set Microsoft Excel up to perform a repetitive task even if Excel’s macro recorder won’t record it. A bit of code will allow a new worksheet to be created from a master.

Read the full article

Interest Calculation in Excel 97, 2000, 2002, 2003, and 2007

in applications

Use the Microsoft Excel PMT function to calculate interest. Change the variables to see different interest scenarios

Read the full article

Create Word Documents from Excel Macros

in applications

With Office Automation, you can create macros to make Excel open a Word document so information can be pasted into it.

Read the full article