Spreadsheet Point
Spreadsheet Point
  • Видео 182
  • Просмотров 5 035 067
How to Use the NOT Function in Excel to Filter Data Fast!
Learn how to use the powerful NOT function in Excel in this quick tutorial from Spreadsheet Point.
Full Guide: spreadsheetpoint.com/excel/not-function/
This video explains how to reverse logical statements, create complex conditions and formulas, and combine the NOT function with other functions like AND.
Follow along with examples of filtering products based on price and category to gain a deeper understanding of this versatile function. Enhance your Excel skills and make your data analysis more efficient!
In this video:
00:00 Introduction to the NOT Function in Excel
00:25 Basic Example: Using NOT with a Price Condition
01:18 Combining NOT with AND for Complex Conditions
02:05 Filtering Data w...
Просмотров: 32

Видео

The Easiest Way to Make Macros in Excel
Просмотров 81День назад
Here's how to create Microsoft Excel macros. My guide talks about their benefits and shows examples of common macros that can save you time. The video also covers how to enable the Developer tab, record a macro for sorting data, and assign macros to buttons for easy reuse. Additionally, you'll see how to create a macro to format data for presentation. 00:00 Introduction to Excel Macros 00:44 Se...
How to Use the SCAN Function in Excel for Running Totals & More!
Просмотров 9 тыс.14 дней назад
Full Guide: spreadsheetpoint.com/excel/calculate-running-total-with-the-scan-function/ In this video, learn about the new SCAN function in Excel, released in early 2024, and how it can simplify calculating running totals and other operations. Discover how to check if you have the SCAN function, the basics of using it with the LAMBDA function, and practical examples such as summing sales data an...
Mastering the COUNTIF Function in Excel: Step-by-Step Tutorial
Просмотров 35421 день назад
Full Guide: spreadsheetpoint.com/excel/how-to-use-the-countif-excel-function/ In this tutorial, you will learn how to use the COUNTIF function in Excel to count numbers or specific items within a sheet based on your criteria. The video explains how to count the occurrences of a name, number of hours, or instances of a specific value, even if it includes a certain string of text within a range. ...
How to Make a Drop Down Menu in Excel (plus Formatting and Formulas)
Просмотров 14621 день назад
Source: spreadsheetpoint.com/excel/drop-down-list/ How to Create a Drop Down Menu in Excel & Use Formulas In this video, you'll learn how to create drop down menus in Excel and use them within formulas. Step-by-step, you'll see how to set up a simple table, add drop down menus using both manual entry and cell range selection, and implement IF statements to validate answers. Additionally, the vi...
How to Highlight Text in Google Sheets (The easy way, and with conditional formatting!)
Просмотров 177Месяц назад
Full Guide: spreadsheetpoint.com/formulas/if-contains-google-sheets-formula/ If you've ever wanted to highlight text in Google Sheets, here's the easiest way to do it. I'll show you how to use the REGEXMATCH function, how to nest it inside of an IF function, and how it looks when you highlight your "TRUE" statements with conditional formatting. 00:00 Intro 00:09 REGEXMATCH to Check for Text 01:...
Spreadsheet for Rental Property [Free Template + Guide]
Просмотров 1,5 тыс.Месяц назад
Full Guide (with template): spreadsheetpoint.com/templates/spreadsheet-for-rental-property/] Need a rental property spreadsheet template for Google Sheets or Excel? Check mine out. I wrote a full article about it, too. Keep track of income, expenses, and more with this rental property spreadsheet template. You can also add market value, deposits held, and deposit adjustments. It's super handy! ...
How to Zoom Out in Google Sheets
Просмотров 112Месяц назад
Full Guide: spreadsheetpoint.com/zoom-out-google-sheets/ Here are three easy ways to zoom out in Google Sheets. The first is the zoom dropdown menu in the shortcut bar. The second is with the view menu. And the third is a simple keyboard shortcut. 00:00 Control Zoom with the Shortcut Bar 00:29 Use the View Menu 00:36 Use the Keyboard Shortcut Subscribe to this RUclips channel to get updates on ...
The Best Grocery List? It's Google Sheets.
Просмотров 4914 месяца назад
Get the template (and read the full article): spreadsheetpoint.com/templates/google-sheets-grocery-list-template/ My template lets you make a grocery list at home, then take it to the store on your phone. Just make sure you have the Google Sheets app downloaded. Then, make a copy of my template. You can update it before you leave and click the checkboxes while you shop. Subscribe to this RUclip...
How to Hyperlink in Google Sheets (4 Ways in 2 Minutes)
Просмотров 6514 месяца назад
Full Guide: spreadsheetpoint.com/google-sheets-hyperlink/ Here's how to Hyperlink in Google Sheets. 00:00 Two Easy Methods 00:37 The Hyperlink Function My full guide has even more examples including some limitations of the hyperlink function. This can be a powerful feature, and it's built into the platform. Subscribe to this RUclips channel to get updates on Google Sheets Tips and Google Sheets...
How to Import Stock Data into Google Sheets
Просмотров 7024 месяца назад
To import historical stock prices into Google Sheets, pull in a CSV file with the import tool. In this case, I evaluated the Reddit IPO. It uses the stock ticker RDDT. I'll show you where to find the data as a CSV file, how to upload it to Google Sheets, and some easy ways to start playing with your data. Full Guide: spreadsheetpoint.com/how-to-import-stock-prices-into-google-sheets/ 00:00 Intr...
Google Sheets Invoice Spreadsheet Template with Discounts
Просмотров 3544 месяца назад
Full Article: spreadsheetpoint.com/templates/google-sheets-invoice-template/ Here's an easy upgrade to the existing Invoice spreadsheet template in Google Sheets. Short version: I added a line for discounts. It saves time, so you can easily add a discount to your invoice when clients pay up front or subscribe for a service. Subscribe to this RUclips channel to get updates on Google Sheets Tips ...
How to Use Conditional Formatting in Google Sheets
Просмотров 6984 месяца назад
How to Use Conditional Formatting in Google Sheets
How to Use the Multiple Project Manager Template in Excel
Просмотров 8185 месяцев назад
How to Use the Multiple Project Manager Template in Excel
How to Apply Formulas Using an Absolute Reference Cell in Google Sheets
Просмотров 5765 месяцев назад
How to Apply Formulas Using an Absolute Reference Cell in Google Sheets
How to Use ARRAYFORMULA in Google Sheets
Просмотров 4465 месяцев назад
How to Use ARRAYFORMULA in Google Sheets
Loan Amortization Spreadsheet Templates
Просмотров 5205 месяцев назад
Loan Amortization Spreadsheet Templates
Using VLOOKUP to Pull Data from Another Workbook in Google Sheets
Просмотров 1,6 тыс.5 месяцев назад
Using VLOOKUP to Pull Data from Another Workbook in Google Sheets
How to Add Drop Down Lists in Excel
Просмотров 1,1 тыс.5 месяцев назад
How to Add Drop Down Lists in Excel
How to Calculate Ages in Google Sheets
Просмотров 1,6 тыс.6 месяцев назад
How to Calculate Ages in Google Sheets
How to Set Print Area in Excel (Including Multiple Ranges)
Просмотров 1,6 тыс.6 месяцев назад
How to Set Print Area in Excel (Including Multiple Ranges)
How to Break Links in Excel
Просмотров 2,6 тыс.6 месяцев назад
How to Break Links in Excel
How to Hide Gridlines in Google Sheets
Просмотров 4036 месяцев назад
How to Hide Gridlines in Google Sheets
How Count Cells With Specific Text in Google Sheets
Просмотров 1,1 тыс.6 месяцев назад
How Count Cells With Specific Text in Google Sheets
How to Freeze Multiple Rows in Excel
Просмотров 5726 месяцев назад
How to Freeze Multiple Rows in Excel
How to Subtract in Google Sheets (single cells and full arrays)
Просмотров 1,2 тыс.6 месяцев назад
How to Subtract in Google Sheets (single cells and full arrays)
How to Wrap Text in Google Sheets
Просмотров 2,4 тыс.6 месяцев назад
How to Wrap Text in Google Sheets
How to Make a Heatmap in Google Sheets
Просмотров 2586 месяцев назад
How to Make a Heatmap in Google Sheets
How to Compare Columns in Google Sheets
Просмотров 9 тыс.7 месяцев назад
How to Compare Columns in Google Sheets
Investment Tacking Spreadsheet Template Demo
Просмотров 1567 месяцев назад
Investment Tacking Spreadsheet Template Demo

