Google Sheets: Beginner Google Sheets

https://www.skillsoft.com/channel/google-sheets-0a4b0a21-1b90-11e7-9f7a-0bd8985e060c?expertiselevel=3450384&technologyandversion=3450385 https://www.skillsoft.com/channel/google-sheets-0a4b0a21-1b90-11e7-9f7a-0bd8985e060c?expertiselevel=3450384&technologyandversion=3450388 https://www.skillsoft.com/channel/google-sheets-0a4b0a21-1b90-11e7-9f7a-0bd8985e060c?expertiselevel=3450386&technologyandversion=3450385 https://www.skillsoft.com/channel/google-sheets-0a4b0a21-1b90-11e7-9f7a-0bd8985e060c?expertiselevel=3450386&technologyandversion=3450388 https://www.skillsoft.com/channel/google-sheets-0a4b0a21-1b90-11e7-9f7a-0bd8985e060c?expertiselevel=3450387&technologyandversion=3450388
  • 4 Courses | 2h 55m 11s
  • 2 Books | 8h 27m
  • 6 Courses | 4h 36m 43s
  • 10 Courses | 7h 38m 49s
  • 1 Book | 12m
  • 4 Courses | 2h 31m 42s
  • 4 Courses | 2h 51m 21s
Likes 203 Likes 203
 
Explore Google Sheets, a cloud-based spreadsheet app that's part of the Google Docs ecosystem.

GETTING STARTED

Enhancing your documents

  • Playable
    1. 
    Inserting rows & columns
    4m 12s
    NOW PLAYING
  • Playable
    2. 
    Resizing your columns & rows
    4m 24s
    UP NEXT

GETTING STARTED

Navigating & Configuring

  • Playable
    1. 
    Accessing Google Sheets
    3m 43s
    NOW PLAYING
  • Playable
    2. 
    Opening & editing documents
    3m 14s
    UP NEXT

GETTING STARTED

Analyzing Data with Tables & Charts

  • Playable
    1. 
    Analyzing your data with a pivot table
    4m 51s
    NOW PLAYING
  • Playable
    2. 
    Developing your pivot table
    5m 24s
    UP NEXT

COURSES INCLUDED

