Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Microsoft Office documentation

Excel 2010 for Windows

Excel 2011 for Mac

Excel 2013 for Windows

What's the Difference between a Spreadsheet and a Database?

Microsoft Exel is a spreadsheet program. Other spreadsheet programs include Calc (OpenOffice.org - Mac and PC platforms), Numbers (iWorks for the Mac), Lotus 1-2-3 (IBM for PCs, though this will no longer be supported after September 30, 2014), and many others. The most important information to know about spreadsheets is that they have limits and a spreadsheet is not the right tool for every for every project. Spreadsheets are great for doing calculations for small data sets, tracking small data sets over the short term, and visually presenting data. Databases are better at tracking large data sets with complex relationships and are meant to be used over long periods. They can also perform calculations on large data sets.

Penn State University Libraries Technology Training's has created a set of guidelines for determining whether or not your project is suitable for a spreadsheet or a database.

Pages that exist currently but need to be combined onto this page:

http://depts.drew.edu/its/docs/desktop/microsoft/Office/Excel/XP/index.php and its child pages (then needs to be removed)

Professional Development - Basic Spreadsheet Skills 

Professional Development - Intermediate Spreadsheet Skills

Professional Development - Advanced Spreadsheet Skills

 

Understanding the Basics of Excel

http://office.microsoft.com/en-us/excel-help/basic-tasks-in-excel-2010-HA101829993.aspx#_Toc256078356

 

 

Creating Graphs in Excel

http://www.ncsu.edu/labwrite/res/gt/gt-menu.html

 

Basic Calculations in Excel