How to 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.

Just updated your iPhone? You'll find new emoji, enhanced security, podcast transcripts, Apple Cash virtual numbers, and other useful features. There are even new additions hidden within Safari. Find out what's new and changed on your iPhone with the iOS 17.4 update.

4 Comments

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.
www.theprospectingplugin.com/Presentation.html
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