Course details
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.
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Instructor
-
Curt Frye
Online course developer, freelance writer, and speaker. MBA.
Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences. Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.
Skills covered in this course
Viewers of this course
Welcome
- [Instructor] When you think about database tools, you don't always think about Microsoft Excel, and that's too bad, because, for better or worse, Excel is one of the most popular database applications in the world. Hi, I'm Curt Frye, and in this course, we're going to look at common database problems, and how Excel can be used to address them. We'll look at creating a database and importing data, cleaning up and transforming data in Excel, searching through data for specific values, and calculating values based on data from multiple sources. This course is a part of the database clinic series, where experts are given the same challenges and asked how their tool of choice can be used to address them. You can watch just this course, if you want to learn how Excel can be used as a database tool, or, if you like, you can watch the different courses in this series to compare the features and advantages of each of these different tools. Let's get going.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.