Google Sheet Botcamp by Ben Collins

Included in the Google Sheets Bootcamp course bundle:

✅ Three premium online courses

✅ Actionable, bite-size 5 – 10 minute video lessons teaching key topics

✅ Copies of all the raw datasets for you to follow along

✅ Copies of all the solution templates for your own use

✅ Access to the private course Facebook group for Q&A

✅ Certificate upon completion

Ok Google Sheet geeks! Here are the details of what you get in this bootcamp:

 3 courses | 146 videos | 46 templates

Each 5 – 10 minute video breaks down a particular topic in Google Sheets, and allows for quick referencing in the future. You can watch them in any order you like, spread them over a few weeks or months, or even binge watch them all today if you like!

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!

Business online course

Information about business:

Business is the activity of making one’s living or making money by producing or buying and selling products (such as goods and services).
[need quotation to verify] Simply put, it is “any activity or enterprise entered into for profit.
It does not mean it is a company, a corporation, partnership, or have any such formal organization, but it can range from a street peddler to General Motors.”

Having a business name does not separate the business entity from the owner, which means that the owner of the business is responsible and liable for debts incurred by the business.
If the business acquires debts, the creditors can go after the owner’s personal possessions.
A business structure does not allow for corporate tax rates. The proprietor is personally taxed on all income from the business.