Revisit spreadsheets where you will look at formulas for basic calculations, then take a look at pivot tables, and how queries and calculations go hand-in-hand in SQL.

0:00 Data Calculations
2:43 Common Calculation Formulas
12:58 Functions and Conditions
21:36 Composite Functions
27:18 Working with Pivot Tables
40:20 Queries and Calculations
44:32 Embedding Simple Calculations
52:14 Working with Other Statements
56:34 Validate Everything
1:02:15 Time for Temporary Tables
1:08:56 Variations of Multiple Tables

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ► https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
► No experience necessary: Learn job-ready skills, with no college degree required.
► Learn at your own pace: Complete the 100% online courses on your own terms.
► Stand out to employers: Make your resume competitive with a credential from Google.
► A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics