Companies Home Search Profile

Introduction to Google Zen

Focused View

Markia Powell

1:33:06

48 View
  • 1. Introduction to Course and Zen.mp4
    05:36
  • 2. Best Practices.mp4
    04:18
  • 3. Downloading the Zen Extension.mp4
    02:24
  • 4. Zen Features.mp4
    03:37
  • 1. Project Introduction.mp4
    02:49
  • 2. Data Generation for Your Gift Shop.mp4
    06:05
  • 3. Using the Join Directive.mp4
    03:37
  • 4. Using the Match-Rows Directive.mp4
    06:39
  • 5. Using the Group Directive.mp4
    03:32
  • 6. Using the Sort Directive.mp4
    01:52
  • 1. Introduction to Project 2.mp4
    03:50
  • 2. Using the From Directive.mp4
    02:28
  • 3. Using the Outer Join Directive.mp4
    07:47
  • 4. Using the Filter Directive.mp4
    03:14
  • 5. Using the Cartesian Product Directive.mp4
    06:22
  • 1. Introduction.mp4
    02:36
  • 2. Reviewing the From Directive.mp4
    02:56
  • 3. Reviewing the Match Rows Directive.mp4
    04:07
  • 4. Reviewing the Cartesian Product Directive.mp4
    03:21
  • 5. Reviewing the Join Directive.mp4
    03:29
  • 6. Reviewing the Outer Join Directive.mp4
    03:13
  • 7. Reviewing the Filter Directive.mp4
    03:50
  • 8. Reviewing the Group Directive.mp4
    05:24
  • 9. Directive Quiz.html
  • Description


    Learn how Zen for Google Sheets can help you quickly and accurately transform data.

    What You'll Learn?


    • The basics of Google Zen.
    • Using Zen for different Google Sheets projects.
    • How to use the Zen directives.
    • Using Zen to simplify project processes.

    Who is this for?


  • Business Analysts and anyone else interested in tools to bypass certain SQL functions built for Google Sheets.
  • More details


    Description

    In this course you will be introduced to Zen for Google sheets. Zen is an extension that allows you to make SQL-like transformations in Google sheets. Now you can transform data quickly and accurately by clicking buttons. Its user-friendly interface makes this an easy tool to learn.

    You will learn the basics of Zen and how the extension works.

    You will also learn how to use the directives to efficiently transform your data into output sheets.

    There will be two easy-to-follow projects for you to get some hands-on learning. It is recommended that you follow along as much as possible by pulling up a tab with your own Google Sheet.

    The first project contains data related to a hypothetical gift shop. The goal is to find the highest monthly profits. We will find the answer by going through a series of directives.

    The second project will take you through the next four directives.

    Then the last section will contain a review and more concise definitions of the directives and how they work. There is also a quiz to test your understanding of all that was covered.

    By the end of this course you should have a good understanding of how Zen works in Google sheets and the things you can do with it.

    Who this course is for:

    • Business Analysts and anyone else interested in tools to bypass certain SQL functions built for Google Sheets.

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Markia Powell
    Markia Powell
    Instructor's Courses
    Hi, I will be your instructor. I am a current Economics & Business Analytics student. I have prior instructing experience as a music teacher. I enjoy making videos in my spare time. I have used Excel in several of my classes and internship experiences. I had prior experience with Google Sheets through making a stock tracker.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 23
    • duration 1:33:06
    • Release Date 2023/02/28