Tiplet expert tips & tech support

March 1, 2009

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

Filed under: applications,computer hardware,privacy & security,Windows — Tags: , , , — admin @ 9:00 am

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…)

February 10, 2009

Embedding or Linking Excel Worksheets in Word 2007 Documents

Filed under: applications,Windows — Tags: , , , — admin @ 9:00 am

by David Hakala

That impressive business plan or loan application of yours would sure look better if it had a spreadsheet embedded in it. There are two ways to embed Excel worksheet data in a Word document, and we are going to cover both of them. This article applies to Word 2007.

Data stored in a non-Word application’s format is called an Object. We will be working with Excel objects. You can embed an object in a Word document or link it to a Word document.
(more…)

Powered by WordPress