I have had a significant amount of help learning programming, Excel, and analysis. I want to share some of the resources I have used for acquiring these skills and keeping up-to-date on the latest technologies in my area of learning.
The following software is all open-source and free to use for a variety of projects. I have used all of them and will continue to do so as they provide great functionality and support for all types of media projects.
- Gimp is an open-source photo editing software.
- Audacity is a free audio and sound editing software I have used to record my podcast and various videos.
- OBS Studio or Open Broadcast Software Studio is an open-source recording software. It can be used to screen record as well as stream. It has wide functionality for recording.
- Discord is a free voice and text chat. While it was originally created for gaming, it has great functionality and includes screen-sharing, group chats, free server creation, and stream overlay. I have used this software for most of my group projects and it has worked wonderfully.
- Corey Schafer is a wonderful resource for programming, especially Python. He makes an effort to explain concepts in an easy-to-understand way.
- Brandon Foltz is a great channel for learning about statistics to help with data anlysis.
- Automate the Boring Stuff by Al Sweigart is free to read under a Creative Commons License. The entire book is available in-browser for learning the basics of Python and incorporating it into your everyday life.
While these courses are paid for on Udemy, they often have discounts or free courses available. These are courses I have taken that have helped me immensely.
- Complete Python Bootcamp by Jose Portilla is a great introduction into Python. The course teaches everything from the basics of programming to OOP and different Python libraries.
- The Python Mega Course by Ardit Sulce dives head first into creating apps with Python. These are real-world projects from websites to face recognition that introduce you to a wide array of Python libraries.
- The Ultimate MySQL Bootcamp by Colt Steele introduces you to MySQL through the Cloud9 in-browser IDE.
- Microsoft Excel - Excel from Beginner to Advanced by Kyle Pew is a great course for learning Excel. It is a three-part course that takes you from Excel basics to learning PivotTables, advanced functions, macros, and VBA.
- Pythonprogramming.net contains a variety of tutorials for different Python projects. The authors usually include Youtube tutorials on their posts and walk you step-by-step through creating scripts and programming a variety of apps or bots.
I also want to include websites that keep me up-to-date with new technologies, allow me to ask questions and find answers, and support my efforts in general.
- Reddit a wonderful resource for all types of programming and Excel questions: /r/Learnprogramming for all programming languages, /r/Python for news and posts about Python, /r/WebDev for web development news and posts, /r/Excel for learning Microsoft Excel and asking questions about difficult Excel issues.
There are many more resources I have used in my journey, however, I have found these to be the most useful and the ones I find myself coming back to for learning.