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) » 95837677 photos (See more) Attribution-NoDerivs (CC BY-ND 2.0) » 25345689 photos (See more) Attribution-NonCommercial-NoDerivs (CC BY-NC-ND 2.0) » 119589745 photos (See more) Attribution-NonCommercial (CC BY-NC 2.0) » 65104034 photos (See more) Attribution-NonCommercial-ShareAlike (CC BY-NC-SA 2.0) » 136092927 photos (See more) Attribution-ShareAlike (CC BY-SA 2.0) » 50523569 photos (See more) Public Domain Dedication (CC0) » 5168872 photos (See more) Public Domain Mark » 15370610 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.