->
Lynda - Database Clinic: MS Excel - 592494
Lynda - Database Clinic: MS Excel
The Database Clinic series shows how to plan, build, and optimize databases using different software. This course focuses on Microsoft Excel. While Excel doesn't offer traditional relational database management features, its table-based sheets, functions links, and powerful search and reporting features make it a great tool for learning the basics of database design. Join Curt Frye as he shows how to create a simple database, join data sets, search for records, and perform CRUD (create, read, update, and delete) operations. Plus, learn how to use Excel's calculations, PivotTables, functions, and formulas to gain deeper insights into your data.


Table of Contents

  • Introduction
  • 1. Data and Excel in Five Minutes
  • 2. Create a Database
  • 3. Join Two Datasets
  • 4. Search a Database
  • 5. Create, Read, Update, and Delete Operations
  • 6. Averages and Calculations
  • Conclusion
  • Lynda - Database Clinic: MS Excel


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss