Google Sheets Bootcamp

Features

• Course 1: Data Cleaning in Google Sheets
  What is data cleaning and why is it important?
  Best practices for working with data in Google Sheets
  Formulas covering common scenarios when working with data in Google Sheets
  Tips and tricks, such as shortcut keys, to make your workflow more efficient
  Professional techniques for creating cleaned, orderly data sets for your analysis
  Two in-depth case studies that show all these techniques together, in the wider context of a real-world problem
• Course 2: Data Analysis with Google Sheets
  Understand and describe what your data tells you
  Predict what things might look like in the future
  Understand your customers to better serve them
  Discover what factors affect your business
  Best practices for doing all of this…and much, much more!
  TOPICS INCLUDE: Data Analysis framework, measuring data, hypothesis testing, correlation, linear regression, time series analysis, customer lifetime value, churn, retention and cohort analysis
• Course 3: Build Dashboards with Google Sheets
  Understand what dashboards are and why they’re so valuable
  Have the confidence to build your own dashboards with your own datasets, in Google Sheets
  Know what to include in your dashboards to maximize their impact
  Have the technical skills to manage advanced dashboard projects without feeling overwhelmed
  Create interactive dashboards, so colleagues and clients can view the data they want to see
  Understand and use best practices in Google Sheets, to avoid making the same mistakes I made
  Be confident using advanced formulas and pivot tables
  Use Apps Script to automate processes and make your dashboards work for you!

[box type=”download”]