How to Create a Database in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 6

  • @saifmahmoodpersonel
    @saifmahmoodpersonel 3 หลายเดือนก่อน +3

    hello mam ,
    can you please tell me, how you create this video for youtube
    or which softwear you use to create or edit videos for youtube.
    and thanks for your valuable videos.

    • @exceldemy2006
      @exceldemy2006  3 หลายเดือนก่อน

      Hello @saifmahmoodpersonel,
      Thank you so much for your kind words and support! I'm thrilled to hear that you find our videos valuable. It's great to hear that you have an interest in making videos for TH-cam.
      creating and editing videos involves a few different steps, including screen recording, editing, and adding enhancements. There are various tools available that can help with these tasks. Thanks again for watching, and feel free to ask more questions! Happy learning!
      Regards
      ExcelDemy

  • @kotso28
    @kotso28 6 หลายเดือนก่อน +1

    Links to create both SEARCHABLE and RELATIONAL databases?

    • @exceldemy2006
      @exceldemy2006  6 หลายเดือนก่อน +1

      Hello @kotso28,
      Here are the links to create a searchable and relational database.
      To create a searchable database follow this article:
      www.exceldemy.com/how-to-create-a-database-in-excel/#searchable
      To create a relational database follow the article given below:
      www.exceldemy.com/how-to-create-a-database-in-excel/#relational
      You also can watch this video:
      th-cam.com/video/Ztg2671daCg/w-d-xo.htmlsi=NCMYMU6sTU7hX2YS
      Regards
      ExcelDemy

  • @edimathomas-cr4km
    @edimathomas-cr4km ปีที่แล้ว +4

    This is not the same as an actual database you would create in SQL or Microsoft Access. This is just regular Excel tables turned to Pivot Tables. Not the same thing.

    • @exceldemy2006
      @exceldemy2006  ปีที่แล้ว +4

      Hi there! Thanks for sharing your thoughts. You're right; Excel Pivot Tables are great for ad-hoc data analysis and quick visualizations. In contrast, SQL databases and Microsoft Access are better suited for scalable, long-term data management.
      Both have their strengths and weaknesses. Ultimately, it's essential to choose the right tool based on the task at hand.
      Regards,
      Exceldemy Team!