Good researchers are constantly trying to learn new skills. Whether brushing up on their stats knowledge or working through matplotlib tutorials, they recognize that learning new skills makes them more productive–plus it can be very fun! There are a lot of awesome tutorials on the web and we don’t pretend to be experts on any of these skills, just competent Googlers looking to save you time an aggravation. We’ve compiled as list of crash courses that introduce helpful research tools so you can begin to incorporate them into your work.

## Intro to Excel:

Excel skills can be split up into three basic categories: basic, intermediate, and advanced. All of them can be catamount for creating useful, presentable excel documents.

This video details the basics of making graphs from the data you possess.

# Excel 2010: Charts Getting Started

# Excel Tables Tutorial #1 How to Create and Use Excel Tables

# Excel Tables Tutorial #2 How to Create and Use Excel Tables

# Excel Tables Tutorial #3 How to Create and Use Excel Tables

# Excel: How to Create Formulas - Calculations

# Excel 2013 Tutorial Using AutoSum Microsoft Training Lesson 4.4

# Excel PivotTables

# Excel 2013 Recording Macros Microsoft Training Lesson 37.1

# Excel 2013 - Top 10 Keyboard shortcuts

# Excel 2013 Tutorial - Auto Fill (linear and growth)

This website provides a large number of advanced formulas, under the “formulas” section, so simply click on the tutorial you need, and it will link you to a useful video.

http://www.jargonfreehelp.com/excel-tutorials/

## A quick intro to statistics: highlights from Kahn Academy

# Statistics: The average | Descriptive statistics | Probability and Statistics | Khan Academy

# Statistics: Variance of a population | Probability and Statistics | Khan Academy

# Statistics: Sample variance | Descriptive statistics | Probability and Statistics | Khan Academy

# Introduction to Random Variables

# Law of large numbers | Probability and Statistics | Khan Academy

# Normal distribution excel exercise | Probability and Statistics | Khan Academy

# Introduction to the normal distribution | Probability and Statistics | Khan Academy

# Central limit theorem | Inferential statistics | Probability and Statistics | Khan Academy

# Sampling distribution of the sample mean | Probability and Statistics | Khan Academy

# Standard error of the mean | Inferential statistics | Probability and Statistics | Khan Academy

# ck12.org normal distribution problems: z-score | Probability and Statistics | Khan Academy

# Margin of error 1 | Inferential statistics | Probability and Statistics | Khan Academy

# Margin of error 2 | Inferential statistics | Probability and Statistics | Khan Academy

# Hypothesis testing and p-values | Inferential statistics | Probability and Statistics | Khan Academy

# One-tailed and two-tailed tests | Inferential statistics | Probability and Statistics | Khan Academy

# Z-statistics vs. T-statistics | Inferential statistics | Probability and Statistics | Khan Academy

# Regression line example | Regression | Probability and Statistics | Khan Academy

More videos like the ones linked can be found here:

https://www.khanacademy.org/math/probability

We also recommend this free online textbook:

http://www.ck12.org/statistics/

References:

- Hand, D. J. (2008).
*A very short introduction.*Oxford: Oxford University Press. - Kahn Academy