How it's done: Janice Wong's (JaniceStudies) favorite Google Sheets feature

For Janice, active recall is one of the top study methods for memorizing anything and everything, and using #GoogleSheets is one of the simplest and most effective ways to apply this method.
Learn More →goo.gle/3df5ymi
Try Google Sheets for yourself → goo.gle/3lA9kv5
What is Google Workspace? → goo.gle/3NY0iUL
Set up Google Workspace →goo.gle/3InFfYb
Subscribe to Google Workspace →goo.gle/Google...
Follow Google Workspace on Twitter → goo.gle/39w3Vm2
Follow Google Workspace on Facebook → goo.gle/3mRx7a4
Follow Google Workspace on LinkedIn → goo.gle/3tzmRXF
Follow Google Workspace on Instagram → goo.gle/3HrQikk
Product: Google Workspace
#GoogleWorkspaceTutorial
#GoogleWorkspace

[@Wingedmagician]

This is 10/10 advice. I also love how manageable and how easy to backup, copy, edit, etc the data is vs flashcards

[@khlarie]

Hi! May I know how did she do that? Coloring specific tile (yellow, green, red) and also temporarily hiding the answers? I hope you can help me, i wanna start doing this.. Thank you in advance!

[@sekar9901]

​@@khlarie I use conditional formating.
I make a small column beside the question, for example column A. Column B is the question. I make conditional formating in column B, =$A2="-" then I choose yellow. You can modified the symbol "-" and color. So every time i type "-" in the column A, the column B will change the color to yellow.

[@do7425]

Thank you Ali Abdaal for this method...

[@googleworkspace]

Try Google Workspace For Free Now → goo.gle/3tFbgXp

[@dianac3977]

thank you!!!

[@alittlebitofpeace]

Love this

[@brendamartinez6955]

Good

[@yusufbas035]

this is so genius

[@SamuelAngelo0758]

É mais produtivo você salvar o arquivo do Google Sheets em CSV., colocar o arquivo no ANKI, e você terá todos o seu deck com perguntas e respostas, front and back with yours questiona and awnsers.

[@SamuelAngelo0758]

SRS in Anki, upload the file of Google Sheets.

[@PeterOliver13]

?

[@SamuelAngelo0758]

​@@PeterOliver13Upload the deck of Google Sheets to Anki

[@NicholayN]

Eu gosto que você switched between Portuguese and English randomly 😂
But you make a good point... Why spend all that effort building a complex spreadsheet when you can use an existing active recall application and back up to an open data format?

[@elenimimani3769]

That’s what anki does

[@Josh_J23]

should've given credit to Ali Abdaal

[@smuggymcsmugface2142]

Or just use Anki like a normal person

[@iamnoone78647]

but takes a lotta time

[@UnMinutoViajando]

obviously, for exams takes too much time but this is why most people learn nothing because they think they have no time but waste 9 hours on social media instead. Take care.

[@iamnoone78647]

@@UnMinutoViajando ok free advicer

[@iskiiwizz536]

LOL@@iamnoone78647

[@entsubar8248]

​@@UnMinutoViajandotou you can copy the whole lecture past it in chat gpt and ask it to generate questions and Answers based on your lectures it's much more fast I always use it

[@goof.7874]

@@UnMinutoViajando still typing down questions and long answers when the material is in books and notebooks is inefficient and will not help in practicing answers by writing them in rough notebooks/registers.