Exploratory Data Analysis in Spreadsheets

Spreadsheets are a great tool for quickly exploring data, and this training covers techniques for rapidly extracting insights from a new dataset. You'll explore Fortune 500 data, creating summary statistics, pivot tables, and visualizations to identify patterns and trends in the world’s largest businesses. Key Takeaways: - Learn to implement exploratory data analysis techniques in Google Sheets. - Learn to write spreadsheet formulas for data analysis. We will in particular learn these: XLOOKUP, FILTER, SUMIF, COUNTIF as well as Pivot Tables and Charts. - Learn how to organize your spreadsheets to communicate your results. Code-along with us! https://bit.ly/3PiE4yP Solution Sheet: https://bit.ly/3EKEmte Dataset: https://bit.ly/3retrVI [SKILL TRACK] Spreadsheet Fundamentals: https://bit.ly/3sVy3AA [SKILL TRACK] Finance Fundamentals in Spreadsheets: https://bit.ly/46dyXqA [SKILL TRACK] Excel Fundamentals: https://bit.ly/464czQm [CHEAT SHEET] Data Manipulation in Excel: https://bit.ly/3sRCgoV [CHEAT SHEET] Excel Formulas: https://bit.ly/3LlItQr [INFOGRAPHIC] Data Science Learning Checklist: https://bit.ly/3LlItQr [TUTORIAL] Visualizing Data in Excel: https://bit.ly/3Rno8hu [TUTORIAL] How to Create a Dashboard in Excel in 3 Easy Steps: https://bit.ly/3Lrgmzk [TUTORIAL] The 15 Basic Excel Formulas Everyone Needs to Know: https://bit.ly/3RjGfF1 [TUTORIAL] Working with Pivot Tables in Excel: https://bit.ly/46aj7wM [PODCAST] Do Spreadsheets Need a Rethink? With Hjalmar Gislason, CEO of GRID: https://bit.ly/3ZlrVh1 Introducing Python in Excel: The Best of Both Worlds for Data Analysis and Visualization: https://bit.ly/3EMqjmZ Extending Google Sheets: https://bit.ly/3EKPiXO