Google Sheets - Beginner

[LeeAndro]

Last updated 3/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.80 GB | Duration: 2h 53m

Designed to teach students the fundamentals of Google Sheets.​

What you'll learn
Import and Convert Spreadsheets to Sheets
Navigate the Sheets User Interface
Use the File Menu
Creating & Saving a Spreadsheet
Cells and Ranges
Formatting Values
Autofill Handle
Inserting Links
Creating Basic Formulas
Sharing a Spreadsheet
Inserting a Chart
Formatting a Chart

Overview
Section 1: Introduction

Lecture 1 Introduction

Section 2: Getting Started with Google Sheets

Lecture 2 What is Google Sheets

Lecture 3 Opening Google Sheets

Lecture 4 Importing and Converting Spreadsheets to Sheets

Lecture 5 Navigating the Sheets User Interface

Lecture 6 Understanding Sheet Components

Lecture 7 Using the File Menu

Lecture 8 Creating a Spreadsheet

Lecture 9 Saving a Spreadsheet

Lecture 10 Accessing Help

Section 3: Entering Data

Lecture 11 Navigating a Spreadsheet by Mouse or Keyboard

Lecture 12 Working with Cell and Ranges

Lecture 13 Using Various Data Selection Techniques

Lecture 14 Working with Common Sheet Commands

Lecture 15 Working with Copy and Paste

Lecture 16 Understanding Data Types

Lecture 17 Formatting Values

Lecture 18 Using Autofill Handle

Lecture 19 Inserting Links

Section 4: Understanding Formula Basics

Lecture 20 What are Formulas and Functions

Lecture 21 Understanding the Components of a Formula

Lecture 22 Understanding Calculation Hierarchy and the Order of Operations

Lecture 23 Creating Basic Formulas

Lecture 24 Working with Basic Functions and Autosum

Lecture 25 Using Cell References

Lecture 26 Using Explore

Section 5: Formatting a Spreadsheet

Lecture 27 Formatting and Aligning Data

Lecture 28 Modifying Columns and Rows

Lecture 29 Using Borders and Fill

Lecture 30 Using Paint Format

Lecture 31 Inserting Notes or Comments

Lecture 32 Inserting Checkboxes

Lecture 33 Applying a Theme

Section 6: Managing Spreadsheets

Lecture 34 Using Zoom Tools

Lecture 35 Working with Sheets

Lecture 36 Working with Spreadsheet Tabs

Lecture 37 Hiding and Unhiding Spreadsheets

Lecture 38 Sorting Sheets Data

Lecture 39 Filtering Sheets Data

Lecture 40 Using Filter Views

Lecture 41 Using Freeze Panes

Section 7: Printing a Spreadsheet

Lecture 42 Using Find and Replace

Lecture 43 Using Spell Check

Lecture 44 Preparing a Spreadsheet for Printing

Lecture 45 Chag Spreadsheet Settings

Lecture 46 Finalizing Printing

Lecture 47 ing and Emailing Files

Lecture 48 Sharing a Spreadsheet

Section 8: Creating Charts

Lecture 49 Inserting a Chart

Lecture 50 Formatting a Chart

Lecture 51 Moving and Sizing a Chart

Lecture 52 Creating a Scorecard Chart

Section 9: Working with Graphics

Lecture 53 Inserting Images

Lecture 54 Creating Drawings

Section 10: Conclusion

Lecture 55 Course Recap

Section 11: Assessment Quiz

Anyone who wishes to learn the fundamentals of Google Sheets

HomePage:

https://www.udemy.com/course/google-sheets-bner/

DOWNLOAD

https://1dl.net/isr59sccjlvb/IUAwPIZN__Google_She.part1.rar.html
https://1dl.net/uaz8lsxy72pt/IUAwPIZN__Google_She.part2.rar.html
https://1dl.net/f57ezuz1ttzj/IUAwPIZN__Google_She.part3.rar.html