![Prolific Oaktree](/img/default-banner.jpg)
- Видео 256
- Просмотров 18 927 877
Prolific Oaktree
США
Добавлен 23 апр 2014
Welcome to Prolific Oaktree. This channel is a collection of how-to tech videos to help you master the in and outs of software. Focused on helping you get things done with spreadsheets and other web apps.
Learn Modern Tech from Prolific Oaktree
📰 Tech Tutorials - www.prolificoaktree.com
📰 Google Sheets Videos - ruclips.net/user/Sheetshelp
📰 Google Sheets Tutorials and Add-Ons - sheetshelp.com
-- Adam Steinfurth
Learn Modern Tech from Prolific Oaktree
📰 Tech Tutorials - www.prolificoaktree.com
📰 Google Sheets Videos - ruclips.net/user/Sheetshelp
📰 Google Sheets Tutorials and Add-Ons - sheetshelp.com
-- Adam Steinfurth
How to Use Calculated Fields in Google Sheets Pivot Tables
This video walks you through several examples of calculated fields in Pivot Tables.
Use charts in Google Sheets: ruclips.net/video/SeNtoBId8vY/видео.html
Timestamps:
0:00 Overview
0:25 Create a Pivot table
2:01 Add a "regular" field
2:45 Calculated Field - Average
5:59 Calculated Field - Division
8:07 Reasons to use calculated fields
9:25 Conditional formulas in calculated fields (COUNTIF)
15:06 Next Video - Charts!
#googlesheets #spreadsheet #pivottable
Use charts in Google Sheets: ruclips.net/video/SeNtoBId8vY/видео.html
Timestamps:
0:00 Overview
0:25 Create a Pivot table
2:01 Add a "regular" field
2:45 Calculated Field - Average
5:59 Calculated Field - Division
8:07 Reasons to use calculated fields
9:25 Conditional formulas in calculated fields (COUNTIF)
15:06 Next Video - Charts!
#googlesheets #spreadsheet #pivottable
Просмотров: 1 813
Видео
Learn Google Sheets in 10 Minutes
Просмотров 5812 месяца назад
Learn all the basics of using Google Sheets, including cell references, formulas, and data types. Timestamps: 0:00 Grid 0:30 Entering data 1:47 Formulas 3:33 Formatting 4:31 Functions and cell ranges 6:48 Data types 8:14 Smart Chips Smart Chips Video: ruclips.net/video/49ftHOUY64w/видео.html #googlesheets #tutorial
Remove Duplicate Data in Apple Numbers
Просмотров 3,8 тыс.6 месяцев назад
It can be challenging to remove duplicates in Apple Numbers due to the lack of a UNIQUE function. However, this video demonstrates a workaround that allows you to create unduplicated entries without leaving the Numbers app. Next video: Identify duplicates in Numbers: ruclips.net/video/SxIYHgIhh98/видео.html
Learn How to Identify Duplicates in Apple Numbers
Просмотров 2,8 тыс.6 месяцев назад
Learn how to identify repeated values in your spreadsheet table. We discuss a method using a filter and one using an IF function. Go here for the formulas. www.prolificoaktree.com/apple-numbers-remove-duplicates/ Timestamps: 0:00 Intro 0:37 Filter 1:13 Formula for duplicate rows 3:52 Formula for duplicate values 5:57 Next video - Types of Cell References Learn more from Prolific Oaktree: 🌳 Next...
Create a List of 1st 2nd 3rd Places #googlesheets
Просмотров 5036 месяцев назад
Learn how to use the SORTN function to create a list of race winners from a table of race results. Full Article - sheetshelp.com/1st-2nd-and-3rd-places/ SORTN Reference - sheetshelp.com/sortn/ SheetsWizard - bit.ly/sheetswiz Timestamps: 0:00 Overview 0:53 Start the SORTN function 1:25 Range 1:37 Number of items to return 2:21 Display ties mode 3:56 Clean the list 4:09 Next video - RANK #googles...
Remove Duplicates (with a Sheets Add-On that Beats the Built-In Option)
Просмотров 4626 месяцев назад
Learn how the Remove Duplicates add-on gives you powerful options to identify, manage, and remove duplicates in your spreadsheets. Discounted link for the Add-On: bit.ly/remove-dupes Timestamps: 0:00 Intro and setup 0:53 Start the add-on 1:31 Select duplicates or uniques 2:48 Highlight duplicates 3:29 Saved scenarios 3:54 Add a status column 4:12 Copy to another location 4:33 Clear values 4:46 ...
Show 1st 2nd 3rd Place Next to a List of Times in Google Sheets
Просмотров 2,1 тыс.8 месяцев назад
Learn how to use the RANK.EQ or the RANK.AVG function to show the ranking of times from a race. Learn how these functions deal with ties. sheetshelp.com/1st-2nd-and-3rd-places/ sheetshelp.com/rankeq/ sheetshelp.com/rankavg/ Timestamps: 0:00 Overview 0:22 Show Ties as Next Rank - RANK.EQ 1:39 Show Ties as Average Rank - RANK.AVG 2:18 Use Only One Formula - ARRAYFORMULA #spreadsheet #googlesheets
Sum Values based on Other Cells | Google Sheets
Просмотров 3,8 тыс.8 месяцев назад
We will learn three ways to sum amounts based on values in other cells in Google Sheets. Webpage: sheetshelp.com/sum-based-on-another-cell/ Timestamps: 0:00 Overview 0:34 UNIQUE and SUMIF 3:25 Pivot Table 5:04 QUERY 8:06 Next video: QUERY Function #spreadsheet #googlesheets
Avoid Mistakes while Rounding Numbers in Google Sheets
Просмотров 7639 месяцев назад
Learn about how to round numbers in Google Sheets. Some techniques changes the numbers while others only change how they are displayed. Blog post: sheetshelp.com/round-numbers/ INT vs. TRUNC: sheetshelp.com/int-vs-trunc/ TripTally: bit.ly/triptally Timestamps: 0:00 Intro 0:21 Formatting 1:29 ROUND Function 4:54 MROUND Function 7:03 ROUNDUP Function 8:10 CEILING.MATH Function 10:31 INT and TRUNC...
Show Ranking Data in Google Sheets Using Sparklines
Просмотров 9799 месяцев назад
Learn how to use sparkline bar charts to show relative number differences. In other words, how to show the ranking of numbers with horizontal bars. We'll also cover how to emphasize one bar with a different color. Blog Page - sheetshelp.com/rank-numbers-using-sparklines/ College Compare - bit.ly/cc-add-on Timestamps: 0:00 Intro 0:31 What's a bar chart, and how it will be used 1:07 Formula for s...
Organize Your Apple Numbers Spreadsheet with Tables
Просмотров 7959 месяцев назад
Learn how to arrange your data in Apple Numbers using several tables on the same sheet. This lets you use features that are not available in other spreadsheet programs. See how to use cell references in Apple Numbers - ruclips.net/video/2l328iTPMvE/видео.html Timestamps: 0:00 Problem with a traditional layout 1:43 Creating three tables in one sheet 2:09 Working with the separate tables 4:52 Mov...
Automatically Sort New Rows in Google Sheets
Просмотров 11 тыс.10 месяцев назад
Automatically Sort New Rows in Google Sheets
Learn Two Methods to Compare Sheets | Google Sheets
Просмотров 4,1 тыс.10 месяцев назад
Learn Two Methods to Compare Sheets | Google Sheets
How to Use Dropdowns in Google Sheets
Просмотров 1,4 тыс.10 месяцев назад
How to Use Dropdowns in Google Sheets
Learn How to Extract Data from Smart Chips - Google Sheets
Просмотров 2,3 тыс.10 месяцев назад
Learn How to Extract Data from Smart Chips - Google Sheets
Learn How to Use Smart Chips in Google Sheets
Просмотров 6 тыс.10 месяцев назад
Learn How to Use Smart Chips in Google Sheets
Work with the Same Spreadsheet in Excel and Google Sheets
Просмотров 72011 месяцев назад
Work with the Same Spreadsheet in Excel and Google Sheets
Work with a Google Sheet Spreadsheet in MS Excel
Просмотров 40311 месяцев назад
Work with a Google Sheet Spreadsheet in MS Excel
Gmail and Google Sheets Mail Merge | No Add-Ons
Просмотров 17 тыс.11 месяцев назад
Gmail and Google Sheets Mail Merge | No Add-Ons
Google Sheets - Add a Pop-Up Calendar Date Picker
Просмотров 205 тыс.Год назад
Google Sheets - Add a Pop-Up Calendar Date Picker
Named Functions, LAMBDA, MAP, REDUCE and More - New Google Sheets Functions
Просмотров 2,2 тыс.Год назад
Named Functions, LAMBDA, MAP, REDUCE and More - New Google Sheets Functions
Sort and Filter - New Features for Google Sheets
Просмотров 14 тыс.Год назад
Sort and Filter - New Features for Google Sheets
Visualize Stock Data in Google Sheets
Просмотров 1,7 тыс.Год назад
Visualize Stock Data in Google Sheets
How to Use the New Google Docs - Table of Contents
Просмотров 9 тыс.Год назад
How to Use the New Google Docs - Table of Contents
How to Use Pop Up Menus in Apple Numbers
Просмотров 4,8 тыс.Год назад
How to Use Pop Up Menus in Apple Numbers
Learn How to Use Cell References in Apple Numbers
Просмотров 4,7 тыс.Год назад
Learn How to Use Cell References in Apple Numbers
Find Distances and Travel Times in Google Sheets - TripTally
Просмотров 4,2 тыс.Год назад
Find Distances and Travel Times in Google Sheets - TripTally
Working with Special Characters in Google Sheets
Просмотров 1,6 тыс.Год назад
Working with Special Characters in Google Sheets
Thx master!! Gracias MAESTRO!!
You're welcome! Glad you liked it.
Hi. My goal is to find a way to copy a cell and text color to copy the origination of a cell's and text's colors. For example, cell a2 has the word "completed" and the text is bold red with the cell's color purple. When I type "completed" in cell c35, it automatically makes that cell's color purple, and the word becomes bold and red. How can I do that without a script?
Excellent video, I wish you can add Excel files to apply the video on it
Excel? What's Excel!
Awesome Thank you so much
You are very welcome
hey thanks a a lot! I appreciate the simplicity of your teaching style. going through the data certificate course on google and this has been a great resource!
Glad I could help!
Copying m3 from the web just types "m3" like normal. The number 3 is not special in any way. So that doesn't work. Also cant find a special symbol for cubic meters
What is m3?
@@ProlificOaktree cubic meter
It's not available in the add-on but you can use the function: =char(13221)
Thanks
Welcome
Very useful. Thank you.
You're welcome!
You're a Savior for me... Thanks a lot...
Happy to help
this was so cool. thank you!
Glad you liked it!
Very easy and helpful, thanks
Glad to hear that!
My boss used this feature a week ago and it really caught my attention. Thanks for this tutorial!
No problem. I'd say it's very underused.
so how do we get it to update automatically. For example, if I go in my excel and change the colors daily i don't see the updates to the sums.
very well explained. succinct. and i liked the f4 pro tip, I didnt know that. Thanks alot :)
My pleasure!
Thanks. Simple and clear!
You're welcome!
nice
So nice
Hi, this is a very clear explanation of Named Ranges. I am trying to see how I can use Named Ranges to create dynamic drop downs. Is it something that's doable in Google Sheets?
Sir, How t o list/ add duplicate instead just highlighting?
Hi, I have a problem to solve a night differential from 1:00am to 6am and I can't solve it with formula
Make sure you have dates with the times then you can work with them as numbers.
@@ProlificOaktree huhu it’s so hard
@@sweetmask1690 That's why I made this add-on: workspace.google.com/marketplace/app/timedif/1098005795621
Looks like every 2 months or so i have to go back to this video, its so good. Save me hours of work in less than 3 minutes
Well, we're always happy to have you back.
Thank you ! It solved my issue, Thank you very much!
Glad to hear it!
Is It possibile to do a dx and sx page number in order to set up the documento for a proper print?
I have a paid google workspace Business Account. How do i enable this feature?
It should be on by default. If the options aren't there, you will have to talk to your admin.
If a simple table is used in a google doc, is there a way to specify row headers to make it readable?
Thank you!
You're welcome!
Thank you this was very helpful!
I'm so glad!
Thanks for this!
Sure thing!
all i get is errors reading Ref! and it won't sort anything new I put in
I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.
Super helpful!
Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀
Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .
Glad it helped!
a thousand times thank you!!!!
Thousand times welcome
Reference citation: Prolific Oaktree. (2017, August 19). Google Docs - Hanging Indent [Video]. ruclips.net/video/8LvjjnS5y6I/видео.html
What is this?
Thanks
Welcome
*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*
No, you'd have to try something like this: ruclips.net/video/UyBSXgt2_Yg/видео.html
Thanks. That was driving me nuts. I appreciate you.
You're welcome!
i love you
Right back at ya
Concise, clean and effective. Many thanks
Many welcomes!
=COUNTIF(A:A;A1)>1
Doesn't seem to be working for me entirely, any other way to fix it?
Would need more details...
Now instead of comma, you need to use semicolon in the custom formula field.
how to do this when you change a dropdown
It works with drop-downs like a text string or number, depending on what's in the dropdown. It shouldn't be a problem. Are you experiencing issues?
very useful tips and clear direction, thank you
Glad it was helpful!
I get no such dialog. The share drop down icon has a lock to the left of it and the drop down says copy link and under that Private only to me. Interface sucks.
You must not be the Document owner.
@@ProlificOaktree My icon has a drop-down arrow next to it which makes it seem you click on it for options but I needed to not click that but the Share image like you said. It looks different. (Globe Share | down arrow). I kept selecting the down arrow.
@@jeffreyjitterbug The share interface has changed since I made this video. I will put it on my list to redo. Thanks for the heads up.
@@ProlificOaktree Subscribed : )
Thank you very much for the help, Sir!
Glad it helped!
Which of these options is best for viewing at maximum original picture and text resolution/quality for larger computer screens? Also, can hyperlinks still function for viewers?
Thank you so much - VERY helpful!!
So glad!
how to double click at google sheet with mobile app
You can't get the pop-up calendar on mobile.
Not reliable. Sometimes it left duplicate values, sometimes it highlight values which are not duplicate at all
My guess is you have hidden characters (like spaces) that are making text strings different when they look the same.
Straight to the point❤❤❤ good vid
Thanks bro
Welcome