Links

Excel Related

https://www.google.co.uk/search?q=excel+autorecover+wrong+files&oq=excel+autorecover+wrong+files&aqs=chrome..69i57.4682j0j7&sourceid=chrome&ie=UTF-8

https://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba

https://www.mrexcel.com/forum/excel-questions/456002-changing-scope-named-range.html
https://exceljet.net/named-ranges

https://computers.tutsplus.com/tutorials/advanced-pivottables-combining-data-from-multiple-sheets–cms-21190

https://stackoverflow.com/questions/41724275/collapse-some-groups-not-all-using-vba
https://stackoverflow.com/questions/13337267/grouping-rows-in-vba

https://stackoverflow.com/questions/22309471/pass-all-the-range-names-in-an-excel-workbook-to-an-array

https://www.experts-exchange.com/questions/26549515/How-to-reshape-data-from-WIDE-to-LONG-format-in-Excel.html

Powerpoint

http://www.pptools.com/free/FAQ00002-THOR-The-Hammer.htm

http://www.pptfaq.com/FAQ00481_Export_the_notes_text_of_a_presentation.htm

SQL Related

https://technet.microsoft.com/en-us/library/ms188263(v=sql.105).aspx

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/calculating-mean-median-and-mode-with-sq/
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/it-s-hard-to-be/

https://stackoverflow.com/questions/10432086/remove-all-spaces-from-a-string-in-sql-server

R Related

http://stcorp.nl/R_course/tutorial_code_organisation.html

http://www.statmethods.net/input/valuelabels.html

https://stackoverflow.com/questions/3588961/specifying-formula-in-r-with-glm-without-explicit-declaration-of-each-covariate

https://stackoverflow.com/questions/24496378/r-using-str-split-and-unlist-to-create-two-columns

https://stackoverflow.com/questions/9563368/create-stacked-barplot-where-each-stack-is-scaled-to-sum-to-100

https://stackoverflow.com/questions/40754680/how-to-resize-ggplot-graph-in-r-notebook

https://stackoverflow.com/questions/4862178/remove-rows-with-nas-missing-values-in-data-frame

http://www.statmethods.net/advgraphs/ggplot2.html

https://rviews.rstudio.com/2016/10/19/creating-interactive-plots-with-r-and-highcharts/

Corsstab – a crosstab function for survey data

https://www.r-bloggers.com/contingency-tables-with-gmodels-in-r/

http://www.statmethods.net/stats/frequencies.html

https://www.regular-expressions.info/rlanguage.html

Statistics Related

http://www.statmethods.net/advstats/glm.html

https://stats.stackexchange.com/questions/33413/continuous-dependent-variable-with-ordinal-independent-variable

https://stats.idre.ucla.edu/r/faq/how-do-i-analyze-survey-data-with-a-stratified-random-sampling-design/

http://powerandsamplesize.com/Calculators/

https://www.surveymonkey.co.uk/mp/sample-size-calculator/

https://stats.stackexchange.com/questions/34636/interpretation-of-simple-predictions-to-odds-ratios-in-logistic-regression/34638#34638

https://stats.stackexchange.com/questions/20523/difference-between-logit-and-probit-models/30909#30909

https://stats.stackexchange.com/questions/86351/interpretation-of-rs-output-for-binomial-regression

http://pgbovine.net/stats.htm

http://www.real-statistics.com/binomial-and-related-distributions/relationship-binomial-and-normal-distributions

Industry related

https://www.forbes.com/sites/gilpress/2017/01/20/6-predictions-for-the-203-billion-big-data-analytics-market/2/#5c4940926782

http://sloanreview.mit.edu/article/why-your-company-needs-data-translators/

http://www.mckinsey.com/business-functions/mckinsey-analytics/our-insights/how-to-win-in-the-age-of-analytics?cid=analytics-eml-alt-mip-mgi-oth-1701

Training related

http://www.city.ac.uk/courses/cpd/advanced-data-analysis

https://www.imperial.ac.uk/study/pg/mathematics/stochastic-analysis/

https://www.rss.org.uk/RSS/Training/Public_courses/RSS/pro_dev/RSS_training_courses_sub/public_training.aspx

https://medium.freecodecamp.org/if-you-want-to-learn-data-science-take-a-few-of-these-statistics-classes-9bbabab098b9

https://medium.freecodecamp.org/an-overview-of-every-data-visualization-course-on-the-internet-9ccf24ea9c9b

https://www.edwardtufte.com/tufte/courses

https://www.datacamp.com/pricing

https://events.rss.org.uk/rss/frontend/reg/thome.csp?pageID=15826&eventID=54&language=1&traceRedir=2&eventID=54