Hi all,
It’s been a busy week with many group projects kicking off, creating the traditional two-weeks-of-chaos at the start of any academic term. I’m confident that’ll all get resolved soon so I should have more time for my side-projects again soon.
📃here’s what I think you’ll find interesting this week:
🔍Valuation: open access to world-renowned valuation course (!)
💽Data: Best Data Visualization Projects of 2021
🎓Skills: MonkeyType, faster typing as a superpower
🤖Automation: Searchable Drop Down Lists in Excel
Have a great week!
🔍Valuation
Now, at the risk of repeating myself, another amazing piece of valuation content by Dr. Aswath Damodaran. But this time it’s not any content or data update, it’s open access to his excellent course in valuation that’s being taught this spring at NYU Stern (yes right now). If you have 2-3 hours to spare every week this comes highly recommended! The fact that this is freely available on YouTube goes to show how impactful the internet can be to make knowledge freely available globally.
In this session, I started with a brief introduction of the logistics of this class. During the session, I told you that that this was a class about valuatio…
💽Data
I recently discovered the wonderful art of data visualization. It is an evolving landscape full of neat unconventional ways to display data.
It makes you think about how to present data in an intuitive way and how you can go beyond the basic bar chart to present your data in an appealing and engaging way. Some of these are truly stunning!
Best Data Visualization Projects of 2021 | FlowingData
FlowingData
🎓Skills
Fast typing is the modern day superpower. People typically speak at 100-130 words per minute (WPM) but the typical typing speed is far below that. Ever since I started practicing I improved my typing speed from 80 WPM to consistently around 110 WPM now. My favorite website to practice on is MonkeyType, which you can completely customize to your liking. Not only is it great to see the improvement a little bit of deliberate practice can make, you also immediately enjoy the benefits in your day-to-day activities.
A minimalistic, customisable typing website. Test yourself in various modes, track your progress and improve your typing speed.
🤖Automation
Lastly, there is a neat upcoming Excel feature that you should be aware of.
If you have ever worked with dropdown lists (data validation lists) in Excel, you’ll know that they can get annoying pretty quickly as they grow longer. This upcoming feature, currently being rolled out for Office 365, allows you to search the drop down list. For example: typing John would filter the list to only show names that contain John so you can more easily find the right entry.
NEW! SEARCHABLE Drop Down Lists in Excel with ZERO Effort!
Finally we get SEARCHABLE drop down lists in Microsoft Excel WITHOUT writing complex formulas. There’s no VBA, no filter function. The autocomplete functiona…
⏭️Next
Thanks for reading and sticking with the newsletter, I’m still having some issues with messages being marked as spam so if that’s the case for you please take a couple of seconds to mark the message as ‘not spam’.
Feel free to share feedback, tips, or interesting things you read with me: [email protected].
Talk to you next week!