Комментарии

  • @petemoore1805
    @petemoore1805 10 часов назад

    THX. CAN YOU INSTRUCT SHEETS TO DOWNLOAD THAT FILE EVERY TIME YOU OPEN SHEETS? REMOVE THE MANUAL CSV IMPORT?

    • @SpreadsheetPoint
      @SpreadsheetPoint 9 часов назад

      No problem! I think you could run a script for that.

  • @NewspaperStudy-n5g
    @NewspaperStudy-n5g 3 дня назад

    as you told the Alt+7 won't work if don't hv numerical key board. so, any other way to insert bullet in one cell like this step ?

  • @sharbux
    @sharbux 6 дней назад

    I'm finding it will only wrap cells that already have text in them. How do I format a whole column so that each cell automatically wraps any text that I subsequently enter? I'm using a form to send data, but then I have to keep going in and manually wrapping the text.

    • @SpreadsheetPoint
      @SpreadsheetPoint 6 дней назад

      If it's happening even after you've already formatted the row, you may want to make a macro that formats the new data for you. It should look something like this: function autoWrapText() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getDataRange(); range.setWrap(true); } function onFormSubmit(e) { var sheet = e.range.getSheet(); var lastRow = sheet.getLastRow(); var range = sheet.getRange(lastRow, 1, 1, sheet.getLastColumn()); range.setWrap(true); }

    • @sharbux
      @sharbux 6 дней назад

      @@SpreadsheetPoint I will give that a try. Thank you

  • @CAN_AM_RZR
    @CAN_AM_RZR 7 дней назад

    Thx

  • @philipgaliza3771
    @philipgaliza3771 7 дней назад

    1. There's a lot more simpler excel functions to do what you wanted to showcase, and you actually showed it at the beginning 2. Lambda is quite a complex function, and to use it inside SCAN without properly explaining it really defeats the purpose 3. You should have showcased SCAN first without LAMBDA, so people know what SCAN does on its own without really relying on an advanced excel formula

    • @SpreadsheetPoint
      @SpreadsheetPoint 6 дней назад

      Thanks for the feedback! I'm glad you liked the beginning of the video. I'll make an explainer of LAMBDA in the future.

  • @Abdikaaf
    @Abdikaaf 7 дней назад

    I forgot to mentioned that I’m using atom as a text editor. Thanks

  • @Abdikaaf
    @Abdikaaf 7 дней назад

    Great video! I follow your instructions but somehow I couldn’t find the requirement.txt. Do you know what had happened? Again, I appreciate your help. Thanks❤

  • @ghandimauler
    @ghandimauler 7 дней назад

    Thank you. And to Google: WTF!???! If I want a special character in SHEETS, I have to instantiate it FIRST in DOCS and THEN it needs COPIED OVER? Isn't the first time, but I will say some people at Google need a good stiff boot. And we wonder, as people in technology, why the average user is frustrated with technology. We could do so much better.

  • @RushdiAshraff
    @RushdiAshraff 9 дней назад

    Thanks alot, it works fine.. you saved my day

  • @mikesmale1853
    @mikesmale1853 12 дней назад

    Awesome clear and concise explanation. Gold. I believe you said row when referring to a column? Well that’s how it works in a database. Apologies if excel is different.

  • @richardmensah3327
    @richardmensah3327 13 дней назад

    I cant find the dataset

    • @SpreadsheetPoint
      @SpreadsheetPoint 10 дней назад

      The article has now been updated. You can access the dataset there (it's in the second tab of the file).

  • @richardmensah3327
    @richardmensah3327 13 дней назад

    Kindly provide the data you use so we can try our hands on it.

    • @SpreadsheetPoint
      @SpreadsheetPoint 13 дней назад

      Great feedback. I'll include my templates in my article (linked above) so you can test the data yourself too.

  • @w6263
    @w6263 15 дней назад

    You are too jargonated! You need to break down your language in to laymens terms so people understand what you are talking about.

    • @SpreadsheetPoint
      @SpreadsheetPoint 13 дней назад

      Thanks for the feedback! Is there a specific section of the video that's toughest to understand? I'd love to make sure everything makes sense.

  • @alise4377
    @alise4377 15 дней назад

    Thank you so much!!!

  • @matthewsouders
    @matthewsouders 16 дней назад

    Wonder if you can do this in the “comment “ section?

    • @SpreadsheetPoint
      @SpreadsheetPoint 16 дней назад

      You can copy a link to a cell in a comment, if that helps!

  • @nobodybutme-cs4iv
    @nobodybutme-cs4iv 16 дней назад

    it doesnt work

  • @sandeeppandalath5218
    @sandeeppandalath5218 20 дней назад

    Thanks a lot

  • @jona0007
    @jona0007 21 день назад

    YOU SAVED MY DAY, THANK YOU

  • @Billythekid141
    @Billythekid141 22 дня назад

    0;-0;;@

  • @Nauman-pathan
    @Nauman-pathan 22 дня назад

    Thank you !!

  • @jannclarencemanguerra6257
    @jannclarencemanguerra6257 23 дня назад

    had a problem for create PO , not working

    • @SpreadsheetPoint
      @SpreadsheetPoint 22 дня назад

      Thanks for the comment! Can you describe the issue you're facing?

    • @jannclarencemanguerra6257
      @jannclarencemanguerra6257 22 дня назад

      @@SpreadsheetPoint In POS Sheet, after the add items, then click on Create PO button, it didn't appear in Print PO sheet the items i Add

  • @PipsHunter_Adnan
    @PipsHunter_Adnan 24 дня назад

    Talha bahi, very nice Vidoe and good explanation

  • @fifiireland
    @fifiireland 28 дней назад

    clear and short-excellent tutorial!

  • @patriciadanna7433
    @patriciadanna7433 Месяц назад

    Thank you! I deleted by accident. You're a lifesaver.

  • @valmore702
    @valmore702 Месяц назад

    This was PERFECT!! Thank you THANK YOU! you saved my homework!

  • @petraral5086
    @petraral5086 Месяц назад

    The function does not work properly for my sheet for some reason. It always returns 0

    • @SpreadsheetPoint
      @SpreadsheetPoint 28 дней назад

      It sounds like it might not be finding any "true" examples of your conditional statement.

  • @alexng8417
    @alexng8417 Месяц назад

    Does it exclude Saturday and sunday?

  • @nk_BioBuG
    @nk_BioBuG Месяц назад

    How to convert pop out date in mm/dd/yyyy in google sheets 2024

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      Thanks for the comment! What do you mean by "pop out date"?

    • @nk_BioBuG
      @nk_BioBuG Месяц назад

      @@SpreadsheetPoint You double click on the cell and the calendar pops out and then you can select the date from there :)

  • @phungmoe2302
    @phungmoe2302 Месяц назад

    How can I reverse this process whereby I can have combined data entries?

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      Do you mean combining data from multiple surveys? If so, you could just import the data from multiple surveys into a third sheet. I hope this helps!

  • @lordia79
    @lordia79 Месяц назад

    thank you very mutch!! Greetings from Italy

  • @laurachinyere
    @laurachinyere Месяц назад

    Nice contents. You gained a subscriber and a follower. I'm an Excel enthusiast. Hoping to gain more knowledge.

  • @mikinozz
    @mikinozz Месяц назад

    Thank you, mate. You saved me.

  • @sueapel9573
    @sueapel9573 Месяц назад

    Also somehow my sheet has blank sheet in between sheets that have data. How do I delete those sheets

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      You can right click on the blank sheet tab, then click delete. Unless you're looking to do this with a large number of pages?

  • @sueapel9573
    @sueapel9573 Месяц назад

    It didn''t tell you how to print 2 pages. It only shows current page.

    • @SpreadsheetPoint
      @SpreadsheetPoint 22 дня назад

      It's in that first part of the video. Choose "selected cells" instead of the current page. I hope this helps!

  • @hajibrutus
    @hajibrutus Месяц назад

    Beautifully explained Summit Bhai.

  • @molaypatra9113
    @molaypatra9113 Месяц назад

    Thank you buddy...

  • @oluchukwuudeh32
    @oluchukwuudeh32 Месяц назад

    "Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings > Manage App Execution Aliases." This is the error I'm getting while trying tocreate the environment

  • @CandiRayne16
    @CandiRayne16 Месяц назад

    This worked to help me create my “if, then” formula

  • @vickib4063
    @vickib4063 Месяц назад

    I deleted a file by accident. It is not in the bin folder and everything in the spread has gone. What can I do?

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      It's worth checking version history (and it's worth downloading a backup once a week, just in case).

    • @vickib4063
      @vickib4063 Месяц назад

      @@SpreadsheetPoint Thank you. I found another video on recovering versions of google sheets and I am happy to say the method worked. Thanks for repying though.

  • @laraguerreiro5667
    @laraguerreiro5667 Месяц назад

    funcionou!!!!

  • @NicholasJordanBollinger
    @NicholasJordanBollinger Месяц назад

    Why B2?

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      Great question! B2 is the changable placeholder in this function. Note that unlike $A$2:$A$9, B2 doesn't have any $ preceding the characters. That means the function first runs in B2, then it runs in B3, then in B4, etc. B2 is just the top cell in the series. I hope this helps!

    • @NicholasJordanBollinger
      @NicholasJordanBollinger Месяц назад

      @@SpreadsheetPoint Wonderful! Thank you, friend.

  • @rasesrajput8505
    @rasesrajput8505 2 месяца назад

    How can I change Date in to words? for example 01/01/2004 into :First January Two Thousand Four"

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      That's an awesome question. It's a little more complex than what we've done in the video. First, you need to extract the day, then the month, then the year. Then you'll need to convert each to words.

  • @BrittanyBekas
    @BrittanyBekas 2 месяца назад

    Just what I was looking for! Thank you so much!!!

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      I'm so happy it helped. Thanks for the comment!

  • @Hologhoul
    @Hologhoul 2 месяца назад

    What's the '1 simple click' option mentioned in the title?

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      Thanks so much for the question! It's the toolbar. I hope this helps!

    • @Hologhoul
      @Hologhoul Месяц назад

      @@SpreadsheetPoint Where on the toolbar, I don't see it? I can only find it via format > wrapping > wrap?

    • @squidwordsmith
      @squidwordsmith Месяц назад

      @@Hologhoul watch from 1:07, where they highlight the toolbar, the same icon you see when pressing format > wrapping is on the toolbar. that's what they mean when they say 1-simple click.

  • @user-qz2ly3vo7k
    @user-qz2ly3vo7k 2 месяца назад

    Hi sumit, It shows some security cautious, I allow the same even not working...

  • @a_rojas
    @a_rojas 2 месяца назад

    Dude, I was starting to think i'd never get the answer I was looking for. Thank you!!!

  • @EZ5965
    @EZ5965 2 месяца назад

    Gracias!

  • @njvanheerden2157
    @njvanheerden2157 2 месяца назад

    This was very helpfull thank you.

  • @user-pv7my8xd8s
    @user-pv7my8xd8s 2 месяца назад

    Bro u r literally a life saver

  • @madandeshpande3961
    @madandeshpande3961 2 месяца назад

    very useful! can we convert spreadsheet horizontal data into vertical?

    • @SpreadsheetPoint
      @SpreadsheetPoint Месяц назад

      Yes! It's the TRANSPOSE function. It looks like this: =TRANSPOSE(A1:C1)