Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Design
Hello,
I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly |
#2
|
|||
|
|||
Design
I think that would depend on what it would be used for , Inventory,
calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have their own needs as to how you would design your spreadsheet, so that it suits the best of your needs. " wrote: Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly |
#3
|
|||
|
|||
Design
Ok, so what I want to do is create a spreadsheet that would allow me to keep
track of response for individuals. What approach should I start out with? Kelly -- "ufo_pilot" wrote: I think that would depend on what it would be used for , Inventory, calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have their own needs as to how you would design your spreadsheet, so that it suits the best of your needs. " wrote: Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly |
#4
|
|||
|
|||
Design
This may be off course, but, if you are planning to record personal
information you *may* need to register. If you're in the UK, that will be the Information Commissioner. You'll find more information at www.informationsommissioner.gov.uk. Regards. Bill Ridgeway Computer Solutions " wrote in message ... Ok, so what I want to do is create a spreadsheet that would allow me to keep track of response for individuals. What approach should I start out with? Kelly -- "ufo_pilot" wrote: I think that would depend on what it would be used for , Inventory, calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have their own needs as to how you would design your spreadsheet, so that it suits the best of your needs. " wrote: Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly |
#5
|
|||
|
|||
Design
Search in Google for Spreadsheet Design, and you'll find lots of
resources. For example, this pdf file has some good tips: Spreadsheet Design & Auditing Tips http://faculty.fuqua.duke.edu/~peckl...tTips20001.pdf wrote: Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Design
Something that helps me is to start off with pencil and paper and think
about how I would map that data with only a couple of individuals/table entries. This gives me the rudimentary concept that I can replicate in a blank worksheet and then expand to the larger matrix. Does that make sense? Somehow, I can "see" the matrix more easily with just a couple of items. --------------------------- " wrote in message ... Ok, so what I want to do is create a spreadsheet that would allow me to keep track of response for individuals. What approach should I start out with? Kelly -- "ufo_pilot" wrote: I think that would depend on what it would be used for , Inventory, calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have their own needs as to how you would design your spreadsheet, so that it suits the best of your needs. " wrote: Hello, I have been working through serveral lessons within a workbook course but the problem that I am having is when I want to setup my own spreadsheet outside of the workbook I have problems with doing that. What type of approach should I take with designing a spreadsheet. Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Design complicated form | New Users to Excel | |||
Template design and consolidation | Excel Discussion (Misc queries) | |||
how to turn off design mode | Excel Worksheet Functions | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |