Microsoft Excel

Microsoft Excel is a spreadsheet application for organizing data in cells, calculating with formulas, analyzing information, and creating visualizations.

Spreadsheet: A grid-based document for storing, organizing, and calculating with data. Excel is one widely used application for creating and editing spreadsheets.
Automatic recalculation: A spreadsheet behavior that updates dependent formula results when referenced values change. Excel normally recalculates affected formulas after an input changes.
PivotTable: An interactive Excel tool for grouping, aggregating, and rearranging tabular data summaries. PivotTables quickly summarize large lists without rewriting their source data.
Google Sheets: Google’s web-based spreadsheet application with real-time collaboration and cloud storage. It offers a spreadsheet workflow similar to Excel, with collaboration centered on the browser.
Cell (spreadsheet): A single intersection of a spreadsheet row and column that can hold a value or formula. Cells are Excel’s basic units for entering data and calculations.
Relative and absolute cell references: Spreadsheet reference styles that either adjust or remain fixed when formulas are copied. Excel’s copy-and-fill behavior depends on whether references are relative or absolute.
Power Query: A data connection and transformation technology used to import, clean, and reshape data. Excel uses Power Query to prepare data through repeatable transformation steps.
LibreOffice Calc: The spreadsheet application included in the LibreOffice open-source office suite. Calc is a desktop alternative that can open and save many Excel file formats.
Cell reference: An address identifying a cell or range in a spreadsheet, such as A1 or B2:B10. Excel formulas use references to retrieve and calculate values across cells.
Dynamic array: An array calculation whose results can occupy multiple neighboring cells and resize as inputs change. Modern Excel formulas can spill results into adjacent cells automatically.

Linked from 5 pages