background preloader

CP021: How to quickly compare 2 lists in Excel

CP021: How to quickly compare 2 lists in Excel

PSPP - GNU Project PSPP 2.0.0-pre1 has been released. GNU PSPP is a program for statistical analysis of sampled data. It is a free as in freedom replacement for the proprietary program SPSS, and appears very similar to it with a few exceptions. The most important of these exceptions are, that there are no “time bombs”; your copy of PSPP will not “expire” or deliberately stop working in the future. Neither are there any artificial limits on the number of cases or variables which you can use. PSPP is a stable and reliable application. A brief list of some of the PSPP's features follows below. Support for over 1 billion cases. PSPP is particularly aimed at statisticians, social scientists and students requiring fast convenient analysis of sampled data. Downloading PSPP As with most GNU software, PSPP can be found on the main GNU ftp server: (via HTTP) and (via FTP). There are some additional ways you can download or otherwise obtain PSPP. Documentation

Contextures Excel Tips, Excel Tutorials and Excel Examples free statistical software click here to return to methods page click here to return to social change page This page lists primarily statistical software, along with mapping, spreadsheets, database, stuff to do data analysis or management. All of the packages are free to use, that is: there is no charge for individuals to use them. Many of the websites say that individuals are free to download and use the packages. Please note: I've only used a few of these software programs a little bit, so I can't say much about how good they are, whether they crash, have viruses, or much else about them. Statistics There are many free statistical programs. Several of these stat programs were reviewed in an article in the Journal of Industrial Technology, (Volume 21-2, April 2005). "A Short Preview of Free Statistical Software Packages for Teaching Statistics to Industrial Technology Majors" Ms. Other lists of free stat software John C. Betty Jung's page

The Spreadsheet Page - By John Walkenbach Tableau Data Reshaper How To 1 Learn Excel Online From 40 Free Excel Tutorials & Reference Sites Nothing beats getting something for nothing! When it comes to learning Microsoft Excel, the same holds true. Excel is such an important software application, many organizations have taken it upon themselves to publish free Excel tutorials and how-to guides. The amount of free content available online is truly staggering. There are tons of free Excel tutorials online but its a full time job to sift through them all and find the good ones. Earlier this week we wrote about 5 Excel Experts who are on a mission to help the world learn Microsoft Excel. Many free tutorials are bait for a larger purchase. ImproveYourExcel is a clean looking site with over 60 introductory video tutorials for Excel 2010. The Excel Function Dictionary is a free workbook download that allows you to search for different functions and learn how to use them. The Barnard Library site is another EDU site with good tutorial content for Mac for Excel 2011 and Excel 2010 for PC’s. Test Your Excel Skills Powered by Interact

Top 10 Spreadsheet Secrets From A Nonprofit Data Nerd Note from Beth: I made a personal goal for myself to get past my dislike of spreadsheets and become more fluent. First I had to “Stop Fearing the Spreadsheet” and then started to interview nonprofit data nerds about their Excel secrets. Why get good at Excel? Even if you are using a paid tool measure your results, knowing how to use a spreadsheet well will be invaluable to your measurement program. While writing the “Measuring the Networked Nonprofit,” and now teaching workshops on strategy and measurement for networked nonprofits, I realize that knowing how to use excel to set up and automate a dashboard, integrate data from exported from different programs, get insights, and make it visual are basic data literacy skills. And, knowing a few secrets will help you save time. Top 10 Secrets of Excel Data Nerds By Ann Emery I read Beth’s post, Help! Here are the top 10 things you need to know in Excel to become a data nerd: Secret #10. Secret #9. Secret #8. Secret #7. Secret #6. Secret #5.

Excel Templates, Calendars, Calculators and Spreadsheets by Vertex42 MrExcel.com | Excel Resources | Excel Seminars | Excel Products

Related: