Only for questions on programming against Excel objects or files, or formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. Do NOT use with other spreadsheet software like [google-sheets].
Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, sorting and filtering data, pivot tables and a macro programming language called Visual Basic for Applications (VBA).
Languages and environments for programming against Excel include:
- Visual Basic for Application (VBA) - inside Excel
- Worksheet Functions / Formulas - inside Excel
- Visual Studio Tools for Office (VSTO) - Visual Studio
- Office Interop - Visual Studio and Mono
- SQL against Excel data, using DAO/ACE or ADO
- Open XML and Open XML SDK - Any environment and .NET, respectively
- Excel Services - SharePoint
- Power Query [aka Get & Transform] (M) - inside Excel (from 2016 onwards, available as an AddIn for Excel 2010 & 2013)
- Power Pivot (DAX) - inside Excel (from 2016 onwards, available as an AddIn for Excel 2010 and 2013)
Questions tagged with excel should be version-agnostic. More specific tags include:
- vba for programming,
- excel-formula and worksheet-function for formulas,
- pivot-table for pivot tables,
- excel-addins for addins,
- powerquery for Power Query (aka Get & Transform),
- powerpivot for Power Pivot.
Version-specific tags include excel-2000, excel-2002, excel-2003, excel-2007, excel-2008, excel-2010, excel-2011, excel-2013, excel-2016, excel-2019, excel-365
Microsoft Excel 2010 on Windows 7
More information
- Microsoft Excel Wikipedia article
- Microsoft Office Wikipedia article
- Product homepage
- Decline of Lotus 1-2-3
Useful resources
- Microsoft Office VBA Reference
- Getting Started with VBA in Office
- Daily Dose of Excel Blog
- Chip Pearson site
- John Walkenbach's Spreadsheet Page
- A list of Excel websites run by current and former Microsoft Excel MVPs is available here.
Official logo
Logo image source: https://products.office.com/en-au/products