Pivot Tables A-Z kzread.info/head/PLv9Pf9aNgemud2YG9q19eYoBXCCjQX1cC QUERY function A-Z kzread.info/head/PLv9Pf9aNgemvAMlqvHP9RhXPW98g_eo7d

You are amazing! The best so far! KZread should know this!

Thanks so much for your videos and clear explanations. Inspiring.

Magic! Awesome! I need to try this. I guess using filters would make it a bit more challenging to fix the sum(sales) part. I'll play with that. Thanks.

Yet another great video!

Beautiful!

Thanks for your Videos, learned a lot !

Excellent..

Superb :)

please share data so that we can practice. excellent video.

Just wow

Thank you so much for this tutorial. I have learned so much. I tested the above , instead of replacing B2 with Sum(Sales), it still worked when I just used (Sales).

@ExcelGoogleSheets

2 жыл бұрын

Excellent!

@mateuszpolanski3162

Жыл бұрын

@@ExcelGoogleSheets are you able to expand on why B2 left there won’t work? Why do we need to replace it with Sales? In your case, the amount we wanted already was in B2 co not sure why it had to be changed to Sales or SUM(Sales). Thank you!

@ExcelGoogleSheets

Жыл бұрын

@@mateuszpolanski3162 In order for this to update automatically as underlying data updates, we use the field instead of a cell reference.

You are very successful...

Thanks a lot for your super professional explanation

@ExcelGoogleSheets

2 жыл бұрын

😀

👍🏻

Do you know if it's possible to create calculated fields when you have rows and columns selected in your pivot table? I am trying to create a sparkline calculated field with an average(sales) in my values, grouped by sales person (rows), and pivot on a date (year-month).

Want to get started with Google Data analytics certification. Do you think it worth ? Are Data analytics on demand right now?. Getting into IT world first time. Thank you

Is there a way to make the bar graph a different color depending on the percentage complete - e.g. under 50% would be red, 51-99% would be yellow, and 100% or more would be green?

@ExcelGoogleSheets

2 жыл бұрын

Yes. Watch this video for an example kzread.info/dash/bejne/g3uKxbKkipnRm5s.html

Kindly provide the same practice file.

If table has columns in addition to rows, then it looks terrible, unfortunately( Maybe there is any solution?

Can u share the datasheet used here

Hello Dear, I need full inventory management in google sheet . please sagest me

@jodhvirsingh8677

2 жыл бұрын

kzread.info/dash/bejne/oHWXsMmmibOnXZc.html&ab_channel=LearnGoogleSpreadsheets

NEED HELP! In Google Form Thank you for the awesome videos I liked all your videos that I watched. There is an option to collect respondents email but anyone can make a fake entry. Also Google sign in limits a person to submit once to a form. I am making a travel allowance form inspired by your Google Map + Google Form video. I need to log real email address, and each sales employee goes multiple time a day. Meaning he should fill that form multiple times. I want to learn from you how to collect their original email with allowing them to fill the form multiple times. I heard mandatory file upload helps to check their email by looking at their Google drive. But even then how to collect their email automatically without checking their drive link. Help will be appreciated sensei.

@gareththomas438

2 жыл бұрын

On Google forms, when creating the form, under the settings tab, then under Responses, you just turn on the collect email button. Then the email will automatically be added to the google sheet your data is collected on for every form submitted.

@incognitious

2 жыл бұрын

@@gareththomas438 But anyone can add a FAKE email and still google will accept it. Meanwhile, Google Sign In limits to ONE response. I need a process or script for two things: 1. Collect Authentic email 2. Only to perform a new entry in the same form

@TheoriginalBMT

2 жыл бұрын

@@incognitious If you have a business account, you can require all email respondents to be in house.

@incognitious

2 жыл бұрын

@@TheoriginalBMT Thanks for reply, but that will not do. Anyways I have found a solution by creating a script to extract the file uploader email.

Hi remove subtitles.

Thanks so much for your videos and clear explanations. Inspiring.