Do you take care of badly formatted information that takes you hours to tidy up, stopping you from making progress in your “real” work? Do you ever end up repeating a course of manually, like extracting a zipper code from an deal with?…
Ben Collins – Google Sheets Training Bundle
2 COURSE BUNDLE: Information Cleansing & Pivot Tables in Google Sheets + Construct Dashboards with Google Sheets
Improve your Google Sheets expertise with this course bundle, overlaying the whole information workflow, from coping with uncooked information by to creating stunning stories.
This bundle consists of:
- Information Cleansing and Pivot Tables in Google Sheets
- Construct Dashboards with Google Sheets and Information Studio
The retail value for these two programs is $298 ($99 and $199 respectively), so this bundle represents excellent worth to your Google Sheets coaching wants.
Course 1: Information Cleansing and Pivot Tables in Google Sheets
There is a joke within the information neighborhood that goes:
“You’ll spend 90% of your time cleaning data, and the other 10% of your time complaining about cleaning your data.”
Do you take care of badly formatted information that takes you hours to tidy up, stopping you from making progress in your “real” work?
Do you ever end up repeating a course of manually, like extracting a zipper code from an deal with?
Ever puzzled what the heck a Pivot Desk is, and why you need to care about them?
This course is designed that can assist you work with messy, actual-world datasets, and it is a match for newbie-to-intermediate stage Google Sheets customers.
By way of 4 hours of video tutorials, you will be taught strategies and finest practices for cleansing information and making ready it for evaluation and reporting — saving you hours of tedious, repetitive work, and serving to you get correct outcomes to your firm.
Course 2: Construct Dashboards with Google Sheets and Information Studio
Do you spend hours accumulating information, wrestling it into the format you want after which updating the identical report that nobody ever reads?
Or possibly you are neck deep in information however do not know methods to use it to make sound enterprise and advertising selections?
Dashboards are unbelievable instruments that provide you with a excessive-stage view of your online business, displaying KPIs, tendencies and information comparisons… so you need to use that perception to develop your organization in sensible methods.
By studying some comparatively easy strategies, you possibly can create dashboards which can be automated, interactive and visually interesting. They will get individuals’s consideration and wow your colleagues and managers.
This course covers all the things it’s worthwhile to learn about constructing stunning enterprise dashboards with Google Sheets and Google Information Studio.
What this course bundle will do for you:
This complete course will train all the important thing strategies for turning information cleansing, pivot tables and constructing stunning, interactive dashboards in Google Sheet and Google’s new dashboard instrument, Information Studio. You can take messy, uncooked datasets and confidently flip them into insightful stories, so you can also make key information-primarily based selections that had been beforehand out of attain.
The core curriculum of each programs is constructed round sensible examples and all of the templates are included.
I will be with you each step of the way in which, displaying you the sheet setup, the formulation and the charts we use. For every instance you will have all the mandatory uncooked information and formulation, in addition to a remaining, completed template!
Your Teacher
Who’s instructing the course?
Ben Collins is an skilled information analytics teacher and freelance spreadsheet developer, serving to companies higher perceive their information by analytical insights and visualizations, together with dashboards. He works primarily with Google Sheets, Apps Script and Information Studio, and in addition has intensive expertise with Excel, SQL and Tableau. He beforehand taught information programs and workshops for Common Meeting in Washington, D.C.
What you get with this course:
- 14 hours of video tutorials that stroll you step-by-step by all of the strategies.
- Entry to all of the uncooked information recordsdata, copies of the formulation and hyperlinks to on-line documentation and different nice sources.
- Copies of any completed dashboard templates for the 5 dashboard examples and the one Information Studio report. You can make your personal copies for modifying and reverse engineering as many occasions as you want.
- Membership to our devoted Fb group, the place you possibly can submit questions and get solutions, share insights and work together with different college students.
- All of the movies are on-line and you will have 24/7 entry for all times.
Who is that this course for?
- Anybody who works with information in Google Sheets.
- Somebody who’s curious to be taught extra about Google Sheets and dashboards.
- Perhaps you are an information analyst, a technical marketer, an educator, a scientist or something in between.
- Anybody who desires so as to add new expertise, that can provide help to advance your profession.
What are the conditions?
- A Google account.
- Entry to Google Sheets.
- Primary familiarity with Google Sheets and spreadsheets, though the early components of every course are arrange so that everybody ought to be capable of comply with alongside.
- Entry to Google Information Studio (for the final part of the dashboard course).
“Everyone talks about data culture in companies, but only a few know how to do it. Good dashboards are a great first step to democratize access to data in a simple way, and this course will definitely change the way you see your data today.”
– Gabriel O.
“This course is a fantastic way to discover how to build dashboards. Ben takes you step by step through what you need to do and his approach is well thought out and organised. The information covers the basics and introduces more complex subjects in a simple and easy to follow format.”
– Marilyn C.
“I’d recommend this course for anyone trying to make great dashboards in Google Sheets. Ben is a great teacher and he explains everything very thoroughly. Five stars from me.”
– Jakob R.
“Earlier than this course I had used just a few easy formulation (okay Common and Sum solely) however now I understand how to make use of a vlookup in addition to create Pivot Tables.
I’ve been making “Pivot Tables” improper for years, getting into all the uncooked information myself. I’m now in a position to make a Pivot Desk that can replace as wanted. I like how Ben exhibits a number of methods to do information cleansing and why you’d select one technique over the opposite. I loved the case research on the finish as a result of they introduced the whole course collectively.
I’ll positively be looking out for added programs from Ben.”
– Rachelle L.
“The course begins with an information cleansing part which is very actionable and related to actual world information units that all of us work with. My pivot desk information was fairly primary earlier than this course and I’m assured to say that I’m now going to have the ability to implement them into my information evaluation workflow.
This course additionally took my effectivity to the subsequent stage which is strictly what I wanted as extra of my time and evaluation is beginning to happen in sheets. I can not suggest this sufficient.”
– John R.
“I’m an instructional librarian who has labored for years with huge uncooked information units and pivot tables, and even offers associated shows at our regional conferences, and but I realized from Ben’s course a number of very helpful suggestions and strategies that I did not already learn about and that can save me a variety of work.
I plan to suggest it to my colleagues as a really thorough course in getting information prepared for the sort of information visualization contexts we have to present to our choice-makers and stakeholders.”
– Melissa B.
Regularly Requested Questions
This is What You may Get in Ben Collins – Google Sheets Training Bundle
Course Features
- Lectures 1
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
