Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I hope I'm in the right place. Please direct me else where if the is
a more appropriate forum. Some background: I work for a hospital and keep departmental work stats--ie # of patients treated, a database of doctors, patients, etc. I do this all in Excel. I am self taught and I am pretty good with it. To be sure, I went and took the MOS test in Excel and passed the expert level test. Not tooting my own horn, just trying to give you a feel for my ability. Everything feels disjointed. I have several different workbooks going. My goal: consolidate where possible, offer a clean, easy to use interface so management can "ask questions" of the databases easily (they are far from computer savy :) The hospital does not have MS Access on it's machines, so I want to maximize Excel's capabilities. How do I do that? SQL? OLAP cubes? Web Page Access? Where do I turn and what hardware/software obstacles do I face? I'm more than willing to invest the time/money for research and learning materials, but I need some real person input about what to do. Any suggestions you may have would be very appreciated. Thank you, Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
Step by step tell me cube root (2197) which I know is 13 | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |