Ben Collins – Data Cleaning and Pivot Tables in Google Sheets

Rework messy knowledge into sturdy, usable datasets and acquire essential insights by mastering Google Sheets’ strongest instrument, Pivot Tables. Do you cope with badly formatted knowledge that takes you hours to tidy up, stopping you from making progress in your “real” work?

Ben Collins – Data Cleaning and Pivot Tables in Google Sheets

Rework messy knowledge into sturdy, usable datasets and acquire essential insights by mastering Google Sheets’ strongest instrument, Pivot Tables.

There is a joke in 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 cope with badly formatted knowledge 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 questioned 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.

Via 4 hours of video tutorials, you will be taught strategies and greatest practices for cleansing knowledge 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.

What’s Data Cleaning?

Data cleansing is the method of figuring out and correcting errors, fixing incomplete knowledge or coping with irrelevant knowledge in your knowledge units.

The aim of information cleansing is to create a constant, clear knowledge set, which supplies you the arrogance that any subsequent evaluation and conclusions you draw will likely be correct and thorough.

Why must you care?

Data cleansing is an important first step in the information evaluation pipeline, but one that individuals typically overlook.

In the event you begin with “bad” knowledge — in case your knowledge comprises duplicate data for instance — you are inevitably going to finish up with “bad” conclusions. You may find yourself double counting income, for instance, which may have disastrous penalties for your small business down the road.

This coaching course runs by means of skilled strategies and greatest practices, utilizing formulation and pivot tables, to scrub your knowledge, in a Google Sheets setting. As soon as you have grasped these ideas, you (and your boss!) will really feel assured that your conclusions are based mostly on sound knowledge.

What this course covers

• Finest practices for working with knowledge in Google Sheets.
• All of the formulation required for knowledge cleansing.
• Ideas and methods, resembling shortcut keys, to make your workflow extra environment friendly.
• Skilled strategies for turning messy actual-world knowledge into clear, orderly knowledge units to your evaluation.
• Pivot Tables! This course covers Pivot Tables from prime-to-backside. Even should you’ve by no means seen a Pivot Desk earlier than, you will quickly create chopping-edge ones, utilizing superior strategies like calculated fields and knowledge extraction with particular formulation. I do not assume you will discover a extra complete course on Google Sheets Pivot Tables anyplace else on the internet.
• Two in-depth case research that present all these strategies getting used collectively, in the broader context of an actual-world drawback.

What this course doesn’t cowl:

• analyze your datasets or tips on how to construct dashboard reviews (see my dashboard course if that is what you wish to be taught).
• use the scripting language, Apps Script, to work with knowledge.
• create knowledge visualizations or charts out of your knowledge.

What you get with this course:

• Over 4 hours of video tutorials that stroll you step-by-step by means of strategies for cleansing knowledge and utilizing pivot tables.
• Entry to all of the uncooked knowledge recordsdata used in the examples, copies of the formulation and hyperlinks to on-line documentation and different nice assets.
• Membership to our devoted Fb group, the place you’ll be able to put up 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 knowledge in Google Sheets — perhaps you are a knowledge analyst, a marketer, an educator, a scientist or somebody in between.
• Anyones curious to be taught extra about working with knowledge and Pivot Tables.
• Anybody who needs to be taught greatest practices and tips on how to be environment friendly with knowledge.
• Anybody who needs so as to add new expertise that may make it easier to advance your profession.

What are the conditions?

• A Google account.
• Entry to Google Sheets.
• Fundamental familiarity with Google Sheets and spreadsheets.
• No assumptions are made about prior information of capabilities or pivot tables — all of the subjects are coated comprehensively from scratch, at a snug tempo.

Your Teacher

 This is What You may Get in Ben Collins – Data Cleaning and Pivot Tables in Google Sheets