Questions tagged [excel]

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 & 2013)

Questions tagged with excel should be version-agnostic. More specific tags include:

• vba for programming,
• excel-formula and worksheet-function for formulas (which are normally more suited to SuperUser),
• 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 and excel-2019.

^{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] 16
• 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