- [Instructor] Our task is to discover…and display the population count,…and educational attainment,…of California residents up to and including the year 2060.…In this movie, I will import the data sets,…and take the first steps that we need…toward performing our analysis.…The sample file that I'm working from…is an otherwise blank Excel workbook called…the Cohort Analysis.…You can find it in the chapter six folder…of the exercise files collection.…One of the data sets we're working with…is extremely large, at least in terms of excel.…

It has over 3,600,000 rows.…That means that we need to use Power Pivot.…If you look on the ribbon,…on my version of Excel,…you'll see that I have Power Pivot enabled.…Power Pivot is available in Office 2016 professional.…If you have Office 2016 Professional,…but don't see the power pivot tab,…go to the file tab on the ribbon,…then click Options,…click Advanced, and then scroll down…to the data area which is here,…and you'll want to see…the enable data analysis addins checkbox checked.…

Resume Transcript Auto-Scroll

Author

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.