[Lynda] Database Clinic: MS Excel

Author
Tags: , , [esi post-views cache="public" ttl="0"]

image of author Curt Frye Curt Frye

Released

6/27/2017

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.

Topics include:

  • Creating a database in Excel
  • Joining two data sets
  • Searching a database in Excel
  • Importing and formatting text in an Excel database
  • Creating a PivotTable from two data sources
  • Calculating averages and percentages
Skill Level Intermediate

1h 52m

Duration

65,990

Views
Show More Show Less
Size: 339.02M

 

https://www.lynda.com/Excel-tutorials/Database-Clinic-MS-Excel/592494-2.html.


Friendly Websites

OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum.


2 thoughts on “[Lynda] Database Clinic: MS Excel”

Leave a Comment


Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.