Google Sheets anyone?
Discussion
If you have a sample of the type of information in a sheet which is fictitious use Google Bard to get you started. It also has a Sheets Plugin for enterprise users. If not it's good enough to create a demo Sheets file for you which you can study and take formulas from.
I suggest a demo sheet with fictitious data just to get you started, rather than sharing corporate data with an AI/ML system, which may breach confidentiality etc.
I suggest a demo sheet with fictitious data just to get you started, rather than sharing corporate data with an AI/ML system, which may breach confidentiality etc.
Corso Marche said:
If you have a sample of the type of information in a sheet which is fictitious use Google Bard to get you started. It also has a Sheets Plugin for enterprise users. If not it's good enough to create a demo Sheets file for you which you can study and take formulas from.
I suggest a demo sheet with fictitious data just to get you started, rather than sharing corporate data with an AI/ML system, which may breach confidentiality etc.
It is a course I am doing I am guessing it is a sample, does this work for you?I suggest a demo sheet with fictitious data just to get you started, rather than sharing corporate data with an AI/ML system, which may breach confidentiality etc.
Edited by Oliver Hardy on Sunday 3rd December 16:47
That's an Excel file, not Sheets?
If you want to use in Sheets with a Google account you have then open it in Sheets and convert it to Sheets before you do anything.
That pic is very blurry, and my old eyes aren't interested in trying to zoom in and then focus on it.
So, with the old "teach a man to fish" adage in mind convert it to Sheets, use the Google Bard extension for Sheets, tell it what you want to do in plain English, and then study how it did it for you and what formulas were used. It'll stand to you much better in whatever course you are currently doing.
Or of course just leave it in Excel and use Excel to do it. The formulas in Excel and Sheets are very similar for this task.
If you want to use in Sheets with a Google account you have then open it in Sheets and convert it to Sheets before you do anything.
That pic is very blurry, and my old eyes aren't interested in trying to zoom in and then focus on it.
So, with the old "teach a man to fish" adage in mind convert it to Sheets, use the Google Bard extension for Sheets, tell it what you want to do in plain English, and then study how it did it for you and what formulas were used. It'll stand to you much better in whatever course you are currently doing.
Or of course just leave it in Excel and use Excel to do it. The formulas in Excel and Sheets are very similar for this task.
Corso Marche said:
That's an Excel file, not Sheets?
If you want to use in Sheets with a Google account you have then open it in Sheets and convert it to Sheets before you do anything.
That pic is very blurry, and my old eyes aren't interested in trying to zoom in and then focus on it.
So, with the old "teach a man to fish" adage in mind convert it to Sheets, use the Google Bard extension for Sheets, tell it what you want to do in plain English, and then study how it did it for you and what formulas were used. It'll stand to you much better in whatever course you are currently doing.
Or of course just leave it in Excel and use Excel to do it. The formulas in Excel and Sheets are very similar for this task.
OK, thanks, I need to doit in Google Sheets as this is this requirement and it is what was given to my, it opens in Google Sheets tooIf you want to use in Sheets with a Google account you have then open it in Sheets and convert it to Sheets before you do anything.
That pic is very blurry, and my old eyes aren't interested in trying to zoom in and then focus on it.
So, with the old "teach a man to fish" adage in mind convert it to Sheets, use the Google Bard extension for Sheets, tell it what you want to do in plain English, and then study how it did it for you and what formulas were used. It'll stand to you much better in whatever course you are currently doing.
Or of course just leave it in Excel and use Excel to do it. The formulas in Excel and Sheets are very similar for this task.
I did a screen print, not sure how else I can show an example of the data
What ios a Google Bard extension?
Don't just open it in Google Sheets though.
Convert it to Sheets before you do anything.
Go to YouTube and watch some of the introductory and beginner videos on Sheets.
Do the same for Bard, and use it as a learning tool to learn Sheets.
https://bard.google.com/?hl=en-GB
Convert it to Sheets before you do anything.
Go to YouTube and watch some of the introductory and beginner videos on Sheets.
Do the same for Bard, and use it as a learning tool to learn Sheets.
https://bard.google.com/?hl=en-GB
Surely it's a trick question, do it correctly in Sheets to pass, but to get top marks you do it in Excel because you understand the request is a bit silly. Your answers are 10s work if you create a Pivot Table based on the data range. Full marks if you format the range as a Table first.
As has been said, a pivottable (or the Sheets equivalent) would be the easy way to do the profit answers.
However, if you want a same page result (works whether they're asking about total profit and not item profit) then just use a 'min, 'max' and 'average' calculation/query on those columns.
The total sales query would simply be a sum on the sales column.
The states question is a bit awkward because the states data is 'dirty'...e.g. has a title of 'State' but is populated with countries, regions, and states. So definitively answering the number of unique states will be meaningless unless you have a way of cleaning that data first. Otherwise you can simply use a combined COUNTIF and UNIQUE function - I think it is the single function COUNTUNIQUE in Sheets.
However, if you want a same page result (works whether they're asking about total profit and not item profit) then just use a 'min, 'max' and 'average' calculation/query on those columns.
The total sales query would simply be a sum on the sales column.
The states question is a bit awkward because the states data is 'dirty'...e.g. has a title of 'State' but is populated with countries, regions, and states. So definitively answering the number of unique states will be meaningless unless you have a way of cleaning that data first. Otherwise you can simply use a combined COUNTIF and UNIQUE function - I think it is the single function COUNTUNIQUE in Sheets.
Edited by mmm-five on Monday 4th December 09:32
Might be a silly question, but does the course not teach you how to do this stuff before you are tested on it? Seems fairly basic spreadsheet work, and perfectly achievable in Excel or in Sheets. I've done similar in Data Analysis courses, and in Excel courses, but you are usually taught the basics first.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff