Why use Excel?

Microsoft Office Excel is the most wide-spread computer software for cell-based spreadsheets, used in virtually all larger companies and organisations around the world.

What is a spreadsheet?

A spreadsheet was originally a paper sheet with pre-printed boxes or cells for numbers used in accounting. Each cell could be referred to by its position on the sheet. This convenient layout of rows and columns of cells arranged into tables was moved to computers and became spreadsheet software.

What does spreadsheet software do?

Spreadsheet software, like Excel, helps users to perform calculations on cell values by using mathematical formulas for adding, subtracting, multiplying and dividing numbers. This allows users to create models where the cell values can be changed while the calculation formulas and functions stay the same. Spreadsheets programs therefore make it easy to create models for calculations to study the result from changes to some of the values in the cells.

With time, more complex functions have been introduced to allow more complex calculations, such as performing calculations on values in larger cell areas, and to perform actions on text values, or to make calculations conditional, based on certain criteria, as well as numerous other computational features.

Excel has also added features and tools such as searching, sorting and filtering rows of data, tools for creating charts and diagrams, features for importing data from various sources such as other Excel files, text files and databases, in addition to more decorative measures such as colours, fonts and shapes for illustrations.

Where is Excel used?

Spreadsheets have proven useful in many fields, from accounting, finance, sales and marketing to engineering for complex calculations, and handling test data. Anything from replacing an ordinary calculator to complex calculations in many steps, keeping lists of data, projections, planning, sorting and organising.

Work in Excel can also be fully automated by the use of so-called macros. A macro allows users to record steps and input of formulas in Excel, and then have it replayed automatically by the press of a button. These macros are typically used to quickly create weekly or monthly reports and consolidation of data. For more detailed control, macros are often programmed manually, in a programming language called Visual Basic for Applications (VBA).