Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.
- What Kind Of Applications Package Is Excellent
- What Kind Of Applications Package Is Excel Spreadsheet
The following is a list of spreadsheets.
- Working with Excel Files in Python. This site contains pointers to the best information available about working with Excel files in the Python programming language. Reading and Writing Excel Files. There are python packages available to work with Excel files that will run on any Python platform and that do not require either Windows or Excel to.
- This way, you will know which types of software you should be familiar with. Many jobs require use of the basic Microsoft Office suite: Word, Excel, Outlook and Power Point. More specialized jobs.
Free and open-source software[edit]
Cloud and on-line spreadsheets[edit]
- Collabora Online Calc — Based on LibreOffice with more options and with commercial support.
- Sheetster – 'Community Edition' is available under the Affero GPL
- Tiki Wiki CMS Groupware includes a spreadsheet since 2004 and migrated to jQuery.sheet in 2010.[1]
Spreadsheets that are parts of suites[edit]
- Collabora Office Calc — Based on LibreOffice with commercial support, it is also available for many operating systems including Windows, macOS, LInux, Android, iOS and Chrome OS.
- Gnumeric — for Linux. Started as the GNOME desktop spreadsheet. Reasonably lightweight but has very advanced features.[2]
- KSpread — following the fork of the Calligra Suite from KOffice in mid-2010, superseded by KCells in KOffice and Sheets in the Calligra Suite.[3]
- LibreOfficeCalc — developed for MS Windows, GNU/Linux, BSD and Apple Macintosh (Mac) operating systems by The Document Foundation. The Document Foundation was formed in mid-2010 by several large organisations such as Google, Red Hat, Canonical (Ubuntu) and Novell along with the OpenOffice.org community (developed by Sun) and various OpenOffice.org forks, notably Go-oo. Go-oo had been the 'OpenOffice' used in Ubuntu and elsewhere. Started as StarOffice in the late 1990s, it became OpenOffice under Sun and then LibreOffice in mid-2010. The Document Foundation works with external organisations such as NeoOffice and Apache Foundation to help drive all three products forward.[4]
- NeoOffice Calc — for Mac. Started as an OpenOffice.org port to Mac, but by using the Mac-specific Aquauser interface, instead of the more widely used X11 windowing server, it aimed to be far more stable than the normal ports of other suites.[5]
- OpenOffice.orgCalc — for MS Windows, GNU/Linux and the Apple Macintosh. Started as StarOffice. Sun changed the name to OpenOffice.org and developed a community of developers (and others) between the late 1990s and mid-2010. Oracle gave it to the Apache Foundation in 2011. IBM contributed their fork of OpenOffice.org, IBM Lotus Symphony, to Apache a few weeks later.[6]
- Siag — for GNU/Linux, OpenBSD and Apple Mac OS X. A simple old spreadsheet, part of Siag Office.[7]
- Sheets — for MS Windows, GNU/Linux, FreeBSD, Apple Mac OS X and Haiku. Part of the extensive Calligra Suite. Possibly still mainly for Linux, but ports have been developed for other operating systems.[8]
Standalone spreadsheets[edit]
Proprietary software[edit]
Online spreadsheets[edit]
- EditGrid – access, collaborate and share spreadsheets online, with API support; discontinued since 2014
- Google Sheets – as part of Google Docs
- Zoho Sheet Spreadsheet on the cloud that allows real-time collaboration and more, for free.
- iRows – closed since 31 December 2006
- JotSpot Tracker – acquired by Google Inc.
- Smartsheet – Online spreadsheet for project management, interactive Gantt, file sharing, integrated with Google Apps[9]
- ThinkFree Online Calc – as part of the ThinkFree Office online office suite, using Java
- Airtable - a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.
Spreadsheets that are parts of suites[edit]
- Ability Office Spreadsheet – for MS Windows.
- Apple iWorkNumbers, included with Apple's iWork '08 suite exclusively for Mac OS X v10.4 or higher.
- AppleWorks – for MS Windows and Macintosh. This is a further development of the historical Claris Works Office suite.
- WordPerfect OfficeQuattro Pro – for MS Windows. Was one of the big three spreadsheets (the others being Lotus 123 and Excel).
- EasyOffice EasySpreadsheet – for MS Windows. No longer freeware, this suite aims to be more user friendly than competitors.
- Framework – for MS Windows. Historical office suite still available and supported. It includes a spreadsheet.
- IBM Lotus Symphony – freeware for MS Windows, Apple Mac OS X and GNU/Linux.
- Kingsoft Office Spreadsheets 2012 – For MS Windows. Both free and paid versions are available. It can handle Microsoft Excel .xls and .xlsx files, and also produce other file formats such as .et, .txt, .csv, .pdf, and .dbf. It supports multiple tabs, VBA macro and PDF converting.[10]
- Lotus SmartSuiteLotus 123 – for MS Windows. In its MS-DOS (character cell) version, widely considered to be responsible for the explosion of popularity of spreadsheets during the 80s and early 90s.[citation needed]
- MarinerPak Mariner Calc – for Apple Macintosh. Full featured and light weight.
- Microsoft OfficeExcel – for MS Windows and Apple Macintosh. The proprietary spreadsheet leader.
- Microsoft Works Spreadsheet – for MS Windows (previously MS-DOS and Apple Macintosh). Only allows one sheet at a time.
- PlanMaker – for MS Windows, GNU/Linux, MS Windows Mobile and CE; part of SoftMaker Office
- Quattro Pro – part of WordPerfect Office
- StarOffice Calc – Cross-platform. StarOffice was originally developed by the German company Star Division which was purchased by Sun in 1998. The code was made open source and became OpenOffice.org. Sun continues developing the commercial version which periodically integrates the open source code with their own and third party code to make new low price versions.
Stand alone spreadsheets[edit]
- As-Easy-As – from Trius, Inc.; unsupported; last MS-DOS and Windows versions available with free full license key.
What Kind Of Applications Package Is Excellent
Multi-dimensional spreadsheets[edit]
Spreadsheets on different paradigms[edit]
[clarification needed]
- DADiSP – Combines the numerical capability of MATLAB with a spreadsheet like interface.
- Resolver One – a business application development tool that represents spreadsheets as IronPython programs, created and executed in real time and allowing the spreadsheet flow to be fully programmed
Spreadsheet-related developmental software[edit]
- ExtenXLS – Java Spreadsheet Toolkit.
Specifications[edit]
Program | Rows (per sheet) | Columns (per sheet) | Total Cells (per sheet) | Sheets | Total Cells (per workbook) |
---|---|---|---|---|---|
Collabora Office Calc | 1,048,576 | 1,024[11] | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
Gnumeric | 16,777,216 | 16,384 | 274,877,906,944 | 142,648 | 603,103 |
KSpread | 32,767 | 32,767 | 1,073,676,289 | 130,645 | 953,923 |
LibreOffice Calc 6.0 - 6.4, 7.0 and 5.4.5 | 1,048,576 | 1,024[11] | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
Lotus 1-2-3[12] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
Microsoft Excel 2003 | 65,536 | 256 | 16,777,216 | 65,531 | 1,099,427,741,696 |
Microsoft Excel 2007, or later versions[13][14][15] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
OpenOffice.org Calc 2[16] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
OpenOffice.org Calc 3.0, 3.1 and 3.2[17][18] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
OpenOffice.org Calc 3.3[19] | 1,048,576 | 1024 | 1,073,741,824 | 256 | 274,877,906,944 |
Pyspread | ~80 000 000 (limited by sum of row heights) | ~30 000 000 (limited by sum of column widths) | Limited by available memory | Limited by available memory | Limited by available memory |
Resolver One | limited by machine memory* | limited by machine memory* | limited machine memory* | limited by machine memory* | limited by machine memory* |
-* 32-bit addressable memory on Microsoft Windows, i.e. Blender models online. Premier video editor. ~2.5 GB.
Historical[edit]
- VisiCalc The first widely used normal spreadsheet with A1 notation etc.
- Lotus 1-2-3 Took the market from Visicalc in the early 1980s.
- Lotus Improv Novel design that went beyond A1 notation.
- Multiplan Early version of Excel.
- 20/20 Multiplatform competitor to 1-2-3 with database integration and real-time data updating.
- 3D-Calc multi-dimensional spreadsheet for Atari ST[20]
- SuperCalc – CP/M-80 Included with early Osborne computers. It also was ported to MS-DOS and to Microsoft Windows.
- Dynacalc — from Computer Systems Center, similar to VisiCalc. It was designed to run on Microware's OS-9, a Unix-like operating system.[21]
- VP Planner – Similar in look and feel to Lotus 1-2-3, but included 5 level multi-dimensional database[22]
- Wingz Multi Dimensional Spreadsheet from Informix (1988)
- Boeing Calc – was a spreadsheet package written by subsidiary of aviation manufacturer Boeing (1985).
What Kind Of Applications Package Is Excel Spreadsheet
See also[edit]
References[edit]
- ^Spreadsheet, Tiki.
- ^'Gnumeric', Office (downloads), Gnome.
- ^The KOffice Project, archived from the original on 2005-12-31, retrieved 2006-03-02.
- ^LibreOffice.
- ^NeoOffice.
- ^OpenOffice.org.
- ^'Scheme In A Grid'. NU: Siag. 2000-12-07. Retrieved 7 March 2017.
- ^The Calligra Suite.
- ^Apps Marketplace Profile, Google.
- ^Spreadsheets, Kingsoft.
- ^ ab'16384 columns limit is a setting under experimental features'. documentfoundation.org.
- ^'Limitations of 1-2-3 for Windows'. IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.
- ^'What is the maximum number of cells in an OpenOffice.org spreadsheet?'. FAQ. OpenOffice.org. Retrieved 2008-04-10.
- ^'What's the maximum number of rows and cells for a spreadsheet file?'. Calc FAQ. OpenOffice.org. Archived from the original on 2009-05-04. Retrieved 2008-11-04.
- ^'OpenOffice.org 3.0 New Features'. 3.0 Features. OpenOffice.org. Retrieved 2008-11-10.
- ^'OpenOffice.org 3.3 New Features'. 3.3 Features. OpenOffice.org. Retrieved 2010-12-13.
- ^Frank Schoonjans, '3D-Calc', Atari ST.
- ^'Dynacalc'(PDF) (manual). Tandy. Retrieved April 13, 2015.
- ^Stephenson, James; Brothers, Kent; Mitchell, Dave (December 1, 1986). VP-Planner: Spreadsheet Flexibility with Database Powe. Paperback Software International, Stephenson Software. ISBN0-87142021-X.
Retrieved from 'https://en.wikipedia.org/w/index.php?title=List_of_spreadsheet_software&oldid=997435494'
General
Introduction to Computer
Classification of Computer
Computer System
Operating System
Programming Concept
Application Package
REMAINING / EXTRAS:
MS Excel allows us to keep the header and footer in our spreadsheet document.
2. Find and Replace Command
MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering ranges:
• AutoFilter; which includes filter by selection, for simple criteria
Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in ascending or descending order.
6. Built-in formulae
MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our needs.
7. Create different charts (Pivot Table Report)
MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This helps us to analyze and compare data very easily.
8. Automatically edits the result
MS Excel automatically edits the result if any changes are made in any of the cells.
9. Formula Auditing
Using formula auditing we can graphically display or trace the relationships between cells and formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the cells that depend on the value in a specific cell).