- 69
- 1 221 433
Spreadsheet Class
United States
Приєднався 2 бер 2019
My name is Corey, and I created Spreadsheet Class to help people learn how to use Google Sheets. Here you'll learn how to use formulas, as well as learn lots of other tips and tricks for Google Sheets, such as how to build spreadsheet dashboards.
Check out my website to get in-depth lessons, a free formula cheat sheet, and a free dashboards and data analysis video course.
Feel free to email me at corey.spreadsheetclass@gmail.com if you have questions, or a project that you want help with
Check out my website to get in-depth lessons, a free formula cheat sheet, and a free dashboards and data analysis video course.
Feel free to email me at corey.spreadsheetclass@gmail.com if you have questions, or a project that you want help with
COUNTIF function & Column charts in Google Sheets: Lesson + Data project
Download the raw data to follow along: www.spreadsheetclass.com/wp-content/uploads/2024/08/Column-Chart-Data.csv
Create and customize charts: ua-cam.com/video/yte125rv8S8/v-deo.html
Import CSV files into Google Sheets: ua-cam.com/video/dtAVgCkCtWc/v-deo.html
Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/
Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/
_
In this video you will learn how to use the COUNTIF function to summarize your data, so that you can connect the data to a column chart.
Create and customize charts: ua-cam.com/video/yte125rv8S8/v-deo.html
Import CSV files into Google Sheets: ua-cam.com/video/dtAVgCkCtWc/v-deo.html
Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/
Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/
_
In this video you will learn how to use the COUNTIF function to summarize your data, so that you can connect the data to a column chart.
Переглядів: 187
Відео
24 templates for Google Sheets: For business, teachers, and fun
Переглядів 203Місяць тому
Get the templates: www.spreadsheetclass.com/google-sheets-templates/ In this video I will show you 24 free templates that you can use in Google Sheets. There are templates for business, for teachers, and for fun. Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets...
SUMIF function & Pie charts in Google Sheets: Lesson + Data project
Переглядів 261Місяць тому
Download the raw data to follow along: www.spreadsheetclass.com/wp-content/uploads/2024/08/Pie-chart-Data.csv Learn how to build dashboards: ua-cam.com/video/ICaJh0mj9Uc/v-deo.htmlsi=SNFlaR7k5mYSorMI Above is the first lesson in my full dashboards course. The course will take your spreadsheet skills from beginner to advanced, and give you abilities that will make you highly valuable in the work...
Hide or show the toolbar menu in Google Sheets
Переглядів 425Місяць тому
In this video I will teach you how to hide or show the top toolbar menu in Google Sheets. Learn how to build a dashboard in Google Sheets: ua-cam.com/video/ICaJh0mj9Uc/v-deo.htmlsi=SNFlaR7k5mYSorMI
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root | Quick version
Переглядів 2,4 тис.Рік тому
Extended version: ua-cam.com/video/kQ23nHuxW2Q/v-deo.html In this video I am going to show you how to do math in Google Sheets. I will show you the mathematical operators, I will show you how to do math with numbers entered directly into the formula, and I will also show you how to do math by using cell references in your formulas. I will show you how to add, sum, subtract, multiply, divide, sq...
How to use the FILTER function in Google Sheets | Quick version
Переглядів 4,7 тис.Рік тому
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I am going to show you how to use the FILTER function in Google Sheets, so that you...
How to copy formulas down a column in Google Sheets (& Locking cell references) | Quick version
Переглядів 7 тис.Рік тому
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I am going to show you how to copy formulas down a column in Google Sheets, and how...
Copy and paste values only in Google Sheets (Quick version)
Переглядів 15 тис.Рік тому
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video, I will quickly show you how to copy and paste values only in Google Sheets, so tha...
Switch columns and rows with the TRANSPOSE function in Google Sheets | Quick Version
Переглядів 3,2 тис.Рік тому
Extended version of TRANSPOSE lesson: ua-cam.com/video/oaXDevXu2I0/v-deo.html Article: www.spreadsheetclass.com/google-sheets-transpose-function/ In this video I will show you how to use the TRANSPOSE function in Google Sheets. I will go over turning columns into rows, and turning rows into columns. Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consu...
How to average in Google Sheets (Using the AVERAGE function)
Переглядів 20 тис.2 роки тому
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I am going to show you how to average in Google Sheets. I'll show you several ways ...
How to add and sum in Google Sheets (Addition and SUM function)
Переглядів 64 тис.2 роки тому
Article: www.spreadsheetclass.com/google-sheets-add-and-sum/ Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I am going to show you...
How to freeze rows & columns (& How to unfreeze) in Google Sheets
Переглядів 15 тис.2 роки тому
Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ Read the article: www.spreadsheetclass.com/freeze-unfreeze-rows-columns-in-google-sheets/ In this...
How to insert a new line in a cell (or formula) in Google Sheets
Переглядів 50 тис.2 роки тому
Article: www.spreadsheetclass.com/new-line-in-cells-or-formulas-in-google-sheets/ Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I...
Apply a formula to an entire column in Google Sheets with the ARRAYFORMULA function | Quick Version
Переглядів 20 тис.2 роки тому
This video is the condensed quick version of the ARRAYFORMULA lesson. Watch the video below to watch the extended version with many more examples. Extended version: ua-cam.com/video/5UdQ5iWYtp8/v-deo.html Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-cheat-s...
How to create and customize charts in Google Sheets (Quick version)
Переглядів 9 тис.2 роки тому
In this video I am going to show you how to create charts in Google Sheets, and I'll also show you how to customize charts. We will also go over two different ways of connecting your spreadsheet data to a chart. Get help with your spreadsheet project, or personalized training: www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet www.spreadsheetclass.com/best-google-sheets-...
Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
Переглядів 3,7 тис.2 роки тому
Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
How to indent in Google Sheets (5 Methods)
Переглядів 9 тис.2 роки тому
How to indent in Google Sheets (5 Methods)
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
Переглядів 4,4 тис.2 роки тому
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
Переглядів 10 тис.2 роки тому
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
Переглядів 10 тис.2 роки тому
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
How to create drop-down lists in Google Sheets (Data validation)
Переглядів 13 тис.2 роки тому
How to create drop-down lists in Google Sheets (Data validation)
Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
Переглядів 21 тис.2 роки тому
Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices
Переглядів 20 тис.2 роки тому
Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices
(Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping
Переглядів 6 тис.2 роки тому
(Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping
Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Переглядів 32 тис.2 роки тому
Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Build a dashboard in 3 simple steps (Google Sheets)
Переглядів 3 тис.2 роки тому
Build a dashboard in 3 simple steps (Google Sheets)
Project management timeline template for Google Sheets (Gantt Chart)
Переглядів 8 тис.2 роки тому
Project management timeline template for Google Sheets (Gantt Chart)
Switch columns and rows with the TRANSPOSE function in Google Sheets
Переглядів 14 тис.3 роки тому
Switch columns and rows with the TRANSPOSE function in Google Sheets
How to wrap text, unwrap text, and clip text in Google Sheets
Переглядів 7 тис.3 роки тому
How to wrap text, unwrap text, and clip text in Google Sheets
How to move a chart to another sheet in Google Sheets
Переглядів 11 тис.3 роки тому
How to move a chart to another sheet in Google Sheets
Great job. Thank you, legend. 💚🥇👏
WORST CONTAIN WRITER LIKE DOG
Thanks for sharing.
Thank you.
Will this data auto update the price within the excel sheet?
This hid the menu bar not the toolbar....
What if you want first letter to be capital
Thank you so much for this. I also just subscribed 🎉
I am glad you enjoyed this! Happy to have a new subscriber:)
If we have multiple lines in a cell, is it possible to indent it so that every line is indented without using the columns method? I tried adding spaces but it doesn't work. ------------------------ So my cell looks like this ------------------------ but I want it to look like this ---------------------------- So my cell looks like this ----------------------------
Thank you, is there a template for bakers?
Thank you!
You're very welcome!
Amazing! Thankyou
You are very welcome!
As i scroll down in google sheets it autohides my tabs and it reappears as i scroll up. please give a solution to this problem. I am using Macbook M1 2023
I have never encountered that issue, maybe it is unique to MAC (Which I do not have)
I have tried it many times but it doesn't work.
Did you finally get it to work?
sadness, i need the thing you didn't go over in this video because it would of been too long :(
Darn, was it in the article?
This was such an amazing foundational course!! You did such a great job narrating the entire course, excellent 👍🏼👍🏼👍🏼👍🏼👍🏼🤯
Thank you so much for the kinds word! I am really glad that you enjoyed this.
What about hyper link text?
I will have to make a video on this:)
hello could this allow me to recover the give from my account will sell Amazon and also the titles of public UA-cam videos?
Hey, big companies like that likely prevent this formula from working on their site.
@@spreadsheetclass Sorry I'm using a translator and I'm not sure the translation was clear, what I meant is I would like to retrieve my sales history in a Google sheet to then do the analysis,Do you use Google apps script and APIs?
Oh I see okay, I am not experienced with API and I know very little Google Script.
why no comments?
Thanks for leaving one:)
THANK YOU SO MUCH!!! THIS IS AMAZING!
You bet, I am glad that you like the guitar tabs!
Thanks, very helpful video!
I am glad that the video helped!
Ctrl + Shift + Down and Ctrl D are crazy, thanks
You bet! They do make things so much faster haha
Thanks,that was helpful.
You bet!
Thank you for the clear and understandable guide. Transposing Columns to rows works exactly as you demonstrate. But then there is the issue that row 1 now still has the original column headings. Deleting that row now delete everything, including the newly created rows because they exist dependant on the TRANPOSE in cell AI. How can I remove the now irrelevant column headings? Simply deleing those cells removes the rows as well.
I am glad that it worked for you! It sounds like that could be solved by leaving your headings out of the formula reference, and then putting them manually where you want them to stay. So you could refer to A2:C instead of A1:C, to leave out the first row.
very helpful thanks
Glad to be able to help:)
Thank you! Soooooo much
You are so welcome!
Ek no
how do you indent within a cell ?
The methods in the video were not what you were looking for? I personally just type spaces before I put the data.
You just made my day, thank you 🙏
Well that makes my day! Glad to hear that
Thank you ❤
You bet! Glad you enjoyed this
Thank you❤
You are very welcome:)
HOw can I validate against another Google Sheet document? Ex: Validation of product codes contained in Master File Google Sheet Thanks
If you are using data from another document, and you want to do it in an automated way, then you can use the IMPORTRANGE function to pull the data into your sheet, so that you can refer to it with the validation / drop downs
took you fkn 5 minutes to say CTRL+C and CTRL+V.
It took you time to say that:) Some people prefer longer videos with more detail though.
Honestly you deserve more subscribers, you such a good teacher. Nice pace and nice explaination. I wish you all the best in your channel, you deserve it 👏
I really appreciate that:) Thank you for the kind words.
Very valuable. A few opportunities i've identified to improve the tool: -As a project manager balancing multiple projects, I would like to create a "Workstream/Project' Column to the left of the Task title. -As a project manager leading projects that involve multiple stakeholders, I would like to create a "Task Owner" column to the right of the Task title. -As a project manager looking to use this asset to democratize knowledge about my projects, I would like to create a Notes column to describe progress/identify bottlenecks/track next steps further to the right of the Task title. Manually inserting columns has predictably complicated the mapping from Daily to Weekly and Monthly views. Many thanks!
I will keep that in mind for future updates, thank you! I am so glad that you enjoyed the template.
Is there no way to sort columns of data using a row as the criteria, without having to transpose and reprint the data? Can Sheets never sort by a particular horizontal row?
I don't thin so in Google Sheets. Excel has a bit more functionality when it comes to the SORT function
How do you do it on a phone?
I don't think that there is a way to do this on the phone. The app is very limited
thanks a lot..it helped
You bet, I am glad to hear that!
Thank you very much...
You bet, glad to help!
thank you brother
You're welcome:)
Can you show how to do this with google maps using an API?
I am not familiar with using API, sorry
thanks
Certainly!
Thank you so much for this tip. The problem I am facing is after expanding the columns, when I try to edit the content of any cell, the column gets fully expands to the right, hiding all the other columns and cells adjacent to it. Can you please help me how can I not expand the column fully vertically and edit the content of the cell within the expanded column, it sounds a weird problem becuase I was also not expecting this after expanding the column, Please help me
You bet! This can be fixed in the text wrapping menu, by selecting the "Clip" option.
You have no idea how pleased I am to have found this !!!
:) I am glad you enjoyed the guitar tabs
Very informative! Question, how would one identify for time gaps between calls and get that average from the data? Assuming the data has time one call ended and where another began…
I am glad you enjoyed the video! I would use subtraction formulas down the column, then when you have a column that contains the gap / difference, then use the AVERAGE formula to average the entire column
works
Nice!!
Can you do it in a phone
I don't think so, the app is very limited
Hi, do you have a video on how to copy a google sheet table (with formula) so it functions in a google doc (syncing not required)?
Hey, unfortunately I do not currently have a video about this
Thanks bud🤪
You bet!
Thank you so much for this. Never used this excel or sheets before and a task landed on my lap! Your videos have been so helpful! Appreciated! Cheers.
That's so awesome, I am glad to help!