Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data gathering and reporting
I need to gather some analysis from various different colleagues on a daily
basis for a period of two weeks. I am looking for a simple way/format I can use. I have 4 different fields of required information and up to two criteria per field. This information will then need to be analysised and reported. Have you any suggestions for a professional look and a format that will be easily to analysis? Many thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data gathering and reporting
With just the limited amount of information you gave, we can't supply too
much help. Some general ideas: 1. Don't go crazy with colors. If you choose to color cells, no more than 3. (Generally used for danger/caution/good) 2. Draw attention to what is important, and only what's important. Not everything needs to be bold. 3. If information is line-based, consider using cell borders. Makes it easier to "read across" and follow information. 4. Consider using conditional format on your criteria fields. Fairly simple to setup, yet provides an added touch of style. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eán" wrote: I need to gather some analysis from various different colleagues on a daily basis for a period of two weeks. I am looking for a simple way/format I can use. I have 4 different fields of required information and up to two criteria per field. This information will then need to be analysised and reported. Have you any suggestions for a professional look and a format that will be easily to analysis? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gathering data using a form | Excel Discussion (Misc queries) | |||
Gathering data from worksheet | Excel Discussion (Misc queries) | |||
Gathering Data from Another Workbook | Excel Discussion (Misc queries) | |||
Gathering Survey data | Excel Discussion (Misc queries) | |||
gathering data | Excel Discussion (Misc queries) |