Excel vs Google sheets
Why have you chosen Excel for data analysis? Is it possible that you will create a google sheets course like an alternative tool for excel functionality? I get used to Google Sheets in my current work (balance game designer) and it will be cool to learn something new and useful about it (advanced level)?
I will definitely think about it. Thanks for the suggestion! You are right - we should have a Google sheets course. I guess the real issue is that I'll need to learn some Google Sheets skills first😅
Best,
Ned
Hi, Ned)
If you don't mind I can share Google sheets with good examples of what benefits it provides. I've been working with this tool for 6 years now, and during that time I've found many useful features to automate routine tasks.
For example, to reduce the chance of human error (grammatical errors, for example) I use such a useful feature as data validation, which allows you to create dropdown lists for the data you use as keys in your formulas.
Other very cool features are named ranges and named formulas.
The first one allows you to improve the readability of formulas (you won't always remember what's in the range your formula refers to, especially since it would be hard to understand for someone who never worked with your table before).
The second feature allows you to create your formulas. This is really cool. You define the formula once through other formulas and your 1-page long formula becomes a short readable 1-line formula that just needs to pass the right parameters (Sounds awesome, isn't it?). In my opinion, this feature is awesome because it allows you to implement any user needs and turns tables almost into a programming language. Anyway, I am ready to share my experience in automating routine processes in Google sheets.
Feel free to contact me on my Telegram https://t.me/Lextra_royals or by email at Lextraroyals@gmail.com.
Best regards,
Olga.