Spreadsheet Class
Spreadsheet Class
  • 69
  • 1 202 877
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.
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

Komentáře

  • @allanwambia7913
    @allanwambia7913 Před 4 dny

    What if you want first letter to be capital

  • @ifeoluwaosho2605
    @ifeoluwaosho2605 Před 7 dny

    Thank you so much for this. I also just subscribed 🎉

    • @spreadsheetclass
      @spreadsheetclass Před dnem

      I am glad you enjoyed this! Happy to have a new subscriber:)

  • @emplore
    @emplore Před 9 dny

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

  • @BakeNCraft10
    @BakeNCraft10 Před 11 dny

    Thank you, is there a template for bakers?

  • @kjell5352
    @kjell5352 Před 15 dny

    Thank you!

  • @SarahBatsanis
    @SarahBatsanis Před 29 dny

    Amazing! Thankyou

  • @nk_BioBuG
    @nk_BioBuG Před měsícem

    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

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I have never encountered that issue, maybe it is unique to MAC (Which I do not have)

  • @ngonewsworld
    @ngonewsworld Před měsícem

    I have tried it many times but it doesn't work.

  • @quantum2330
    @quantum2330 Před měsícem

    sadness, i need the thing you didn't go over in this video because it would of been too long :(

  • @DinoRodriguez
    @DinoRodriguez Před měsícem

    This was such an amazing foundational course!! You did such a great job narrating the entire course, excellent 👍🏼👍🏼👍🏼👍🏼👍🏼🤯

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      Thank you so much for the kinds word! I am really glad that you enjoyed this.

  • @OmarNasrallah-q2b
    @OmarNasrallah-q2b Před měsícem

    What about hyper link text?

  • @chrisder1814
    @chrisder1814 Před měsícem

    hello could this allow me to recover the give from my account will sell Amazon and also the titles of public CZcams videos?

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      Hey, big companies like that likely prevent this formula from working on their site.

    • @chrisder1814
      @chrisder1814 Před 29 dny

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

    • @spreadsheetclass
      @spreadsheetclass Před 28 dny

      Oh I see okay, I am not experienced with API and I know very little Google Script.

  • @Vladimus3D
    @Vladimus3D Před měsícem

    why no comments?

  • @innerandoutermusic
    @innerandoutermusic Před měsícem

    THANK YOU SO MUCH!!! THIS IS AMAZING!

  • @barbaracovey
    @barbaracovey Před 2 měsíci

    Thanks, very helpful video!

  • @smokie4ever
    @smokie4ever Před 2 měsíci

    Ctrl + Shift + Down and Ctrl D are crazy, thanks

  • @CaribouDataScience
    @CaribouDataScience Před 2 měsíci

    Thanks,that was helpful.

  • @JoeHarkinsHimself
    @JoeHarkinsHimself Před 2 měsíci

    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.

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      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.

  • @yvettemendez8185
    @yvettemendez8185 Před 2 měsíci

    very helpful thanks

  • @WaterCurrent
    @WaterCurrent Před 2 měsíci

    Thank you! Soooooo much

  • @mohammediqram5367
    @mohammediqram5367 Před 2 měsíci

    Ek no

  • @VineetBhatnagar-j3w
    @VineetBhatnagar-j3w Před 2 měsíci

    how do you indent within a cell ?

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      The methods in the video were not what you were looking for? I personally just type spaces before I put the data.

  • @AnnaTsurpalev
    @AnnaTsurpalev Před 2 měsíci

    You just made my day, thank you 🙏

  • @jamsheercv9776
    @jamsheercv9776 Před 2 měsíci

    Thank you ❤

  • @jeanfrancisco4978
    @jeanfrancisco4978 Před 3 měsíci

    Thank you❤

  • @MichaelLehn-jx5eb
    @MichaelLehn-jx5eb Před 3 měsíci

    HOw can I validate against another Google Sheet document? Ex: Validation of product codes contained in Master File Google Sheet Thanks

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      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

  • @kahunamatata2045
    @kahunamatata2045 Před 3 měsíci

    took you fkn 5 minutes to say CTRL+C and CTRL+V.

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      It took you time to say that:) Some people prefer longer videos with more detail though.

  • @maz9047
    @maz9047 Před 4 měsíci

    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 👏

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I really appreciate that:) Thank you for the kind words.

  • @jms1263
    @jms1263 Před 4 měsíci

    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!

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I will keep that in mind for future updates, thank you! I am so glad that you enjoyed the template.

  • @nbk6ugg
    @nbk6ugg Před 4 měsíci

    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?

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I don't thin so in Google Sheets. Excel has a bit more functionality when it comes to the SORT function

  • @Pukwudgie_Surprise
    @Pukwudgie_Surprise Před 4 měsíci

    How do you do it on a phone?

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I don't think that there is a way to do this on the phone. The app is very limited

  • @saddamedge
    @saddamedge Před 4 měsíci

    thanks a lot..it helped

  • @argenisaguilar9045
    @argenisaguilar9045 Před 4 měsíci

    Thank you very much...

  • @user-lh8nj5on4m
    @user-lh8nj5on4m Před 4 měsíci

    thank you brother

  • @mirandasage79
    @mirandasage79 Před 5 měsíci

    Can you show how to do this with google maps using an API?

  • @luisrobertocotohernandez7033

    thanks

  • @sourabh3063
    @sourabh3063 Před 5 měsíci

    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

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      You bet! This can be fixed in the text wrapping menu, by selecting the "Clip" option.

  • @Jose-RedflagAI
    @Jose-RedflagAI Před 5 měsíci

    You made my day! Thank you sooooo much!

  • @edmundddilworth9983
    @edmundddilworth9983 Před 5 měsíci

    You have no idea how pleased I am to have found this !!!

  • @jweg4051
    @jweg4051 Před 5 měsíci

    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…

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      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

  • @jayantmishra6966
    @jayantmishra6966 Před 5 měsíci

    works

  • @toufiksoufghalem6653
    @toufiksoufghalem6653 Před 5 měsíci

    Can you do it in a phone

  • @chrisbowden9028
    @chrisbowden9028 Před 5 měsíci

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

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      Hey, unfortunately I do not currently have a video about this

  • @user-tv8ob7ou8g
    @user-tv8ob7ou8g Před 5 měsíci

    Thanks bud🤪

  • @ShaunConroy
    @ShaunConroy Před 5 měsíci

    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.

  • @teacherchipiona6508
    @teacherchipiona6508 Před 5 měsíci

    Thanks for sharing your knowledge. One of the best google sheets tutorials I've seen. Love how well you explain everything.

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      Thank you so much for the kind words! I am glad that you enjoyed this

  • @TigerTruckingAndLogistics
    @TigerTruckingAndLogistics Před 5 měsíci

    maybe y'all aren't in google sheets, but it worked perfectly for me. Thank you!!!

  • @spiritmindandnature7285
    @spiritmindandnature7285 Před 6 měsíci

    Mine still pastes the formatting, with or without the shift key.

    • @spreadsheetclass
      @spreadsheetclass Před 29 dny

      I have never heard of that before. The only times that mine has failed to work, it would not work at all.

  • @maamusika
    @maamusika Před 6 měsíci

    Excellent tutorial ! Thank you.

  • @user-pr1gd3ob9o
    @user-pr1gd3ob9o Před 6 měsíci

    Thanks