- Видео 61
- Просмотров 7 607
Baz Roberts
Испания
Добавлен 3 фев 2019
Learn all about Google Workspace and Google Apps Script
12 Filtering data
How to filter data in Google Sheets
00:26 How to filter by values
02:57 How to filter by condition
04:32 How to filter by colour
05:33 How to use filter views
07:38 How to duplicate a filter view
08:57 How to delete a filter view
09:29 How to refresh a filter view
10:06 How to share a filter view
#googlesheets #googlesheetstutorial
00:26 How to filter by values
02:57 How to filter by condition
04:32 How to filter by colour
05:33 How to use filter views
07:38 How to duplicate a filter view
08:57 How to delete a filter view
09:29 How to refresh a filter view
10:06 How to share a filter view
#googlesheets #googlesheetstutorial
Просмотров: 142
Видео
11 Moving beyond one sheet
Просмотров 452 месяца назад
How to use multiple sheets in Google Sheets 00:56 Sheet names and how to rename sheets 01:20 How to add colours to sheet tabs 01:41 How to duplicate sheets 02:20 How to add and delete sheets 02:56 How to move tabs 03:15 How to navigate to other sheets 03:36 How to hide sheets 04:05 Sheets tab menu 04:54 How to refer to other sheets in formulas #googlesheets #googlesheetstutorial
13 Sorting data
Просмотров 922 месяца назад
How to sort data in Google Sheets 00:16 How to sort data by one column 01:08 How to sort data by multiple columns 02:01 How to sort data by headers 02:55 How to sort data via the data menu 03:56 How to randomize data #googlesheets #googlesheetstips
14 Conditional Formatting
Просмотров 942 месяца назад
00:49 How to add Conditional Formatting - 1 rule 02:25 How to set multiple conditional formatting rules 04:18 How to add custom formulas in conditional formatting 07:15 How to add colour scales in conditional formatting #googlesheets #googlesheetstutorial #conditionalformatting
15 Sparklines
Просмотров 1192 месяца назад
How to create sparklines (mini-charts) 01:05 How to create sparklines 03:25 How to add sparkline options 05:40 How to change line colour and line thickness 06:58 How to set the chart type 07:35 How to highlight the highest and lowest values 08:19 How to highlight negative values and create a winloss graphs #googlesheets #googlesheetstutorial #sparklines
16 Charts - part 1
Просмотров 672 месяца назад
How to create and edit charts 00:29 How to create a chart 02:29 How to use the chart editor - Setup 04:45 How to customise your chart 05:13 How to edit chart styles 05:59 How to edit chart and axis titles 06:53 How to edit series 07:34 How to format a specific data point 08:52 How to edit the legend 09:11 How to edit the horizontal & vertical axes 10:09 How to edit gridlines #googlesheets #goog...
17 Charts Part 2
Просмотров 412 месяца назад
00:21 Adding a new series to a chart 01:57 Creating a chart with two different scales 03:43 Formatting a series of data #googlesheets #googlesheetstutorial
18 Notes and Comments
Просмотров 472 месяца назад
How to use notes and comments in Google Sheets 00:53 How to add, edit & delete notes 01:52 How to add comments 02:46 How to interact with comments 04:10 How to assign action via comments 05:53 How to use the comments sidebar 06:41 How to copy comments to a copied document 07:09 How to change comment notifications settings #googlesheets #googlesheetstutorial
19 Merging Cells
Просмотров 672 месяца назад
How to merge cells in Google Sheets 00:17 How to merge cells 01:20 How to merge vertically or horizontally 02:51 How to unmerge cells and merged cell references #googlesheets #googlesheetstutorial
20 Version history
Просмотров 322 месяца назад
How to use version history and cell edit history in Google Sheets 00:43 How to use version history 02:24 How to name versions of a sheet 04:09 How to see the cell edit history #googlesheets #googlesheetstutorial
21 Sharing, Downloading, and Emailing
Просмотров 692 месяца назад
Sharing a spreadsheet, Downloading a spreadsheet, and emailing a spreadsheet 00:28 How to share a spreadsheet 01:13 How to add people, set an expiry date, and remove access 02:17 How to share a sheet to a domain or anyone with a link 03:03 How to copy and share a link 03:47 How to download a Google Sheet 04:03 How to email a file 04:57 How to email sheet collaborators #googlesheets #googlesheet...
23 Connecting Spreadsheets with IMPORTRANGE
Просмотров 962 месяца назад
23 Connecting Spreadsheets with IMPORTRANGE
9 Pasting data and creating sequences
Просмотров 1262 месяца назад
9 Pasting data and creating sequences
8 Cell References - Relative & Absolute
Просмотров 652 месяца назад
8 Cell References - Relative & Absolute
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Also, check out my website which is full of helpful tutorials on all the Google Workspace apps! bazroberts.com 😀
Top Baz! 👍
Thanks! 😁