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.
(more…)
by David Hakala
Charts make boring worksheets interesting. They also convey lots of information at a single glance. The new ribbon bar in Excel 2007 makes it easier than ever to fill your workbooks and other documents with nifty charts of all kinds.
(more…)
by David Hakala
When you press the Enter key in an Excel worksheet, it normally drops you down to the next cell in the column. But it doesn’t have to be that way. Excel allows you to specify to which cell the selection goes after you press the Enter key, or whether the selection remains unchanged.
(more…)
by David Hakala
Sometimes you have a repetitive task that cannot be recorded by Excel’s macro recorder. Take, for instance, this fairly common example. You need to create a new worksheet, give it a name, place it at the end of all the tabs in your workbook, and save the updated workbook.
(more…)
by David Hakala
Suppose you are shopping for a car. You know your budget and you have an idea what interest rate you will have to pay. You want to play around with some “what if” scenarios to see what your monthly payments may be. This is where Excel’s interest calculation functions come in.
(more…)
by David Hakala
Suppose you have a database of company information and contacts. You want to use an Excel macro to copy addresses and such into different Word documents. How can you make Excel open a specific Word document into which information will be pasted?
Word’s mail merge feature is one solution. But if you are working with multiple Word documents, the mail merge trick won’t work. You will need something more complicated called Office Automation, which allows creation of macros that work with multiple Office applications and not just one, such as Word.
(more…)
Powered by WordPress