What is Google Sheets Bootcamp?
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!