Google Sheets 2024 | 2-In-1 Course

A Google Sheets course that prepares you for work. It's great for both beginners and advanced users.

What you'll learn

How to import and manipulate data sets big or small

How to use macros to automate repetitive tasks

How to protect, freeze, and hide data in your spreadsheets

How to make data visualizations with images, charts, and pivot tables

How to customize the theme, colors, fonts, and layout of your spreadsheets

How to make dynamic spreadsheets with functions & conditional formatting

How to find and replace data on a large-scale with regular expressions.

How to gain insights from you data with filter views and slicers

How to collaborate and share your files with other people

How to do a data cleanup and a data extraction

Requirements

A working computer

A reasonably reliable internet connection

An accessible Google account

Description

Become an effective Google Sheets user and learn it through and through. Learning Google Sheets will help you A LOT!Learn to appreciate the power of the Google Sheets.Understand the ins and outs of Google Sheets Structure.Learn to use Google Sheets to build powerful tools to help you in your daily life.See how to approach breaking down and rearranging information to where it's more usableLearn shortcuts get things done faster.Learn macros to automate tasks.Learn how to create your own custom systems with Google Sheets.You will also find videos to help you understand complex concepts in a very simple way.There are several projects associated with the course allowing you to practice what you learn and make sure you are learning what you need.Who this course is for:anyone who wants to get started with Google Sheets.existing users or learners who wants to be effective at using Google Sheets lesser known features.Excel who wants to migrate to Google Sheets but are afraid to make the move!Those who already know Google Sheets but now want to go to the next level by understanding how to analyze large data sets and build and integrate third-party tools.

Overview

Section 1: Course Introduction

Lecture 1 Introduction Video

Lecture 2 The Course Structure

Section 2: Project: Exercise Tracker

Lecture 3 Creating the File

Lecture 4 Planning the Project

Lecture 5 Making the Key Page

Lecture 6 Filling out the Key

Lecture 7 Making our Schedule

Lecture 8 Adding Exercises

Lecture 9 Formatting and Clean Up

Section 3: File Menu

Lecture 10 Creating Files

Lecture 11 Open Files

Lecture 12 Import Files

Lecture 13 Make a Copy

Lecture 14 Sharing

Lecture 15 Email Files

Lecture 16 Download Files

Lecture 17 Rename Files

Lecture 18 Move

Lecture 19 Add Shortcut to Drive

Lecture 20 Deleting Files

Lecture 21 Version History

Lecture 22 Details

Lecture 23 Settings

Lecture 24 Printing

Section 4: Edit Menu

Lecture 25 Undo & Redo

Lecture 26 Cut, Copy, Paste

Lecture 27 Paste Special

Lecture 28 Move

Lecture 29 Delete

Lecture 30 Find and Replace

Section 5: View Menu

Lecture 31 Show

Lecture 32 Freeze Rows and Columns

Lecture 33 Group Rows and Columns

Lecture 34 Hide Sheets

Lecture 35 Zoom

Lecture 36 Full Screen

Section 6: Insert Menu

Lecture 37 Insert Cells

Lecture 38 Insert Rows and Columns

Lecture 39 Insert Sheets

Lecture 40 Insert Charts

Lecture 41 Customize Charts

Lecture 42 Pivot Tables

Lecture 43 Insert Images

Lecture 44 Insert Drawing

Lecture 45 Function Basics

Lecture 46 Other Insert Options

Lecture 47 The IF Function

Lecture 48 Insert Link

Lecture 49 Checkboxes

Lecture 50 Dropdowns

Lecture 51 Emojis

Lecture 52 Comment

Lecture 53 Notes

Section 7: Format Menu

Lecture 54 Theme

Lecture 55 Text

Lecture 56 Alignment

Lecture 57 Wrapping

Lecture 58 Rotation

Lecture 59 Font Size

Lecture 60 Font Family

Lecture 61 Text Color

Lecture 62 Fill Color

Lecture 63 Conditional Formatting

Lecture 64 Alternating Colors

Lecture 65 Clear Formatting

Lecture 66 Borders

Lecture 67 Merge Cells

Section 8: Data Menu

Lecture 68 Sort Sheet

Lecture 69 Sort Ranges

Lecture 70 Filters

Lecture 71 Filter Views

Lecture 72 Slicer

Lecture 73 Protect Data

Lecture 74 Named Ranges

Lecture 75 Named Function

Lecture 76 Randomize Ranges

Lecture 77 Column Stats

Lecture 78 Data Validation Rules

Lecture 79 Data Clean Up

Lecture 80 Split Columns

Lecture 81 Data Extraction

Section 9: Tools

Lecture 82 Forms

Lecture 83 Spell Check

Lecture 84 Autosuggest

Lecture 85 Notification Settings

People who love spreadsheets,People who enjoy using spreadsheets as tools to become more effecient,People who like learning new things,People who interested in working with data sets using spreadsheets