How To: Use Microsoft Excel as a database

Use Microsoft Excel as a database

How to use Microsoft Excel as a simple database and how to organize and sort data on the fly.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Other worthwhile deals to check out:

Join the Next Reality AR Community

Get the latest in AR — delivered straight to your inbox.


Very helpful and clearly explained but the volume level was too low (could not hear it in a public place or when my a/c was running) Overall: A

Same here djmejia..A+ though.

helpful for people who already know how to make a spreadsheet...
volume too low and visibility of what you showed is blurred.

Think you can use Excel even better than this. Check out this flash presentation to see the art of the possible.
Excel is hidden and a form opens automatically that interacts with the Excel workbook. Using Excel formulas you can write to/from cells to mimick the functionality of an Access Database. If you want to create something similar look into advanced Excel functions like Index, Match, Vlookup, etc.

Share Your Thoughts

  • Hot
  • Latest