Business challenge explained - Google Sheets Tutorial

Contents

• Introduction Introduction

  • Course introduction

    2m 26s
  • Agenda

    1m 17s
• 1. Advanced Formatting in a Google Sheet 1. Advanced Formatting in a Google Sheet

  • Advanced formatting in a Google Sheet

    1m 53s
  • (Locked)
    Conditional formatting

    1m 48s
  • (Locked)
    Activity 1 explained

    12s
• 2. Advanced Formulas and Functions 2. Advanced Formulas and Functions

  • Advanced formulas and functions

    2m 45s
  • (Locked)
    Using IF and IFS to analyze data

    4m 7s
  • (Locked)
    Activity 2 explained

    10s
  • (Locked)
    Data validation and named ranges

    3m 25s
  • (Locked)
    Activity 3 explained

    11s
• 3. Analyze and Report 3. Analyze and Report

  • (Locked)
    Analyze and report

    1m 17s
  • (Locked)
    Exploring charts

    2m 49s
  • (Locked)
    Activity 4 explained

    6s
  • (Locked)
    Pivot tables

    47s
  • (Locked)
    Create a pivot table

    3m 37s
  • (Locked)
    Activity 5 explained

    8s
  • (Locked)
    Integration and publishing in Google Sheets

    3m 54s
  • (Locked)
    Activity 6 explained

    8s
  • (Locked)
    Macros

    2m 35s
  • (Locked)
    Apply a macro

    1m 16s
• 4. Populate Data Using a Google Form 4. Populate Data Using a Google Form

  • (Locked)
    Populate data using a Google Form

    3m 47s
  • (Locked)
    Activity 7 explained

    5s
  • (Locked)
    Form settings and sharing a Google Form

    3m 39s
  • (Locked)
    Activity 8 explained

    12s
  • (Locked)
    Managing feedback

    1m 25s
• 5. Business Challenge 5. Business Challenge

  • (Locked)
    Business challenge overview

    1m 25s
  • (Locked)
    Business challenge explained

    2s
  • (Locked)
    Wrap-up

    1m 23s