« SQL SERVER Tutorial – T-SQL: Left Outer Join – Right Outer Join – Full Join – Combining Join
IEFD Ep. 11 – Website Hacking – Sql Injection Part 2 »

Microsoft Excel #04: Excel as a Database

I use Excel as something of a simple database. I use it to keep track of movies, collectibles, etc. because I like the interface, the ease of organizing data, and the ability to filter data on-the-fly with AutoFilters and Sorts.

Duration : 0:4:19


[youtube 5gCyIdagkyQ]

This entry was posted on Thursday, August 27th, 2009 at 7:20 am and is filed under database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

25 Responses to “Microsoft Excel #04: Excel as a Database”

  1. davemaciasarch on August 27th, 2009 at 7:20 am

    Lets say you have a …
    Lets say you have a typical Microsoft excel sheet and on the bottom you have standard table. You have 5 rows vertically on the left of job codes, like (1-engineering) (2-coordinating) (3-support) (etc). And five columns horizontal on top of building floors, like (1st floor) (2nd floor) (3rd floor) (etc). And above that whole table you have a simple time sheet layout consisting of 4 cells running horizontal as follows Date , floor level , job code, and hours

  2. great video
    great video

  3. it’s helpful, …
    it’s helpful, thanks you!

  4. awesome vids…. …
    awesome vids….casual but professioanl at the same time, which = talent!!! whts good abt them is tht they’re not too short or too long, the vid lenght is just right…

  5. the sound is …
    the sound is perfect for me

  6. You are a great …
    You are a great teacher. Thank you!

  7. MissusFingerBottom on August 27th, 2009 at 7:20 am

    great tutorial!!
    great tutorial!!

  8. Hi, awesome videos! …
    Hi, awesome videos! They are really helpful but the sound is a little low…just an FYI. Thanks a million, you’re a great teacher. :)

  9. Again, thanks every …
    Again, thanks every so much.

  10. 20RoyalSuperKing on August 27th, 2009 at 7:20 am

    Great vid , but 3 …
    Great vid , but 3 words data protection act

  11. good job thanks
    good job thanks

  12. Access does kind if …
    Access does kind if suck.

  13. I stumbled onto …
    I stumbled onto your video series and what a goldmine of information! I was debating using either Access or Excel to capture some basic information. Thank God I saw your demo. Saved me tons of time. Thanks.

  14. Your video is …
    Your video is excellent. I love it. I sum up my opinion of excel and access in 4 words.
    Excel-Awesome;Access-Evil!

  15. This is fantastic!!!
    This is fantastic!!!

  16. good stuff cheif! …
    good stuff cheif! keep it up!

  17. nice video,, really …
    nice video,, really helpful,, keep it up

  18. good work and i do …
    good work and i do love to work with excel rather than with access. Excel is more freindly to work with . you can do wonders with it . I have created a small s/w using excel and vba . its very simple program …soon will post that in youtube…..

  19. great videos . keep …
    great videos . keep it up!

  20. ok
    it is for …
    ok
    it is for science fair but i have a back up plan.

  21. Sorry it took so …
    Sorry it took so long. I am going through all 97 of my videos looking for requests and I am making a list. I’ll do what I can.

  22. Sorry it took so …
    Sorry it took so long. I am going through all 97 of my videos looking for requests and I am making a list. I’ll do what I can.

  23. hey im having …
    hey im having trouble with an equation that involves LOG and some other stuff for exponential functions. things you find on scientifical calculators.
    would you happen to have a video on functioning?

  24. ¡Gracias, Señor!
    ¡Gracias, Señor!

  25. Very good !!
    You …
    Very good !!
    You rock Dude!! You just save me a lot of time :-)
    Greetings from Mexico

Leave a Reply