We can see the spreadsheet as a table that allows us to host data and perform calculations with them. Let’s review what a Microsoft Excel spreadsheet is, its history, what similar software exists, and some fun facts.
If you need to make a table with data, you will most likely use a Microsoft Excel spreadsheet . If you need to make a graph, indisputably Excel.
Microsoft Excel is undoubtedly a powerful spreadsheet tool that allows you to load and save simple data or perform a certain range of graphics, to analysis of information, macros for repetitive tasks and programming applications in Visual Basic.
Excel is part of the Microsoft Office Suite , it was born in 1985 and already in the 90’s it had displaced IBM’s Lotus 123 as the great one in the spreadsheet industry .
The Microsoft Excel spreadsheet is perhaps the tool of choice for loading, computing, and displaying mostly quantitative data.
We can see the spreadsheet as a table, an arrangement of rows and columns that allows us to host data and perform calculations or procedures with them.
In this article, let’s review what a Microsoft Excel spreadsheet is , its history, what other similar software options exist, and some fun facts.
What is a Spreadsheet?
Excel is Microsoft’s spreadsheet . We can see the Microsoft Excel spreadsheet as an emulation of a paper worksheet.
In it, users put headings, enter words or numbers in their cells that can both store and process or compute through hundreds of functions or formulas.
A spreadsheet of Microsoft Excel is a document, it is a table, a matrix array of rows and columns whose intersection determines a “cell”“.
The Excel spreadsheet begins as a page of blank cells, in which we add data, usually numeric or alphabetical, that is, information in the form of words or numbers, which we can then manipulate with various calculations and formulas.
The complexity of a spreadsheet made in Excel varies from small text tables with few cells and arithmetic operations to keep accounts; to large documents that can handle thousands of complex calculations, modeling and statistical analysis of thousands of data entries in fractions of a second.
What does the Excel spreadsheet do?
Here is a good summary of what a Microsoft Excel spreadsheet is capable of:
- The Excel spreadsheet as a computer program or software allows us to tabulate and save data. With them we perform calculations, analysis and show graphs.
- Since the spreadsheet is made up of grids called cells, we insert any type of data, generally numeric or text, into them.
- A single cell can contain 32,767 numeric or alphabetic digits.
- These cells can contain only text, numeric data of different formats and countless formulas .
- The Excel formulas will carry out a specific calculation based on the data type housed in the cell or in a combination of data stored in a cell range .
- The results of a formula are dynamic and can change if the content of cells or a range of cells is modified.
- The worksheets in Excel are widely used in the business world because they are useful for presenting monetary information, accounting, budgeting, billing, tax calculations.
- An Excel spreadsheet summarizes and presents the information in different ways, according to the user’s interest.
- A worksheet can interact with other sheets, take and reference the values ??in them, or deliver results.
- The spreadsheet can interact with other applications to import or export data, analysis, and results.
- The information can also be sorted, filtered and presented in a summarized or illustrated way through graphics .
- It is possible to present the information through different graphs such as trends, dispersion, bars or cakes.
- Excel offers the ability to present flexible summaries and reports through its pivot tables .
- Excessively repetitive computations can be automated through Excel Macros .
What other spreadsheets besides Excel are there?
There are dozens of spreadsheet software and applications similar to Microsoft Excel on the market .
To Bite Size of the BBC . com the most popular spreadsheet program is by far Microsoft Office Excel .
The most popular free alternatives include Google Docs that runs from a web browser and Open Office Calc from Apache.
The development houses of office automation packages generally offer their spreadsheet programs as integrated packages with various applications such as word processors or presentation programs.
The information contained in a spreadsheet can be copied from to other software packages that are part of the suites, such as the word processing package.
Thus we have:
- Open Office Calc as a member of the Apache Open Office suite.
- Free Office Calc variant of Open Office
- Gdocs Spreadsheet
- Numbers, as an application built into Apple iWork
- KSpread , the spreadsheet built into the KOffice Suite , known as the free Linux package.
- Corel Quattro Pro, from the Canadian Corel integrated into the WordPerfect Suite .
- Gnumeric from The GNOME Project as part of Gnome Office.
Old or outdated spreadsheets :
- BCL or original IBM Business Computer Language from 1963.
- VisiCalc, for some the first spreadsheet applicable to business, original from 1979.
- 1976 US Railway Association PLDOT Modeling Language
- Compiler spreadsheet LAMPAR of Bell Canada and AT & T, dates from 1969.
- Autoplan programming language & Autotab GE from 1968
- Lotus 1-2-3 from Lotus Development Corporation for IBM released in 1983.
- StarOffice Calc , formerly Oracle Open Office integrated into StarOffice
History of the Excel spreadsheet
As anecdotal data, Microsoft launched its spreadsheet program on the market in 1982 although it did not call it Excel but “Multiplan”. It didn’t gain much popularity against market-dominating giants like Lotus.
The first version of Excel to be taken seriously and to popularize the spreadsheet was Excel for the Macintosh in 1985. Even Lotus was still very strong in the market.
However, in 1987 Microsoft won the race against Lotus Corporation to present its spreadsheet program compatible with Windows, surpassing the also popular Quatro Pro at the time .
Thus, Excel 2.0 for Windows was born in 1987, as Excel 1.0 did not exist for the MSDOS or Windows operating system at that time.
Surprisingly a year later (1988) Microsoft already surpassed Lotus 1-2-3 and Quatro Pro in sales of its spreadsheet package .
1990 welcomes Excel 3.0 and in 1992 Excel 4.0; already with Microsoft dominating the spreadsheet path .
Excel 5.0 appeared in 1993 was the first to include Visual Basic for Applications (VBA). The arrival of VBA Consulting opened almost unlimited possibilities in the systematization of monotonous or repetitive calculations or transcripts to process numbers, automate processes and present data for companies.
From 1995 onwards, Excel began to be marketed not individually but as part of the Office Suite with Excel 95 included (v. 7.0).
From now on we would have:
- Excel 97 (v. 8.0) as part of Office 97
- Excel 2000 (v. 9.0) included in Office 2000
- Excel 2002 (v. 10) in Office XP
- Excel 2003 (v. 11) as Office 2003
- Excel 2007 (v.12) Office 2007.
There was no version 13.0; version 14.0 is Excel 2010; version 15.0 is Excel 2013; Excel 2016 is version 16.0 and was released as Office 2016.
We have Excel v.19.0 under Office 2019 and a new release is expected after 2020.
Fun facts from the Microsoft Excel spreadsheet
Some nostalgic people and experts in spreadsheet software consider that today we could well be working with Lotus 1-2-3 or with “Multiplan” if the fight between Lotus Corporation and Microsoft had taken another direction; struggle in which the Mac operating system had a lot to do with it.
In fact, and as an irony, Microsoft launches Excel to Macintosh users as a strategic decision given the slowness in performance of IBM’s Lotus.
Before being called Excel it was called Multiplan and Microsoft had previously considered other names like ” Master Plan ” or ” Mr. Spreadsheet “. Decanted by Excel perhaps as a diminutive of “excellence” of the program, they were looking for character against the dominant Lotus 1-2-3.
Datarails.com tells us that Excel 3.0 was the first program to introduce the toolbar , a presentation that would become the standard for many desktop applications thereafter.
Lotus 123 incorrectly took 1900 as a leap year. Excel took the same serial date system that Lotus used and makes the same mistake. Although this could be corrected, it brought many incompatibility problems.
A Microsoft Excel spreadsheet can contain up to 512 different fonts, and a single cell can contain up to 32,767 characters.
The number of rows and columns has increased with the evolution of the versions and since 2007 a spreadsheet contains 1,048,576 rows or lines and 16,384 columns; which gives a total of 17,179,869,184 cells. Lots of data to host, huh!
A spreadsheet is a program, a widely used technology for collecting, storing, computing, analyzing, summarizing, and presenting data.
The spreadsheets are represented by tables showing information in the form of matrices or arrays of rows and columns .
They can be displayed as a sheet, a rectangular matrix with rows and columns that determine cells in which the user enters data. These can be computed and analyzed from countless commands and functions available in menus at the top of programs.
The computations developed in the spreadsheets range from simple arithmetic operations (addition, subtraction, products and quotients) to advanced statistical analysis of thousands of data, regressions, correlations, graphs, financial models and repetitive operations that are automated through macros .
Most spreadsheet software allows users to access and perform. All these operations and analysis in real time, on websites, and collaborate across teams and workgroups.
Spreadsheet packages are available for different operating systems such as Linux, Windows, and Mac.
For Encyclopedia.com the most popular spreadsheet software packages have been Lotus 1-2-3, Corel Quattro Pro, and Microsoft Excel. These have historically been offered as part of the IBM, Corel and Microsoft suites respectively; although there are many other spreadsheet applications still around.
The above content published at Collaborative Research Group is for informational purposes only and has been developed by referring to reliable sources and recommendations from experts. We do not have any contact with official entities nor do we intend to replace the information that they emit.