- 69
- 1 202 877
Spreadsheet Class
United States
Registrace 2. 03. 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: czcams.com/video/yte125rv8S8/video.html
Import CSV files into Google Sheets: czcams.com/video/dtAVgCkCtWc/video.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: czcams.com/video/yte125rv8S8/video.html
Import CSV files into Google Sheets: czcams.com/video/dtAVgCkCtWc/video.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.
zhlédnutí: 88
Video
24 templates for Google Sheets: For business, teachers, and fun
zhlédnutí 165Před 14 dny
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
zhlédnutí 192Před 21 dnem
Download the raw data to follow along: www.spreadsheetclass.com/wp-content/uploads/2024/08/Pie-chart-Data.csv Learn how to build dashboards: czcams.com/video/ICaJh0mj9Uc/video.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
zhlédnutí 109Před 21 dnem
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: czcams.com/video/ICaJh0mj9Uc/video.htmlsi=SNFlaR7k5mYSorMI
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root | Quick version
zhlédnutí 2,3KPřed rokem
Extended version: czcams.com/video/kQ23nHuxW2Q/video.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
zhlédnutí 4,5KPřed rokem
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
zhlédnutí 7KPřed rokem
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)
zhlédnutí 14KPřed rokem
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
zhlédnutí 3,1KPřed rokem
Extended version of TRANSPOSE lesson: czcams.com/video/oaXDevXu2I0/video.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)
zhlédnutí 20KPřed 2 lety
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)
zhlédnutí 62KPřed 2 lety
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
zhlédnutí 14KPřed 2 lety
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
zhlédnutí 48KPřed 2 lety
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
zhlédnutí 20KPřed 2 lety
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: czcams.com/video/5UdQ5iWYtp8/video.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)
zhlédnutí 9KPřed 2 lety
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)
zhlédnutí 3,7KPřed 2 lety
Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
How to indent in Google Sheets (5 Methods)
zhlédnutí 9KPřed 2 lety
How to indent in Google Sheets (5 Methods)
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
zhlédnutí 4,4KPřed 2 lety
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
zhlédnutí 10KPřed 2 lety
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
zhlédnutí 10KPřed 2 lety
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
How to create drop-down lists in Google Sheets (Data validation)
zhlédnutí 13KPřed 2 lety
How to create drop-down lists in Google Sheets (Data validation)
Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
zhlédnutí 21KPřed 2 lety
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
zhlédnutí 20KPřed 2 lety
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
zhlédnutí 6KPřed 2 lety
(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)
zhlédnutí 31KPřed 2 lety
Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Build a dashboard in 3 simple steps (Google Sheets)
zhlédnutí 2,9KPřed 2 lety
Build a dashboard in 3 simple steps (Google Sheets)
Project management timeline template for Google Sheets (Gantt Chart)
zhlédnutí 8KPřed 2 lety
Project management timeline template for Google Sheets (Gantt Chart)
Switch columns and rows with the TRANSPOSE function in Google Sheets
zhlédnutí 13KPřed 2 lety
Switch columns and rows with the TRANSPOSE function in Google Sheets
How to wrap text, unwrap text, and clip text in Google Sheets
zhlédnutí 7KPřed 2 lety
How to wrap text, unwrap text, and clip text in Google Sheets
How to move a chart to another sheet in Google Sheets
zhlédnutí 10KPřed 3 lety
How to move a chart to another sheet in Google Sheets
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 CZcams 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 made my day! Thank you sooooo much!
You are very welcome! Glad to hear that
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!
Thanks for sharing your knowledge. One of the best google sheets tutorials I've seen. Love how well you explain everything.
Thank you so much for the kind words! I am glad that you enjoyed this
maybe y'all aren't in google sheets, but it worked perfectly for me. Thank you!!!
Glad it worked! Happy to be able to help
Mine still pastes the formatting, with or without the shift key.
I have never heard of that before. The only times that mine has failed to work, it would not work at all.
Excellent tutorial ! Thank you.
I am glad that you enjoyed it!!
Thanks
You bet