Google Sheets Advanced Tutorial

[@LearnitTraining]

Exercise Files: learnitanytime.com/p/exercise-files-google-sheets-advanced-tutorial-2023

[@NisanUHTV]

Grateful For notifying me ❤ Waiting eargly for this powerful presentation

[@LearnitTraining]

Hope you learned everything you wanted to!

[@KarenGravatt-i4y]

This is such a great video but how to I download exercise files to google doc. They keep going to my excel.

[@LearnitTraining]

This article may help: robots.net/tech/how-to-open-an-excel-file-in-google-sheets/

[@berlysanscartier7526]

you need to save the files into your google drive to open them as google sheets

[@kittohernandez3724]

You have an incorrect formula at 40:00 at cell E2 . It should be >2000.

[@LearnitTraining]

Noted!

[@heyarmaan]

🎉 Waiting for The Miracle | From Bangladesh 🎉

[@LearnitTraining]

See you Friday!

[@heyarmaan]

I'm waiting eagerly to see you(@@LearnitTraining) 🥰

[@educationworld4611]

Also, how to copy and insert the copied rows in sheets like Excel?

[@LearnitTraining]

To copy and insert rows in Google Sheets, you can use the following methods: Select the cells you want to copy, right-click and select copy. Then, select the cells where you want to paste the data, right-click and select paste. Use the keyboard shortcut Ctrl + C to copy the selected rows. Then, select a new row where you want to paste the copied data, and use the keyboard shortcut Ctrl + V to paste. From Google Sheets' menu bar, select Insert > Rows. Then, to add the new rows above your selected rows, choose "Insert X Rows Above." To add the new rows below your selection, choose "Insert X Rows Below."

[@orjiprecious8592]

Nice

[@LearnitTraining]

Thanks

[@maayanzi30]

Hello, I want to make a todo list with dropdown. the a column title will be number and the b column title will be name with dropdown of a b c d names. i want that if i have the number 1 in column a1 so the dropdown is column b1 will appear. how to achieve it? thanks

[@heyarmaan]

could you upload "Complete C Programming + DSA (Data Structure and Algorithm "?

[@LearnitTraining]

We will look into it!

[@ley3scastellana18]

👏🏻👏🏻

[@LearnitTraining]

👏🏻👏🏻

[@educationworld4611]

How to protect sheet tabs in Google sheets like Excel?

[@LearnitTraining]

To protect tabs in Google Sheets, you need to: Open your Google Sheets spreadsheet and go to the tab or sheet you want to protect. Right-click the tab or sheet and choose Protect sheet. In the Protect sheets & ranges side window, make sure that the Sheet button is pressed and the proper sheet is selected. Click on Set permissions and choose who can edit the sheet. You can restrict the editing to only you or specific people. Click on Done to save the changes.

[@tbad2009]

Tutorial is about google sheets. but why all files on the video have extensions ".xlsx"?