Coding Resources


1	Topic	Type	Company	Name	Level	Links	Cost	Purchase Notes	Content Notes	Strong Recommendation	Tristan's Notes
2	VBA	Book [PDF]	Kalp Talk	Excel VBA Basics [PDF]	Beginner	https://www.kalptalk.com/post/excel-vba-basics-download-pdf	Free
3	VBA	Videos	Youtube	Excel Macro Mastery	All	https://www.youtube.com/c/Excelmacromastery/about	Free			*
4	R	Online Course	Code Academy	Learn R	Beginner	https://www.codecademy.com/learn/learn-r	Free with Upgrades	Pay to receive Certificate Student Pricing 35% off
5	R	Textbook [PDF]	Springer Textbooks	An Introduction to Statistical Learning with Applications in R	Intermediate	https://www.statlearning.com	Free	Textbook is on SRM syllabus	Student solutions: https://github.com/yahwes/ISLR		This is an amazing read for those of you at a beginner level. It explains most machine learning concepts in layman terms, and doesn’t require an in-depth knowledge of the mathematics behind the methods. One of the best things about this book is that it requires no prior knowledge of R. The end of each chapter contains a n R lab and exercises where all the methods learned are applied and explained thoroughly.
6	R	Online Course	DataCamp	Introduction to R	Beginner	https://www.datacamp.com/courses/free-introduction-to-r	Free			*
7	R	Online Course	DataCamp	Data Scientist with R	Advanced	https://www.datacamp.com/tracks/data-scientist-with-r	$399	Yearly subscription for all DataCamp courses Watch for sales, up to 70% off!
8	R	Online Course	DataCamp	Machine Learning Scientist with R	Mastery	https://www.datacamp.com/tracks/machine-learning-scientist-with-r	$399	Yearly subscription for all DataCamp courses Watch for sales, up to 70% off!
9	R	Online Course	edX	Basics of Statistical Inference and Modelling Using R	Intermediate	https://www.edx.org/course/basics-of-statistical-inference-and-modelling-using-r	Free with Upgrade	Pay to receive Certificate	Provides schedule for learning and assignments	*
10	R	Online Course	edX	Advanced Statistical Inference and Modelling Using R	Intermediate	https://www.edx.org/course/advanced-statistical-inference-and-modelling-using-r	Free with Upgrade	Pay to receive Certificate	Provides schedule for learning and assignments	*
11	Excel	Online Forum	Excel Help Forum		All	https://www.excelforum.com	Free
12	Excel	Website	Excel Easy		Beginner	https://www.excel-easy.com	Free
13	SQL	Website	W3Schools	SQL Tutorial	Beginner	https://www.w3schools.com/sql/	Free
14	SQL	Online Course	DataCamp	Introduction to SQL	Beginner	https://www.datacamp.com/courses/introduction-to-sql	Free			*
15	Python	Online Course	DataCamp	Introduction to Python	Beginner	https://www.datacamp.com/courses/intro-to-python-for-data-science	Free			*
16	Python	Online Course	DataCamp	Data Scientist with Python	Advanced	https://www.datacamp.com/tracks/data-scientist-with-python	$399	Yearly subscription for all DataCamp courses Watch for sales, up to 70% off!
17	Python	Online Course	edX	Python Basics for Data Science	Beginner	https://www.edx.org/course/python-basics-for-data-science?index=product&queryID=8d9b181ad5d840b4ee58f38db9686066&position=1	Free with Upgrade	Pay to receive Certificate	Provides schedule for learning and assignments	*
18	Python	Book [PDF]	O'Reilly	Hands-On Machine Learning with Scikit-Learn & TensorFLow	Beginner	https://upload.houchangtech.com/pdf/Hands-on_Machine_Learning.pdf	Free			*	This book was basically my bible when I was doing an internship for a data analytics team. Similar to ISLR, it is aimed at beginners but with all the application in Python instead. Some people say that it’s an alternative to ISLR for those who do Python instead of R, but I would recommend learning both. This book goes more in depth with the process of building data and model pipelines, and how to train and evaluate algorithms.
19	Python	Book	O'Reilly	Head First Python	Beginner	https://www.amazon.ca/dp/1449382673?linkCode=gs2&tag=oreilly200b-20	$46.47	Free trial available on publisher's website			Useful book for learning python, and should be paired with the above Hands-On Machine Learning book
20	Math/Stats	Book [PDF]	Stanford University	Computer Age Statistical Inference	Advanced	https://web.stanford.edu/~hastie/CASI_files/PDF/casi.pdf	Free		Provides lots of background knowledge on mathematics/statistical algorithms		This book is co-written by Bradley Efron, the genius behind the Bootstrap method. Similar to ESLII, this book dives more into the mathematical and statistical background of the algorithms. I think this book is really useful for those of you who have read ISLR and ESII, and are looking for more insight as to why these methods work, and to what degree.
21	Math/Stats	Book [PDF]	Springer Textbooks	The Elements of Statistical Learning, Data Mining, Inference, and Prediction	Advanced	https://hastie.su.domains/Papers/ESLII.pdf	Free		Provides in-depth mathematical analysis of statistical learning		ISLR (above) is based on this book. This is a great book to pair with the above reading, for those of you who like to go more in-depth both mathematically and statistically. It is a bit difficult for individuals who are less mathematically inclined, but no academic book is worth reading unless it is difficult for you (and if its not, are youreally learning anything?).
22	R	Online Course	Coursera	Machine Learning	Beginner	https://www.coursera.org/learn/machine-learning#syllabus	Free with Upgrade	Pay to receive Certificate		*	This is a very famous and world renowned course on Machine Learning, taught by the famous Andrew Ng. It is completely free (you can pay $100 to get a certificate of completion from Stanford), and consists of a variety of videos, short quizzes and online assignments that will teach you the basics of R and machine learning.