I have created quite a few financial spreadsheets that work wonderfully.
However, even though they are more flexible and accurate than the
previous versions, i get negative comments about it's appearance. Does
any one have any links to screenshots, pdfs, or excel files that have
professional looking formats. I am trying to gather a few ideas, and as
you can probably tell i am not very artistic.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=551212

Some general guide:
1) use standard Windows-style dialogs and dropdown menu system.
2) use different color/font/size/bold for table row/column headings.
3) format of input cells, output cells different from those descriptive
cells.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================

"mattflow" wrote in
message ...

I have created quite a few financial spreadsheets that work wonderfully.
However, even though they are more flexible and accurate than the
previous versions, i get negative comments about it's appearance. Does
any one have any links to screenshots, pdfs, or excel files that have
professional looking formats. I am trying to gather a few ideas, and as
you can probably tell i am not very artistic.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile:
http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=551212

Here are some additional ideas:

Visit the Microsoft template site and look at the Excel templates for ideas.
They have a lot of examples that should give you ideas.

Change the fill color of all the cells to white (this gets rid of the grid
lines). Then you can change a color of an individual cell to highlight it
and add lines that will stand out more. For example, you can put a border
around an entire cell like a total to make it stand out.

Use different colors than the same standard ones. You'll actually need to
go to ToolsOptions and the Color tab to add them.

Increase your row height and your fonts from the default.

And one thing I like to do is fill a row with a color like teal and then
bring the row height down to something like 3 or 4. This makes a great
dividing line for sections.

Make sure everything is consistently formatted.






--
Linda Adams
http://www.hackman-adams.com
http://www.david-hedison.com


"mattflow" wrote:


I have created quite a few financial spreadsheets that work wonderfully.
However, even though they are more flexible and accurate than the
previous versions, i get negative comments about it's appearance. Does
any one have any links to screenshots, pdfs, or excel files that have
professional looking formats. I am trying to gather a few ideas, and as
you can probably tell i am not very artistic.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=551212

In today's competitive climate, proper business management and organization plans are crucial for companies that strive to maintain leading positions on the market. Apart from a substantial capital, company owners have to invest lots of time and effort in order to maximize the efficiency, profitability and exposure of their business. However, companies can nowadays achieve these goals with less effort and in a cheaper way by using properly designed spreadsheets. The right spreadsheet solutions allow companies of all shapes and sizes to achieve and maintain a prominent position on the market, optimizing and accelerating a wide range of specific business processes and task