Enhancing your documents
Improve the display of your data using the insertion tools in Google Sheets. Discover how to add more columns, rows, and cells to insert more data in a worksheet. You will also learn how to manage and customize rows and columns by changing their size and applying borders. Spreadsheets in Google Sheets do not have to contain only data. Explore various methods for inserting images, including how to create, insert, and edit drawings, as well as hyperlinks. All these tools can be useful for creating first-rate headers for your documents.
10 videos | 42m has Assessment available Badge
Working with others on a document
Easily share spreadsheets with your colleagues using Google Sheets collaboration features. Discover how to share documents with others via email and select the most suitable format for sharing your spreadsheet. If you prefer to release your documents to a wider audience you can publish your spreadsheet via a link or by embedding code in a blog.To work with other users in real-time, discover how to set up sharing options for individuals or to create a link available for anyone in your organization. You will also learn how to communicate and interact with other editors, for example, by adding comments or assigning tasks.
9 videos | 42m has Assessment available Badge
Finding, Sorting & Filtering Data
There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to easily find and replace data. You will also learn how to sort your data and use filters to display only the data you need.Google Sheets includes other advanced options for sorting and filtering data with colors and conditions.In this course, you will discover other tools for filtering your data, such as filter views and slicers. Finally, learn how to group and ungroup your data to choose the information you want to display.
10 videos | 42m has Assessment available Badge
Referencing & Managing Data
While working in Google Sheets, you will often use a cell value in a formula or another location. Discover how to use absolute, mixed, and relative cell references in formulas or to extract values from other cells. These cell references will also be useful to create a formula with data from multiple sheets. Lastly, learn how to define data ranges for creating different types of menus using the data validation tool.
10 videos | 47m has Assessment available Badge
Using Basic Formulas
This course will focus on manipulating data and performing basic calculations using formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as to get access to the full list of functions available in Google Sheets. You will also see how to copy formulas to quickly fill out a table. Other functions will allow you to rank, count, and round values in a sheet. Google Sheets' functions are useful for manipulating text as well. For example, to replace specific characters or a text string. Finally, learn how to create formulas to generate random numbers and remove whitespace.
11 videos | 50m has Assessment available Badge
Using Formulas to Calculate & Manage Data
Discover how to use Google Sheets for common tasks like calculating the interest on a loan and comparing loans. This course will also teach you how to build formulas to find and manage duplicate values in your spreadsheets.Google Sheets includes built-in formulas to extract and analyze data. Learn how to work with some of these formulas on both data and text values, and use the LOOKUP and VLOOKUP formulas.
10 videos | 50m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Navigating & Configuring
Google Sheets is a web-based spreadsheet program from Google. Discover how to access the application and explore the Google Sheets home page. From this interface, learn how to open your spreadsheets for editing. You will also see how to customize the interface and spreadsheet view, and work with add-ons.
7 videos | 29m has Assessment available Badge
Creating & Managing documents
Explore the basics of creating, saving and managing spreadsheets in Google Sheets.Discover the multiple ways and places to save your spreadsheet, including on your computer and on Google Drive. Continue by learning how to save a workbook as an Excel, CSV or HTML file. See how to manage a document's version history, and recover unsaved documents. Finally, learn how to configure your spreadsheet settings before printing or saving it as a PDF file.
10 videos | 42m has Assessment available Badge
Inserting & Managing data
This course focuses on inserting and managing data in your worksheets.Google Sheets includes a variety of tools for inserting, editing, and customizing data. Learn how to insert data and how to create an automatic list of numbers, dates, or codes. You will also see how to select a cell or a cell range for copying and how to use the 'paste special' options to reuse formats or formulas.Finally, learn how to insert data with the Explore tool and how to improve your data with the Spelling tool.
11 videos | 37m has Assessment available Badge
Formatting data
You can improve the appearance of your data by using the formatting tools in Google Sheets. Discover how to work with data types, apply color, align text, resize columns and rows, and use conditional formatting formulas.
9 videos | 42m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Analyzing Data with Tables & Charts
Analyze data efficiently using the built-in features of Google Sheets. In this course, you will discover how to analyze your data with pivot tables and charts.Learn how to work with pivot tables, including formatting, sorting, filtering, adding calculated fields, and copying and exporting pivot tables.Another alternative to visually display your data is to use the built-in chart features in Google Sheets. Learn how to create and insert charts in your document.
9 videos | 43m has Assessment available Badge
Using Different Types of Charts
Google Sheets offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. You will also see how to share your charts by downloading a copy or publishing via a link or embedded code.
9 videos | 44m has Assessment available Badge
Performing Conditional Calculations
Conditional formulas let you perform a calculation on a range of values by specifying the criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Google Sheets. In this course, you will also learn how to use conditional formulas to translate data or to keep your information up to date.
9 videos | 43m has Assessment available Badge
Using Formulas to Obtain Data
Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both numeric and text values, and how to use LOOKUP and VLOOKUP.
9 videos | 40m has Assessment available Badge
SHOW MORE
FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Getting StartED with Google Apps
Providing clear and easy-to-use instructions for getting up and running with basic Google apps like Gmail, Google Voice, and more, this book gets you started collaborating and creating with Google’s online suite of applications on the Chrome OS.
Book Duration 8h 15m Book Authors By Adam Darbyshire, Paul Darbyshire

Book

Google Sheets in Pictures
Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. This concise tutorial shows you how.
Book Duration 12m Book Authors By In Pictures, Inc.

BOOKS INCLUDED

Book

Google Sheets in Pictures
Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. This concise tutorial shows you how.
Book Duration 12m Book Authors By In Pictures, Inc.

YOU MIGHT ALSO LIKE

Likes 50 Likes 50  
Likes 3 Likes 3  
CHANNEL Google Slides
Likes 35 Likes 35