Excel Walk through the analytical process one technique at a time. Newest Tutorials Import and Merge Datasets Learn how to import, export, and merge datasets in Excel by using features such as text to columns, vlookup, and hlookup. Organize Your Spreadsheets When you’re staring at a spreadsheet for hours on end, a little organization can go a long way. Clean Data and Recode Variables Before you can analyze your data, you’ll need to check for missing data and recode some variables. Explore Your Dataset Use exploratory data visualization techniques like color-coding and sparklines find initial patterns. Calculate Summary Statistics (with Formulas) Summarize your data by finding the mean, median, standard deviation, and other descriptive statistics. Calculate Summary Statistics (with Pivot Tables) Pivot tables are the fastest, most accurate way to analyze your data — and they’re easier than you think. Putting It All Together Learn intermediate and advanced spreadsheet skills. Extra Time-Saving Techniques
SankeyMATIC (BETA): A Sankey diagram builder for everyone * Flickr Creative Commons | Searchable free usable photos Many Flickr users have chosen to offer their work under a Creative Commons license, and you can browse or search through content under each type of license. Here are some recently added bits and pieces: Attribution (CC BY 2.0) » 95407355 photos (See more) Attribution-NoDerivs (CC BY-ND 2.0) » 25257163 photos (See more) Attribution-NonCommercial-NoDerivs (CC BY-NC-ND 2.0) » 118423716 photos (See more) Attribution-NonCommercial (CC BY-NC 2.0) » 64576491 photos (See more) Attribution-NonCommercial-ShareAlike (CC BY-NC-SA 2.0) » 135529936 photos (See more) Attribution-ShareAlike (CC BY-SA 2.0) » 50066962 photos (See more) Public Domain Dedication (CC0) » 4962727 photos (See more) Public Domain Mark » 14526235 photos (See more) "Creative Commons is a non-profit that offers an alternative to full copyright." creativecommons.org Briefly... Attribution means: You let others copy, distribute, display, and perform your copyrighted work - and derivative works based upon it - but only if they give you credit.