Prolific Oaktree
Prolific Oaktree
  • Видео 256
  • Просмотров 18 927 877
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
Просмотров: 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
Negotiate Meeting Times in Gmail
Просмотров 22610 месяцев назад
Negotiate Meeting Times in Gmail
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
VisiCalc 💾 Brought back to life!
Просмотров 517Год назад
VisiCalc 💾 Brought back to life!
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

Комментарии

  • @jchicchon
    @jchicchon 2 дня назад

    Thx master!! Gracias MAESTRO!!

  • @WenSaiPanther
    @WenSaiPanther 2 дня назад

    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?

  • @mohamedmeshref
    @mohamedmeshref 3 дня назад

    Excellent video, I wish you can add Excel files to apply the video on it

  • @nithans
    @nithans 3 дня назад

    Awesome Thank you so much

  • @nategraham3980
    @nategraham3980 4 дня назад

    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!

  • @latuman
    @latuman 5 дней назад

    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

    • @ProlificOaktree
      @ProlificOaktree 2 дня назад

      What is m3?

    • @latuman
      @latuman 2 дня назад

      @@ProlificOaktree cubic meter

    • @ProlificOaktree
      @ProlificOaktree 2 дня назад

      It's not available in the add-on but you can use the function: =char(13221)

  • @flip7527
    @flip7527 6 дней назад

    Thanks

  • @tentavaruag
    @tentavaruag 6 дней назад

    Very useful. Thank you.

  • @sarakidstoons
    @sarakidstoons 7 дней назад

    You're a Savior for me... Thanks a lot...

  • @frogboy831
    @frogboy831 7 дней назад

    this was so cool. thank you!

  • @emma2982
    @emma2982 7 дней назад

    Very easy and helpful, thanks

  • @DamienDee19
    @DamienDee19 8 дней назад

    My boss used this feature a week ago and it really caught my attention. Thanks for this tutorial!

  • @JosephSutton-t8r
    @JosephSutton-t8r 9 дней назад

    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.

  • @jiju1185
    @jiju1185 9 дней назад

    very well explained. succinct. and i liked the f4 pro tip, I didnt know that. Thanks alot :)

  • @Ritums88
    @Ritums88 9 дней назад

    Thanks. Simple and clear!

  • @alohathailand7477
    @alohathailand7477 10 дней назад

    nice

  • @vskhosa
    @vskhosa 11 дней назад

    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?

  • @dineshr6713
    @dineshr6713 16 дней назад

    Sir, How t o list/ add duplicate instead just highlighting?

  • @sweetmask1690
    @sweetmask1690 18 дней назад

    Hi, I have a problem to solve a night differential from 1:00am to 6am and I can't solve it with formula

    • @ProlificOaktree
      @ProlificOaktree 12 дней назад

      Make sure you have dates with the times then you can work with them as numbers.

    • @sweetmask1690
      @sweetmask1690 11 дней назад

      @@ProlificOaktree huhu it’s so hard

    • @ProlificOaktree
      @ProlificOaktree 11 дней назад

      @@sweetmask1690 That's why I made this add-on: workspace.google.com/marketplace/app/timedif/1098005795621

  • @SylvioMedeiros
    @SylvioMedeiros 24 дня назад

    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

    • @ProlificOaktree
      @ProlificOaktree 22 дня назад

      Well, we're always happy to have you back.

  • @lasanthicolambage2139
    @lasanthicolambage2139 24 дня назад

    Thank you ! It solved my issue, Thank you very much!

  • @Targinaldo
    @Targinaldo 24 дня назад

    Is It possibile to do a dx and sx page number in order to set up the documento for a proper print?

  • @simonfernandes8672
    @simonfernandes8672 25 дней назад

    I have a paid google workspace Business Account. How do i enable this feature?

    • @ProlificOaktree
      @ProlificOaktree 12 дней назад

      It should be on by default. If the options aren't there, you will have to talk to your admin.

  • @LorrainePeterson-nz9th
    @LorrainePeterson-nz9th 26 дней назад

    If a simple table is used in a google doc, is there a way to specify row headers to make it readable?

  • @sibastoune
    @sibastoune 29 дней назад

    Thank you!

  • @lauren20007892
    @lauren20007892 29 дней назад

    Thank you this was very helpful!

  • @alfredoiglesias7856
    @alfredoiglesias7856 Месяц назад

    Thanks for this!

  • @michaelkwiatkowski3732
    @michaelkwiatkowski3732 Месяц назад

    all i get is errors reading Ref! and it won't sort anything new I put in

    • @ProlificOaktree
      @ProlificOaktree 26 дней назад

      I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.

  • @justinebatchelder728
    @justinebatchelder728 Месяц назад

    Super helpful!

  • @flavi100
    @flavi100 Месяц назад

    Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀

  • @Lorgayle1
    @Lorgayle1 Месяц назад

    Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .

  • @chrissmart7639
    @chrissmart7639 Месяц назад

    a thousand times thank you!!!!

  • @austinlehn3304
    @austinlehn3304 Месяц назад

    Reference citation: Prolific Oaktree. (2017, August 19). Google Docs - Hanging Indent [Video]. ruclips.net/video/8LvjjnS5y6I/видео.html

  • @brijendrasingh1
    @brijendrasingh1 Месяц назад

    Thanks

  • @user-jo8uh5sl2s
    @user-jo8uh5sl2s Месяц назад

    *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)*

    • @ProlificOaktree
      @ProlificOaktree 12 дней назад

      No, you'd have to try something like this: ruclips.net/video/UyBSXgt2_Yg/видео.html

  • @h.robinson9711
    @h.robinson9711 Месяц назад

    Thanks. That was driving me nuts. I appreciate you.

  • @REGINEERICALIM
    @REGINEERICALIM Месяц назад

    i love you

  • @danellis4561
    @danellis4561 Месяц назад

    Concise, clean and effective. Many thanks

  • @redf419
    @redf419 Месяц назад

    =COUNTIF(A:A;A1)>1

  • @HamdanSiddiqui-db4xu
    @HamdanSiddiqui-db4xu Месяц назад

    Doesn't seem to be working for me entirely, any other way to fix it?

    • @ProlificOaktree
      @ProlificOaktree 22 дня назад

      Would need more details...

    • @Paweu99
      @Paweu99 20 дней назад

      Now instead of comma, you need to use semicolon in the custom formula field.

  • @saben3462
    @saben3462 Месяц назад

    how to do this when you change a dropdown

    • @ProlificOaktree
      @ProlificOaktree Месяц назад

      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?

  • @longnguyenkim7336
    @longnguyenkim7336 Месяц назад

    very useful tips and clear direction, thank you

  • @jeffreyjitterbug
    @jeffreyjitterbug Месяц назад

    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.

    • @ProlificOaktree
      @ProlificOaktree Месяц назад

      You must not be the Document owner.

    • @jeffreyjitterbug
      @jeffreyjitterbug Месяц назад

      @@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.

    • @ProlificOaktree
      @ProlificOaktree Месяц назад

      @@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.

    • @jeffreyjitterbug
      @jeffreyjitterbug Месяц назад

      @@ProlificOaktree Subscribed : )

  • @gailmontes9922
    @gailmontes9922 Месяц назад

    Thank you very much for the help, Sir!

  • @aurelbetz2172
    @aurelbetz2172 Месяц назад

    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?

  • @DJDeonPearson
    @DJDeonPearson Месяц назад

    Thank you so much - VERY helpful!!

  • @اطفال2024
    @اطفال2024 Месяц назад

    how to double click at google sheet with mobile app

    • @ProlificOaktree
      @ProlificOaktree Месяц назад

      You can't get the pop-up calendar on mobile.

  • @sa-tg9xt
    @sa-tg9xt Месяц назад

    Not reliable. Sometimes it left duplicate values, sometimes it highlight values which are not duplicate at all

    • @ProlificOaktree
      @ProlificOaktree Месяц назад

      My guess is you have hidden characters (like spaces) that are making text strings different when they look the same.

  • @meow_2negg
    @meow_2negg Месяц назад

    Straight to the point❤❤❤ good vid

  • @louiearbelastimoso4665
    @louiearbelastimoso4665 Месяц назад

    Thanks bro