Spreadsheet Class
Spreadsheet Class
  • 69
  • 1 221 433
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.
Переглядів: 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

КОМЕНТАРІ

  • @PAK_X1
    @PAK_X1 15 днів тому

    Great job. Thank you, legend. 💚🥇👏

  • @sbanerjee00170017
    @sbanerjee00170017 16 днів тому

    WORST CONTAIN WRITER LIKE DOG

  • @htethtetwai3962
    @htethtetwai3962 18 днів тому

    Thanks for sharing.

  • @letsgoviral777
    @letsgoviral777 23 дні тому

    Thank you.

  • @LimittedGamesCS
    @LimittedGamesCS 27 днів тому

    Will this data auto update the price within the excel sheet?

  • @SiddhantSingh-n9k
    @SiddhantSingh-n9k 28 днів тому

    This hid the menu bar not the toolbar....

  • @allanwambia7913
    @allanwambia7913 Місяць тому

    What if you want first letter to be capital

  • @ifeoluwaosho2605
    @ifeoluwaosho2605 Місяць тому

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

    • @spreadsheetclass
      @spreadsheetclass Місяць тому

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

  • @emplore
    @emplore Місяць тому

    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 Місяць тому

    Thank you, is there a template for bakers?

  • @kjell5352
    @kjell5352 Місяць тому

    Thank you!

  • @SarahBatsanis
    @SarahBatsanis 2 місяці тому

    Amazing! Thankyou

  • @nk_BioBuG
    @nk_BioBuG 2 місяці тому

    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 2 місяці тому

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

  • @ngonewsworld
    @ngonewsworld 2 місяці тому

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

  • @quantum2330
    @quantum2330 2 місяці тому

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

  • @DinoRodriguez
    @DinoRodriguez 2 місяці тому

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

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

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

  • @OmarNasrallah-q2b
    @OmarNasrallah-q2b 2 місяці тому

    What about hyper link text?

  • @chrisder1814
    @chrisder1814 2 місяці тому

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

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

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

    • @chrisder1814
      @chrisder1814 2 місяці тому

      @@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 2 місяці тому

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

  • @Vladimus3D
    @Vladimus3D 2 місяці тому

    why no comments?

  • @innerandoutermusic
    @innerandoutermusic 3 місяці тому

    THANK YOU SO MUCH!!! THIS IS AMAZING!

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

      You bet, I am glad that you like the guitar tabs!

  • @barbaracovey
    @barbaracovey 3 місяці тому

    Thanks, very helpful video!

  • @smokie4ever
    @smokie4ever 3 місяці тому

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

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

      You bet! They do make things so much faster haha

  • @CaribouDataScience
    @CaribouDataScience 3 місяці тому

    Thanks,that was helpful.

  • @JoeHarkinsHimself
    @JoeHarkinsHimself 3 місяці тому

    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 2 місяці тому

      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 3 місяці тому

    very helpful thanks

  • @WaterCurrent
    @WaterCurrent 3 місяці тому

    Thank you! Soooooo much

  • @mohammediqram5367
    @mohammediqram5367 3 місяці тому

    Ek no

  • @VineetBhatnagar-j3w
    @VineetBhatnagar-j3w 3 місяці тому

    how do you indent within a cell ?

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

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

  • @AnnaTsurpalev
    @AnnaTsurpalev 4 місяці тому

    You just made my day, thank you 🙏

  • @jamsheercv9776
    @jamsheercv9776 4 місяці тому

    Thank you ❤

  • @jeanfrancisco4978
    @jeanfrancisco4978 4 місяці тому

    Thank you❤

  • @MichaelLehn-jx5eb
    @MichaelLehn-jx5eb 4 місяці тому

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

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

      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 4 місяці тому

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

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

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

  • @maz9047
    @maz9047 5 місяців тому

    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 2 місяці тому

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

  • @jms1263
    @jms1263 5 місяців тому

    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 2 місяці тому

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

  • @nbk6ugg
    @nbk6ugg 5 місяців тому

    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 2 місяці тому

      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 5 місяців тому

    How do you do it on a phone?

    • @spreadsheetclass
      @spreadsheetclass 2 місяці тому

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

  • @saddamedge
    @saddamedge 5 місяців тому

    thanks a lot..it helped

  • @argenisaguilar9045
    @argenisaguilar9045 5 місяців тому

    Thank you very much...

  • @AndresGuzman-z9z
    @AndresGuzman-z9z 5 місяців тому

    thank you brother

  • @mirandasage79
    @mirandasage79 6 місяців тому

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

  • @luisrobertocotohernandez7033
    @luisrobertocotohernandez7033 6 місяців тому

    thanks

  • @sourabh3063
    @sourabh3063 6 місяців тому

    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 2 місяці тому

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

  • @edmundddilworth9983
    @edmundddilworth9983 6 місяців тому

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

  • @jweg4051
    @jweg4051 6 місяців тому

    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 2 місяці тому

      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 6 місяців тому

    works

  • @toufiksoufghalem6653
    @toufiksoufghalem6653 6 місяців тому

    Can you do it in a phone

  • @chrisbowden9028
    @chrisbowden9028 6 місяців тому

    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 2 місяці тому

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

  • @NatalieVictoria-f8p
    @NatalieVictoria-f8p 6 місяців тому

    Thanks bud🤪

  • @ShaunConroy
    @ShaunConroy 6 місяців тому

    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.