My company currently has a pricing model that was created using Lotus
Smartsuite. There are several hundred formulas and macros that run the model.
Since we are moving away from LOTUS to Microsoft products, we want to create
the same spreadsheet in Excel. Can someone recommend a good book that will
help build the formulas and reports? No VBA was used to build the
spreadsheet in Lotus, so I'm not sure if I'll need VBA in Excel. There are
also reports that are generated where the empty lines on the report don't
print. Any suggestions on where I should start and/or recommendations for
reference books?
--
Thanks!
Chris

You will get a different book recommendation from every person who responds...

I do not know of one which addresses the migration from Lotus to Excel...
Most of it should translate as is... For exceptions look for a specific book
or search the web.

To learn Excel I would recommend "Learn Excle 2007 from Mr Excel.pdf"

Also do visit Chip Pearson's site http://www.cpearson.com/excel/topic.aspx

"Chris" wrote:

My company currently has a pricing model that was created using Lotus
Smartsuite. There are several hundred formulas and macros that run the model.
Since we are moving away from LOTUS to Microsoft products, we want to create
the same spreadsheet in Excel. Can someone recommend a good book that will
help build the formulas and reports? No VBA was used to build the
spreadsheet in Lotus, so I'm not sure if I'll need VBA in Excel. There are
also reports that are generated where the empty lines on the report don't
print. Any suggestions on where I should start and/or recommendations for
reference books?
--
Thanks!
Chris