Thread: Data Management

Hi Whizbang, the data is becoming more organized with each workbook I work on and they are starting to emulate psuedo databases. I am like yourself, not an expert (yet) on this but I think that I will wind up creating database tables as I create or refine Excel workbooks. I really like the presentation aspects of Excel so I think you have it right when you say to store in Access and report in Excel.

Of course with Excel 2010 you have PowerPivot and you can do all sorts of fun stuff, such as querying data in Access, Excel and elsewhere simultaneously.

Originally Posted by romperstomper

Of course with Excel 2010 you have PowerPivot and you can do all sorts of fun stuff, such as querying data in Access, Excel and elsewhere simultaneously.

That would be great to get to know, if only the company I worked for used 2010. We are supposed to go to 2007 next month and I have a feeling that I am going to be the "goto guy" in my department for that (even though I don't currently use it). Good Times!