![Spreadsheet Point](/img/default-banner.jpg)
- Видео 182
- Просмотров 5 035 067
Spreadsheet Point
США
Добавлен 31 окт 2015
This RUclips channel is dedicated to sharing useful Google Sheets tips and tutorials.
Here you can find videos on various Google Spreadsheet topics such as formulas, charting, Google Apps Scripts, shortcuts, and many useful features/functionalities.
This RUclips channel is managed by Sumit Bansal, who also creates written tutorials on his site - spreadsheetpoint.com/
Here you can find videos on various Google Spreadsheet topics such as formulas, charting, Google Apps Scripts, shortcuts, and many useful features/functionalities.
This RUclips channel is managed by Sumit Bansal, who also creates written tutorials on his site - spreadsheetpoint.com/
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...
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 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
THX. CAN YOU INSTRUCT SHEETS TO DOWNLOAD THAT FILE EVERY TIME YOU OPEN SHEETS? REMOVE THE MANUAL CSV IMPORT?
No problem! I think you could run a script for that.
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 ?
The formula should do it: =CHAR(8826)
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.
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); }
@@SpreadsheetPoint I will give that a try. Thank you
Thx
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
Thanks for the feedback! I'm glad you liked the beginning of the video. I'll make an explainer of LAMBDA in the future.
I forgot to mentioned that I’m using atom as a text editor. Thanks
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❤
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.
Thanks alot, it works fine.. you saved my day
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.
I cant find the dataset
The article has now been updated. You can access the dataset there (it's in the second tab of the file).
Kindly provide the data you use so we can try our hands on it.
Great feedback. I'll include my templates in my article (linked above) so you can test the data yourself too.
You are too jargonated! You need to break down your language in to laymens terms so people understand what you are talking about.
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.
Thank you so much!!!
My pleasure!
Wonder if you can do this in the “comment “ section?
You can copy a link to a cell in a comment, if that helps!
it doesnt work
What kind of error are you seeing?
Thanks a lot
YOU SAVED MY DAY, THANK YOU
0;-0;;@
Thank you !!
had a problem for create PO , not working
Thanks for the comment! Can you describe the issue you're facing?
@@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
Talha bahi, very nice Vidoe and good explanation
clear and short-excellent tutorial!
Thank you!
Thank you! I deleted by accident. You're a lifesaver.
This was PERFECT!! Thank you THANK YOU! you saved my homework!
The function does not work properly for my sheet for some reason. It always returns 0
It sounds like it might not be finding any "true" examples of your conditional statement.
Does it exclude Saturday and sunday?
No, this only counts the work week.
How to convert pop out date in mm/dd/yyyy in google sheets 2024
Thanks for the comment! What do you mean by "pop out date"?
@@SpreadsheetPoint You double click on the cell and the calendar pops out and then you can select the date from there :)
How can I reverse this process whereby I can have combined data entries?
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!
thank you very mutch!! Greetings from Italy
Nice contents. You gained a subscriber and a follower. I'm an Excel enthusiast. Hoping to gain more knowledge.
Thank you! And welcome!
Thank you, mate. You saved me.
Also somehow my sheet has blank sheet in between sheets that have data. How do I delete those sheets
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?
It didn''t tell you how to print 2 pages. It only shows current page.
It's in that first part of the video. Choose "selected cells" instead of the current page. I hope this helps!
Beautifully explained Summit Bhai.
Thank you buddy...
"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
This worked to help me create my “if, then” formula
I deleted a file by accident. It is not in the bin folder and everything in the spread has gone. What can I do?
It's worth checking version history (and it's worth downloading a backup once a week, just in case).
@@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.
funcionou!!!!
Why B2?
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!
@@SpreadsheetPoint Wonderful! Thank you, friend.
How can I change Date in to words? for example 01/01/2004 into :First January Two Thousand Four"
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.
Just what I was looking for! Thank you so much!!!
I'm so happy it helped. Thanks for the comment!
What's the '1 simple click' option mentioned in the title?
Thanks so much for the question! It's the toolbar. I hope this helps!
@@SpreadsheetPoint Where on the toolbar, I don't see it? I can only find it via format > wrapping > wrap?
@@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.
Hi sumit, It shows some security cautious, I allow the same even not working...
Dude, I was starting to think i'd never get the answer I was looking for. Thank you!!!
Gracias!
This was very helpfull thank you.
Bro u r literally a life saver
very useful! can we convert spreadsheet horizontal data into vertical?
Yes! It's the TRANSPOSE function. It looks like this: =TRANSPOSE(A1:C1)