We Talk Coding
What the best resource for creating Excel Databases?
Books, websites, etc. I don't want to use access, I want to use excel for databases that I am creating, where can I learn the most sophisticated and up-to-date info on how to do it. Thanks! the template for a database, not the data. I know that there is a way to turn excel into a "database" type of file, I just don't know how. ANy information on wehre I may find this type of instructions, will be greatly appreciated. Thank you.
Public Comments
- Er, we're missing something here. Is the question where to get the best data? Or a classy way to set it up?
- Five sources for free Excel templates Please note that all templates offered by these sites are compressed. You’ll need software, such as WinZip or Attachment Opener, to unzip the files. •Matt H. Evans, CPA, CMA, CFM offers a listing of Excel templates gathered from around the Web. The site lists 55 templates, ranging from a spreadsheet to estimate the value of synergy in a merger and acquisition to a set of worksheets for evaluating financial performance and forecasting. http://www.exinfm.com/free_spreadsheets.html •Corporate Training Partners offers Excel templates that demonstrate business principles, like price and trend analysis. The five templates offered include one for calculating Net Present Value. http://www.cortrapar.com/ExcelTemplates.htm •L&M Business Designs, which produces custom Excel Templates, has some free and low-cost offerings. The 22 free templates include the newly added Calendar Maker and Telephone Database. Other templates range from $5.50 to $15 and can be purchased using PayPal for instant access. The site provides a free demo of many of the pay downloads. http://www.lmbusinessdesigns.com/freexceltemplates.htm •Dave Hawley offers Excel templates that illustrate the program’s features on his site, OzGrid.com. The templates highlight features such as Advanced Filter, Dfunctions, Choose, Vlookup, Validation, and Index. Hawley offers explanations for each template’s function, like the FormsControls download that contains “clever uses of Option Buttons and Conditional Formatting.” http://www.ozgrid.com/download/ •John Bayley offers three basic Excel templates among his list of free downloads: a time sheet, a telephone list creator, and weekly planner. Each template uses Visual Basic to fill in data or check that the form has been filled in correctly http://www.neptune.uklinux.net/office/ Hope these links might help and Good luck, http://amsterdam.blogs.ie/
